Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Identify attributes which belong to many-to-many relationships 2. Demonstrate the steps to resolve a many-to-many relationship using an intersection entity 3. Identify the UID

image text in transcribedimage text in transcribedimage text in transcribed

1. Identify attributes which belong to many-to-many relationships

2. Demonstrate the steps to resolve a many-to-many relationship using an intersection entity

3. Identify the UID of an intersection entity and represent it in the entity relationship diagram

4. Create ER models that reflect all business rules gathered during the interview process

5. Identify the create, retrieve, update, and delete (CRUD) requirements of the business

6 Validate your ER model by performing a CRUD analysis

please help: Thank you!

Client# CR76 Name Property# John Kay PG4 Paddress 16 Saw Rd. Raleigh RentStart 01-JUL-2001 RentFinish 31-AUG-2002 Rent Owner# 650 C040 Owner Name Tina Murphy PG16 50 Mills Rd, Raleigh 01-SEP-2001 01-SEP-2002 700 C093 Tony Shaw CR56 Aline Ann PG4 16 Saw Rd. Raleigh 01-SEP-1999 10-JUN-2000 C040 Tina Murphy PG36 276 May St, Raleigh 10-OCT-2000 01-DEC-2001 C093 Tony Shaw PG16 50 Mills Rd, Raleigh 01-JAN-2003 10-AUG-2004 C093 Tony Shaw Order# Order dt 2301 | 23-Jun-2005 Cust# C name 101 | ABC Co. St Qty price 10 15 | 6 2302 25-Jun-2005 2303 26-Jun-2005 12 107 Dick Co. 101 | ABC Co. Item# Item name 3786 Net 4011 Racket 9132 3-pack 5794 6-pack 4011 Racket 3141 Cover 3786 | Net 4011 Racket WI IL 15 2 2 2304 | 30-Jun-2005 110 CAN Co. | MI 35 10 15 5 Director# Actor no Film# Title F1100 Happy Day Director name Jim Alan Time_On_Screen 50 D101 A1000 A1001 A1009 A1200 A1000 Actorname Judy Foster Robert Dininor Harrison Ford Eddy Murphy Judy Foster Role Amy Harry Jack Exxel Fuse Ann Jones F1101 Air Force One D105 Woody Ellen A1000 A1009 A1200 A1002 Judy Foster Harrison Ford Eddy Murphy Mary Jacksons Mrs. President Mr. President Police one Police two F1102 Bride Run Away D101 Jim Alan A1003 A1007 A1009 A1005 A1000 Julia Roberts David Lynch Harrison Ford John Wynes Judy Foster Black Widow Sam Strickland Bank Robber Cab Driver Killer Client# CR76 Name Property# John Kay PG4 Paddress 16 Saw Rd. Raleigh RentStart 01-JUL-2001 RentFinish 31-AUG-2002 Rent Owner# 650 C040 Owner Name Tina Murphy PG16 50 Mills Rd, Raleigh 01-SEP-2001 01-SEP-2002 700 C093 Tony Shaw CR56 Aline Ann PG4 16 Saw Rd. Raleigh 01-SEP-1999 10-JUN-2000 C040 Tina Murphy PG36 276 May St, Raleigh 10-OCT-2000 01-DEC-2001 C093 Tony Shaw PG16 50 Mills Rd, Raleigh 01-JAN-2003 10-AUG-2004 C093 Tony Shaw Order# Order dt 2301 | 23-Jun-2005 Cust# C name 101 | ABC Co. St Qty price 10 15 | 6 2302 25-Jun-2005 2303 26-Jun-2005 12 107 Dick Co. 101 | ABC Co. Item# Item name 3786 Net 4011 Racket 9132 3-pack 5794 6-pack 4011 Racket 3141 Cover 3786 | Net 4011 Racket WI IL 15 2 2 2304 | 30-Jun-2005 110 CAN Co. | MI 35 10 15 5 Director# Actor no Film# Title F1100 Happy Day Director name Jim Alan Time_On_Screen 50 D101 A1000 A1001 A1009 A1200 A1000 Actorname Judy Foster Robert Dininor Harrison Ford Eddy Murphy Judy Foster Role Amy Harry Jack Exxel Fuse Ann Jones F1101 Air Force One D105 Woody Ellen A1000 A1009 A1200 A1002 Judy Foster Harrison Ford Eddy Murphy Mary Jacksons Mrs. President Mr. President Police one Police two F1102 Bride Run Away D101 Jim Alan A1003 A1007 A1009 A1005 A1000 Julia Roberts David Lynch Harrison Ford John Wynes Judy Foster Black Widow Sam Strickland Bank Robber Cab Driver Killer

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_2

Step: 3

blur-text-image_3

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

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions

Question

=+2.4. Let F1, F2, ... be classes of sets in a common space 2.

Answered: 1 week ago