Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In a series of in-class assignments, we identified entities that represent things evident within our classroom. By consensus, we settled on 10 entities and developed
In a series of in-class assignments, we identified entities that represent things evident within our classroom. By consensus, we settled on 10 entities and developed rough-cut ERD diagrams that represented those entities and their associated relationships. Those entities were: 1. Equipment; 2. Furniture; 3. Person 4. Course-Content; 5. Fixture 6. Classroom 7. Book; 8. Course 9. Student (this entity is used instead of the stationery entity that was in the in class assignment); 10. Class Session (also called TIME SLOT) 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 diagramm (5 points) adequate relationships among the new entities and those currently represented in the diagram. (10 points) Generalization/specialization relationships (with associated constraints) In a series of in-class assignments, we identified entities that represent things evident within our classroom. By consensus, we settled on 10 entities and developed rough-cut ERD diagrams that represented those entities and their associated relationships. Those entities were: 1. Equipment; 2. Furniture; 3. Person 4. Course-Content; 5. Fixture 6. Classroom 7. Book; 8. Course 9. Student (this entity is used instead of the stationery entity that was in the in class assignment); 10. Class Session (also called TIME SLOT) 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 diagramm (5 points) adequate relationships among the new entities and those currently represented in the diagram. (10 points) Generalization/specialization relationships (with associated constraints)
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