Question: Jill is building a data model for a Customer Relationship Management ( CRM ) system and needs to store customer phone numbers. The marketing manager

Jill is building a data model for a Customer Relationship Management (CRM) system and needs to store customer phone numbers. The marketing manager who she is gathering requirements from has explained to her that each customer must provide at least 1 phone number, but the database needs to be modeled to store as many phone numbers as each customer provides.
How should Jill implement the phone number Multi-Valued Attribute?
Group of answer choices
Jill should create a column called PhoneNumbers in the CUSTOMER table and store the phone numbers in a comma-delimited list in the column.
Jill should create a 1:M identifying relationship with a table called CUSTOMER_PHONE that has composite primary key consisting of CustomerID and PhoneNumber.
Jill should INSERT 1 row into the CUSTOMER table for each Phone Number the customer has.
Jill should create 5 columns called PhoneNumber1, PhoneNumber2, PhoneNumber3, PhoneNumber4, PhoneNumber5, which should cover nearly every customer's situation.

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 Databases Questions!