Draw the Entity Relationship Diagram (ERD) of the following narrative. Ensure that only the required entities, relationships, cardinalities, attributes and keys are represented. All relationship lines should be solid lines regardless of whether they are strong or weak relationships.

“Loose Talk” is a cellphone service provider which needs to keep track of its SIM cards and the services it provides to its customers. When a customer buys a SIM card, he/she chooses the billing plan for that SIM card. The billing plans may be billing per second, billing per minute, billing per day, billing per week, and billing per month. In addition, the customer can choose from among a number of services for his/her SIM card. The services include call line identity, international roaming, call diverting, call waiting, etc. When a customer purchases a SIM card, the customer’s name and address are also recorded. The date on which the customer chooses the service is also recorded by the system.

NOTE: SIM cards that have not yet been purchased do not yet have a billing plan or service allocated.

Using the narrative above and the following business rules, complete the incomplete ERD below by copying the given entities. Include all necessary relationships, cardinalities, primary keys, foreign keys, attributes, and composite entities in the diagram. Redraw the incomplete diagram below and complete it.

• A customer owns one or more SIM cards

• A SIM card is owned by zero or one customer

• A SIM card is assigned to zero or one billing plan

• A billing plan is assigned to zero or more SIM cards

• A SIM card can use zero or many services

• A service can be used by zero or many SIM cards

Answer rating: 100% (QA)

Solution This question can be solved as follows address N... View the full answer