Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

*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 399

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

Contemporary Issues In Quantitative Finance

Authors: Ahmet Can Inci

1st Edition

1032101121, 978-1032101125

More Books

Students also viewed these Finance questions