Section A:  Use the following tables to create a database called College.  Use SQL commands.

Student

Faculty

Class

Enroll

1.  Create the database College.

2.  Create the table Student.

3.  Create the table Faculty.

4.  Create the table Class.

5.  Create the table Enroll.

6.  Create all foreign keys

Section B:  Using the database in Section A.  Answer all questions.

7. Create a view that finds the student name, major and enrolled in the art class

8. Create a view that finds the student name, and classes enrolled

9. Create a stored procedure that finds the name of faculty and their schedule

10. Create a stored procedure that finds the student names for a particular course.

11.  Create a role called students; give SELECT permission.  Use a cursor to add all students as members of the above.  Setup each student as a user with temporary password of first four letter of last name and add '8888'.

12.  Convert to XML the student table.

Section C:  Using the Halloween database.

13.  Create a table called ProductImages which has the following fields ImageID (int, primary key, identity), productid (varchar), and ImageProduct (varbinary(max)).