Use the following business rules to draw the fully labeled Crow\'s Foot ERD in V

Question

Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company rents many locations. Each location hosts many dinners, but each dinner is scheduled at one location only. b). Each dinner may or may not be attended by many guests. The number of guests is limited to 100 per dinner. c). Each guest may attend many dinners. d). Each dinner is based on a single entree, but each entree can be served at many dinners. The number of dinners per entree is limited to three

Explanation / Answer

A customer can rent many tapes.

A tape can be rented by many customers.

Some customers do not rent tapes.

(Such customers might buy tapes or

other items.) Therefore, TAPE is

optional to CUSTOMER in the

rental relationship.

Some tapes are never rented.

Therefore, CUSTOMER is optional

to TAPE in the rental relationship.

A completed ER diagram is the actual blueprint of the database. Its composit

ion must reflect an

organization's operations accurately if the database is to meet that organization's data requirements. It forms

the basis for a final check on whether the included entities are appropriate and sufficient, on the attributes

found within

those entities, and on the relationships between those entities. It is also used as a final

crosscheck against the proposed data dictionary entries. The completed ER diagram also lets the designer

communicate more precisely with those who commissioned the

database design. Finally, the completed ER

diagram serves as the implementation guide to those who create the actual database. In short, the ER

diagram is as important to the database designer as a blueprint is to the architect and builder

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.