Question
Design question ((( Database System Design and Management ))) You have been asked to design a database for a University. Three tables are required. Faculty,
Design question ((( 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)
List the structure for each table. Use the notation that I have listed below under Note.
For each table identify and list 5 attributes and list data type for each attribute.
For each table identify Primary Key and Foreign Key.
Describe the relationship between these tables.
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, repId)
Data type:
customerId numeric
lastName string
firstName string
phone string
email string
repId numeric
Sample record
Customer ( 442321, Anderson, John, 703-456-,1123,, 77623)
If you do not use the notation that I have listed above, GRADE ZERO WILL BE ISSUED FOR this question.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started