on the documents

1 answer below »
Answered Same DayOct 25, 2021

Answer To: on the documents

Deepti answered on Oct 25 2021
115 Votes
Primary Keys:
· Each Department has a unique identification number Department _ID
· Each Instructo
r has a unique identification number Instructor_ID
· Each Course has a unique identification number Course_ID
· Each student has a unique identification number Student_ID
Attributes:
· Each Department shall have Department Name, Phone Number, Major
· Each Instructor shall have Name, Office Address, Phone Number, Rank, Department_ID
· Each course shall have Course Title, Course Hours
· Each student shall have First Name, Last Name, Address, City, State, Zip, Enrollment Date
· Each enrollment shall have Course_ID and Student_ID as Primary Key and Department_ID as attribute. All will refer to primary keys of their respective entities.
Relationships
· Each department shall have...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here