Question: 2 . AT &T needs a database in order to maintain track of its consumers, subscription plans, and mobile phones. The essential elements of
AT&T needs a database in order to maintain track of its consumers, subscription plans, and mobile phones. The essential elements of importance to the operator, as well as their relationships, are depicted in the ER diagram below. Answer the following questions using the illustration as a guide and explain your reasoning. Identify the elements in the ER diagram that you utilized to determine your answer for each question. pts
For example:
Can prospective Manufactures that did not produce any Handset types be represented on this diagram?
Answer: Yes. Relationship between manufacturer and Handset Type are optional on Handset side. Or any other explanation in ER terms that supports your answer Questions: please typeinsert your answers below
Can a customer have an unlimited number of plans?
Can a customer exist without a plan?
Is it possible to create a plan without knowing who the customer is
Does the operator want to limit the types of handsets that can be linked to a specific plan type?
Is it possible to maintain data regarding a handset without connecting it to a plan?
Can a handset be associated with multiple plans?
Assume a handset type exists that can utilize multiple operating systems. Could this situation be accommodated within the model included in the Figure?
Is the company able to track a manufacturer without maintaining information about its handsets?
There are two relationships between Customer and Plan. Explain how they differ.
Characterize the degree and the cardinalities of the relationship that connects Customer to itself. Explain its meaning.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
