Question: 1- This figure shows an enterprise data model for a music store. a) What is the relationship between Album and Store (one to one, many


1- This figure shows an enterprise data model for a music store. a) What is the relationship between Album and Store (one to one, many to many or one to many)? b) What is the relationship between Artist and Album? c) Do you think there should be a relationship between Artist and Store? Describe at least one scenario that justifies such a relationship? A cellular operator needs a database to keep track of its customers, their subscription plans, and the headsets (mobile phones) that they are using. The ER diagram illustrates the key entities of interest to the operator and the relationships between them. Based on figure, answer the following questions, and explain the rational for your response. For each question identify the elements in the ER diagram that you need to determine your answer. a) Can a customer have an unlimited number of plans? b) Can customers exist without a plan? c) Is it possible to create a plan without knowing who the customer is? d) Does the operator want to limit the types of handsets that can be linked to a specific plan type? e) Can a headset be associated with multiple plans? f) Assume a headset type exists that can utilize multiple operating systems. Could this situation be accommodated within the model included in the figure? g) Is the company able to track a manufacturer without maintaining information about its handsets? h) Can the same operating system be used on multiple handset types? i) There are two relationships between Customer and Plan. Explain how they differ? j) Characterize the degree and the cardinalities of the relationship that connects Customer to itself? Explain its meaning? k) Can the company track a handset without identifying its operating system
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
