Answered step by step
Verified Expert Solution
Link Copied!

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions

Question

Briefly explain accounting independence.

Answered: 1 week ago

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago