|Perfect Number of Pages to Order||5-10 Pages|
indicating identifiers and cardinality constraints
Q1. Ali has a large DVD movie collection. His friends like to borrow his DVD’s, and he needs a way to keep track of who has what. He maintains a list of friends, identified by unique FID’s (friend identifiers) and a list of DVD’s, identified by DVD_ID’s (DVD identifiers). With each friend is the name: First name and last name, and the all-important telephone numbers which he can call to get the DVD back. With each DVD is the star actor name and title. Whenever a friend borrows a DVD, Ali will enter that fact into his database along with the date borrowed. Whenever the DVD gets returned, that fact, too, gets noted along with the date returned. Ali wants to keep a complete history of his friends’ borrowing habits so that he can ask favors of the heavy borrowers (or perhaps refuse to make further loans to those who habitually do not return them quickly).
a). As a system analyst, construct a conceptual ER/ EER diagram for the DVD rental database. Be certain to indicate identifiers and cardinality constraints.
b). Based on the given case and your conceptual ER/ EER diagram, construct the logical relational model for the DVD rental database.
Q2. Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, childrens toys, etc.). The following ER diagram captures important information in the tracking of production. Specifically, the ER diagram captures relationships between production lots (or batches), individual production units, and raw materials. As a database designer, convert the below ER model into a well-structured relational model.