IT507: Database System Design and Management

You have been asked to design a database for a University. Three tables are required. Faculty, Students, Courses. (40 points) 1) List the structure for each table. Use the notation that I have listed below under Note. 2) For each table identify and list 5 attributes and list data type for each attribute. 3) For each table identify Primary Key and Foreign Key. 4) Describe the relationship between these tables. 5) Show sample record for each table. Following are business rules: Students can take many courses. Faculty can teach many courses. Each student is assigned a faulty as advisor. Note: To show the structure for each table you must use the following notation: Your answer must be similar to following: Table_Name ( Primary Key, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, foreignKey) Following is an example of how you should list the structure for each table. Let's say you want to show the structure for a Customer Table. Following is how to write the structure for Customer table and Sample record. Your answer for table Faculty, Course, Student must be similar to the following: Customer table structure Customer ( Cistomer_ID, lastName, firstName, Phone, Email, repld) Data type: Sample record Customer ( 442321, Anderson, John, 703-456-1123, andy@gmail.com, 77623) If you do not use the notation that I have listed above, GRADE ZERO WILL BE ISSUED FOR this