Question: it is system analysis and process integration course and answers these questions please i have exam Exereise ? A cellular operator needs a database tos

it is system analysis and process integration course and answers these questions please i have exam
it is system analysis and process integration course and answers these questions

Exereise ? A cellular operator needs a database tos keep track of ins cuslomers, their subscription plans. and the handsets (mobile phones) that they are using. The below E-R diagram illustrates the key entities of interest to the operator and the relationships between them. Based on the figure, answer the following questions and explain the rationale for your response. For each question, identify the element(s) in the E-R diagram that you usod to determise your answer. a. Can a customer have an unlimited number of plans? b. Can a customer exist without a plan? c. Is it possible to create a plan withoat knowing who the customer is? d. Does the operator want to limit the types of handsets that can be linked to a specifie plan type? c. Is it possible to maintain data refarding a handset without connecting it to a plan? f. Assume a handset type exists that can utilize multiple operating systems. Could this situation be accomnodated within the model. g. Is the company able to track a manafacturer without maintaining information about its handsets? h. Can the same operating system be used cn multiple handset types? L. Can the company track a handset withoot identifying its operating system

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!