Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started