Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following is a diagram showing three EMPLOYE tables. Draw an ERD between these tables. (However, we will display PK, FK, and CONNECTIVITY.) This is
The following is a diagram showing three EMPLOYE tables. Draw an ERD between these tables. (However, we will display PK, FK, and CONNECTIVITY.)
This is all the content of the problem.
*I want the right answer other than the one on the check page! *
Table name: CUSTOMER CUS NUM CUS_L.NAME 001 Smith 1002 Cordoza 1003 Bianco Table name: TAPE TAPE_CODE TAPE_COPY TAPE_NAME M3456-1 1 Ramblin' Tulip R2345-1 1 Once Upon a Midnight Breezy R2345-2 2 Once Upon a Midnight Breezy S4557-1 1 Tulips and Threclips W1234-1 1 Bright Stars and Doodle Berries V1234-2 2 Bright Stars and Doodle Berries W1234.3 3 Bright Stars and Doodle Berries TAPE_CHARGE 2.50 399 3.99 2 50 300 300 300 I TAPGson Tablle name: RENTAL RENT_NUM RENT_DATE OUTCWS_NUM TAPE_CODE RENT_COPY RENT_CHO_DAY RENT_DATE_RETURN RENT_CHARGE 20050 10-Jan-2008 1002 R$345.1 1 3.99 11-Jan-2008 3.99 10051 10.Jan-2008 1003 R2345-2 2 3.99 11-Jan-2008 399 10052 10-Jan-2008 1001 W1234-2 2 300 12-Jan-2008 600 10053 10-Jan-2008 1004 M3456-1 1 250 11-Jan-2008 2 50 10054 12-Jan-2008 1004 S4567-1 1 250 13-Jan-2008 250 10055 12-Jan-2008 1001 R2345-1 1 3.99 13-Jan-2008 3.99 10058 13.Jan-2008 1003 W1234 3 3 300 13-Jan-2003 300 10057 13-Jan-2005 1002 W1234-1 300 14.Jan-2008 3.00 10058 13-Jan-2008 1001 S4567-1 1 2.50 14-Jan-2008 2.50 10059 14-Jan-2008 1004 M3456-1 1 2.50 15-Jan-2008 2.50 10060 14-Jan-2008 1002 R2345-2 2 399 15-Jan-2008 3.99 10061 14-Jan-2008 1003 W1234-3 3 300 16-Jan-2008 600 10062 15-Jan-2008 1001 S4567.1 1 250 10053 15-Jan-2008 1004 R2345-1 399 16-Jan-2008 399 10054 15-Jan-2008 1004 R2345-2 2 399 Table name: CUSTOMER CUS NUM CUS_L.NAME 001 Smith 1002 Cordoza 1003 Bianco Table name: TAPE TAPE_CODE TAPE_COPY TAPE_NAME M3456-1 1 Ramblin' Tulip R2345-1 1 Once Upon a Midnight Breezy R2345-2 2 Once Upon a Midnight Breezy S4557-1 1 Tulips and Threclips W1234-1 1 Bright Stars and Doodle Berries V1234-2 2 Bright Stars and Doodle Berries W1234.3 3 Bright Stars and Doodle Berries TAPE_CHARGE 2.50 399 3.99 2 50 300 300 300 I TAPGson Tablle name: RENTAL RENT_NUM RENT_DATE OUTCWS_NUM TAPE_CODE RENT_COPY RENT_CHO_DAY RENT_DATE_RETURN RENT_CHARGE 20050 10-Jan-2008 1002 R$345.1 1 3.99 11-Jan-2008 3.99 10051 10.Jan-2008 1003 R2345-2 2 3.99 11-Jan-2008 399 10052 10-Jan-2008 1001 W1234-2 2 300 12-Jan-2008 600 10053 10-Jan-2008 1004 M3456-1 1 250 11-Jan-2008 2 50 10054 12-Jan-2008 1004 S4567-1 1 250 13-Jan-2008 250 10055 12-Jan-2008 1001 R2345-1 1 3.99 13-Jan-2008 3.99 10058 13.Jan-2008 1003 W1234 3 3 300 13-Jan-2003 300 10057 13-Jan-2005 1002 W1234-1 300 14.Jan-2008 3.00 10058 13-Jan-2008 1001 S4567-1 1 2.50 14-Jan-2008 2.50 10059 14-Jan-2008 1004 M3456-1 1 2.50 15-Jan-2008 2.50 10060 14-Jan-2008 1002 R2345-2 2 399 15-Jan-2008 3.99 10061 14-Jan-2008 1003 W1234-3 3 300 16-Jan-2008 600 10062 15-Jan-2008 1001 S4567.1 1 250 10053 15-Jan-2008 1004 R2345-1 399 16-Jan-2008 399 10054 15-Jan-2008 1004 R2345-2 2 399Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started