You are an employee of ABC Cellular Network. The following data is updated regularly by head office staff:

• For each cellular telephone registered at ABC Cellular Network, the system stores its serial number (e.g. C53421X), its make (e.g. Nokia), its model (N95) and its year (e.g. 2008).

Details about the owner of each cellular telephone include: The person's ID number, name, address and telephone number. An owner can have any number of cellular telephones.

• ABC Cellular Network has more than 100 000 customers. Each of these customers can have contracts with more than one service provider. Clients can choose between a Family, Weekender or Business contract. Business contracts can be either Call 500 or Call 1000.
 

REQUIRED: Draw an Entity-Relationship Diagram (ERD of this situation)

Answer rating: 100% (QA)

EntityRelationship Diagram ERD for Cellular Telephone Registration Entities CellularTelephone SerialNumber Make Model Year Customer IDNumber Name Address TelephoneNumber ServiceProvider Name CellularT... View the full answer