Question: A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The

A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The E-R diagram in Figure 2-24 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 used to determine 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 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. Is it possible to maintain data regarding a handset without connecting it to a plan?
f. Can a handset be associated with multiple plans?
g. Assume a handset type exists that can utilize multiple operating systems. Could this situation be accommodated within the model included in Figure 2-24?
h. Is the company able to track a manufacturer without maintaining information about its handsets?
i. Can the same operating system be used on multiple handset types?
j. There are two relationships between Customer and Plan. Explain how they differ.
k. Characterize the degree and the cardinalities of the relationship that connects Customer to itself. Explain its meaning.
l. Is it possible to link a handset to a specific customer in a plan with multiple customers?
m. Can the company track a handset without identifying its operating system?

Family member ManufacturerH Handset Type Customer Handset Operating Syatem Plan HPlan Type FIGURE 2-24 Diagram for Problem and Exercise 2-23

Step by Step Solution

★★★★★

3.51 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Cellular Operator Database Figure 224 questions a Yes A Customer may be responsible for 0 1 or many Plans b Yes The minimum cardinality of the Belongs relationship from the Customer to the Plan states ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1590).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. Prepare a detailed list of pros and cons of in-house versus software purchase. 2. Calculate ROI for both options. 3. Calculate NPV for both options. Use an 8% discount factor. 4. Create a...

Martial Arts R Us (MARU) needs a database. MARU is a martial arts school with hundreds of students. It is necessary to keep track of all the different classes that are being offered, who is assigned...

To keep track of office furniture, computers, printers, and so on, the FOUNDIT Company uses the table structure shown in Table P6.5. a. Given that information, write the relational schema and draw...

A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The ER diagram in Figure 2-24 illustrates the key...

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...

The data reported in the Excel file CrimeSeverity comprises two variables, namely, Severity Index (which represents the non-violent crime severity index obtained from Statistics Canada's CANSIM...

Apply the following rules in solving all homework questions: Assume that corporations are subject to a 25% tax rate on all capital gains and ordinary income. Individual taxpayers are subject to a 40%...

In January 2 0 0 0 Ecuador officially replaced its national currency, the Ecuadorian sucre, with the U . S . dollar. This practice is known as:Group of answer choicesa Yankee bailout.bi -...

Read Eye on the Booms and Busts on p. 168 and explain why the NBER reported that the 2008 recession began before real GDP had fallen for two successive quarters.

Assume that a bank operates multi-nationally and has millions of financial records of customers in its database. The bank also offers e-banking services to its clients. Based on what you have learned...

Visit an organization that has implemented a database management system and interview concerned individuals about the standards and regulations used by the organization for financial reporting and...

Explain through common examples why determining grain is critical.

Python programming parsing function. b) Write a function called parse_functions that takes as parameter a string representing the name of a .py file. The function reads and parses the Python file and...

You need $25,056 at the end of 6 years, and your only investment outlet is an 12 percent long-term certificate of deposit (compounded annually). With the certificate of deposit, you make an initial...

Consider the following sample information randomly selected from two populations. Sample 1 Sample 2 n1 = 200 n2 = 50 x1 = 30 x2 = 30 a. Determine if the sample sizes are large enough so that the...