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 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
Get step-by-step solutions from verified subject matter experts
