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 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 MultiValued Attribute?
Group of answer choices
Jill should create a column called PhoneNumbers in the CUSTOMER table and store the phone numbers in a commadelimited list in the column.
Jill should create a :M identifying relationship with a table called CUSTOMERPHONE that has composite primary key consisting of CustomerID and PhoneNumber.
Jill should INSERT row into the CUSTOMER table for each Phone Number the customer has.
Jill should create columns called PhoneNumber PhoneNumber PhoneNumber PhoneNumber PhoneNumber 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
