Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tables A Customers Customers Customer ID Phone Numbers Phone Numbers First Name ' Phone ID Last Name Phone Number Customer Name Type Customer IDFK In

image text in transcribed
Tables A Customers Customers Customer ID Phone Numbers Phone Numbers First Name ' Phone ID Last Name Phone Number Customer Name Type Customer IDFK In the table design shown above, explain the following points: 1. Convert the tables you submitted in Quizz#3 into table design shown above. And then show their cardinalities. 2. Which is the parent table and the child table in your example? 3. How to tell which is the child table? 4. Explain what is a table-relationship in RDBMS or in MS Access. 5. What are the three types of table relationships? 6. You may resubmit the tables you have submitted in Quiz#3, but add more data entries to make sure that the tables have at least 5 data entries (add more than 5 if needed). Explain the type of the relationships that your tables are assuming in English and with the arrow method shown below. Phone Numbers ccess Obje Phone ID . Phone Number . Type . Customer IDFK 1 (360) 555-9587 Office Lester Baxley 2 (425) 555-9858 Mobile Lester Baxley 3 (206) 555-9482 Mobile Patricia White Customers 4 (206) 555-3412 Office Alan Mayers Customer ID . First Name Last Name . Customer Name . 5 (425) 555-3413 Fax Alan Mayers Lillie Huff 1 Lester Baxley Lester Baxley 6 (206) 555-8122 Mobile Patricia White 7 (206) 555-7234 Fax Lillie Huff 2 Patricia White 3 Alar Mayers Alan Mayers 8 (425) 555-4848 Office Jake Revee 4 Lillie Huff Lillie Huff 9 (425) 555-8484 Home Jake Revee 5 Jake Revee Jake Revee 10 (206) 555-7773 Office Naomi Barton 6 Naomi Barton Naomi Barton 11 (206) 555-6662 Fax Naomi Barton 7 Luke loggins uke Coggins 12 (206) 555-5551 Home Naomi Barton 8 Marion McDaniels Marion McDaniels 13 (360) 555-5598 Office Luke Coggins 9 Moses Philips Moses Philips 14 (360) 555-4487 Mobile Luke Coggins 10 lla Horne lla Horne 15 (206) 555-1189 Mobile Marion McDaniels 16 (360) 555-4444 Office Moses Philips 17 (360) 555-3333 Fax Moses Philips 18 (206) 555-1192 Office lla Horne

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

Digital Business And E Commerce Management

Authors: Dave Chaffey, Tanya Hemphill, David Edmundson-Bird

7th Edition

1292193336, 978-1292193335

More Books

Students also viewed these General Management questions

Question

OUTCOME 2 Describe how a training needs assessment should be done.

Answered: 1 week ago