Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced MySQL 8 Discover The Full Potential Of MySQL And Ensure High Performance Of Your Database

Authors: Eric Vanier ,Birju Shah ,Tejaswi Malepati

1st Edition

1788834445, 978-1788834445

More Books

Students also viewed these Databases questions