Question
The diagram below represents a partial solution (ERD diagram) that includes some of the entities listed above. A number of entities on the list above
The diagram below represents a partial solution (ERD diagram) that includes some of the entities listed above. A number of entities on the list above are missing from the diagram.
Your task is to include the missing entities into the diagram below by REDRAWING the diagram in MS Visio (save it is a SEPARATE Visio file from the one used for Part 1 above) and then adding the missing entities. Make sure you provide:
-(5 points) relevant attributes, including a primary key for each new entity that you add to the diagram
-(5 points) adequate relationships among the new entities and those currently represented in the diagram.
-(10 points) Generalization / specialization relationships (with associated constraints)
MEDIA ROOM PROVIDES PK Building ID PK Room No PK MtypeID Media Type Media Type Desc Room Capacity Room Type TIMESLOT TRAINED FOR PREFERS PK IS ID Day of Week Start Time End Time LAB CLASSROOM Board Type INSTRUCTOR SCHEDULE PK Emp ID PK Sched ID CONTAINS Emp Name Emp Rank Emp Office Phone Te COMPUTER SECTION PK Section ID EnrLimit Sem Year Computer Type Type Description Processor Speed Disk Capacity COURSE PK Course ID Course Desc Course Credits PREREQUISITE MEDIA ROOM PROVIDES PK Building ID PK Room No PK MtypeID Media Type Media Type Desc Room Capacity Room Type TIMESLOT TRAINED FOR PREFERS PK IS ID Day of Week Start Time End Time LAB CLASSROOM Board Type INSTRUCTOR SCHEDULE PK Emp ID PK Sched ID CONTAINS Emp Name Emp Rank Emp Office Phone Te COMPUTER SECTION PK Section ID EnrLimit Sem Year Computer Type Type Description Processor Speed Disk Capacity COURSE PK Course ID Course Desc Course Credits PREREQUISITE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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