Question: Given these tables, create a Crow's Foot E-R Diagram with connectivites and cardinalities included. Table name: CUSTOMER Table name: TAPE TAPE CODE TAPE COPY TAPE

 Given these tables, create a Crow's Foot E-R Diagram with connectivites

Given these tables, create a Crow's Foot E-R Diagram with connectivites and cardinalities included.

Table name: CUSTOMER Table name: TAPE TAPE CODE TAPE COPY TAPE CHARGE TAPE NAME CUS NUM CUS LNAME M13456.1 1 Ramblin' Tulip 250 1001 Smith 399 R2345-1 1 Once Upon a Midnight Breezy 1002 Cordoza R2345-2 2 Once Upon a Midnight Breezy 399 1003 Bianco S4567-1 1 Tulips and Threelips 2.50 1004 Jones 300 W1234- 1 Bright Stars and Doodle Berries 300 W1234-2 2 Bright Stars and Doodle Berries 3.00 W1234-3 3 Bright Stars and Doodle Berries Table name: RENTAL RENT NUMTRENT DATE OUT CUS NUM TAPE CODE RENT COPY RENT CHG DAY RENT DATE RETURN RENT CHARGE 10050 10 Jan-2010 1002 R2345-1 1 399 11. Jan-2010 399 10051 40 Jan 2010 1003 R2345-2 2 399 11 Jan-2010 399 1001 W 1234-2 10053 10Jan-2010 1004 M3456-1 1 2.50 11 Jan-2010 250 12 Jan 2010 1004 S4567-1 13-Jan-2010 10055 12-Jan-2010 1001 R2345-1 1 399 13-Jan-2010 399 1003 W1234-3 13-Jan-2010 10057 13-Jan-2010 1002 W1234-1 1 3.00 14-Jan-2010 300 1 2.50 14. Jan-2010 250 13 Jan 2010 1001 S4567-1 10058 1004 M3456-1 10059 1002 R2345-2 10061 14-Jan-2010 1003 W1234-3 3 300 16-Jan-2010 6.00 10062 15-Jan-2010 1001 S4567-1 1 2.50 10063 15-Jan-2010 1004 R2345-1 1 399 16-Jan-2010 399 10064 15-Jan-2010 1004 R2345-2 2 399

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!