Assignment (6)
CS3430 Due Wednesday Nov. 19
Question (1) 60 points
1. Consider the database shown in Figure 1.2 whose schema is shown in figure 2.1.
B) Implement the database shown in Figure 1.2 in MySQL.  Populate the database with given data.  Print a copy of the MySQL scripts that you have used to create the database and to populate it.  Submit the results of:
a. show tables,
b. describe table for each individual table.
c. and select * for all tables.

A) Write the following three queries in SQL and run it in MySQL.  Save each query and the corresponding results and submit the file.
a. List names, student numbers, and majors for students who have taken a course in the CS department.
b. List names, ID, and the total number of credit hours they have taken
c. List the courses which have two or more courses as their prerequisite with the department that is offering those courses.

If you wish you can submit one file by e-mail for all of the things you have done above.  But, please make sure each part is clearly marked.

2. Question 8.14 -  20 points

3. Question 8.16 (Parts C and E only) 20 points