Chat with us, powered by LiveChat QUESTION 5 Create the ERD to show the relationship between STORE and REGION.? SEE IMAGE LINK: https://cnow.ap - Writeedu
Login

22 Jul QUESTION 5 Create the ERD to show the relationship between STORE and REGION.? SEE IMAGE LINK: https://cnow.ap

Posted at 23:04h in Computer Science by

QUESTION 5

Create the ERD to show the relationship between STORE and REGION. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image030.gif

Make sure that the file is saved as ch3_question5_Deleon.doc

————————————————————————–

QUESTION 6

Create the relational diagram to show the relationship between STORE and REGION. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image030.gif

Make sure that the file is saved as ch3_question6_Deleon.doc

————————————————————————————–

QUESTION 8

Create the ERD to show the relationships among EMPLOYEE, STORE, and REGION. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image030.gif

Make sure that the file is saved as ch3_question8_Deleon.doc

————————————————————————————–

QUESTION 9

Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image030.gif

Make sure that the file is saved as ch3_question9_Deleon.doc

————————————————————————————————-

QUESTION 11

Create the ERD to show the relationship between EMPLOYEE and JOB. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image036.jpg

Note that the database is composed of four tables that reflect these relationships: 

  • An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. 
  • An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. 

Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity.

Make sure that the file is saved as ch3_question11_Deleon.doc

———————————————————————————————

QUESTION 12

Create the relational diagram to show the relationship between EMPLOYEE and JOB. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image036.jpg

Make sure that the file is saved as ch3_question12_Deleon.doc

————————————————————————————————–

QUESTION 15

Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image036.jpg

Make sure that the file is saved as ch3_question15_Deleon.doc

————————————————————————————————–

QUESTION 16

Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image036.jpg

Note that the database is composed of four tables that reflect these relationships: 

  • An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. 
  • An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. 

Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity.

Make sure that the file is saved as ch3_question16_Deleon.doc

———————————————————————————————-

QUESTION 22

Create the ERD for this database. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image039.jpg

Make sure that the file is saved as ch3_question22_Deleon.doc

———————————————————————————————

QUESTION 23

Create the relational diagram for this database. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image039.jpg

Make sure that the file is saved as ch3_question23_Deleon.doc

———————————————————————————————-

QUESTION 25

Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.) 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image043.jpg

Make sure that the file is saved as ch3_question25_Deleon.doc

———————————————————————————————

QUESTION 26 

Create the relational diagram.

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image043.jpg

Make sure that the file is saved as ch3_question26_Deleon.doc

——————————————————————————————

QUESTION 27

Modify the ERD you created in Problem 25 to eliminate the problems created by the use of synonyms. (Hint: Modify the CHARTER table structure by eliminating the CHAR_PILOT and CHAR_COPILOT attributes; then create a composite table named CREW to link the CHARTER and EMPLOYEE tables. Some crew members, such as flight attendants, may not be pilots. That's why the EMPLOYEE table enters into this relationship.) 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image043.jpg

Make sure that the file is saved as ch3_question27_Deleon.doc

——————————————————————————————————-

QUESTION 28

Create the relational diagram for the design you revised in Problem 27. 

Make sure that the file is saved as ch3_question28_Deleon.doc

————————————————————————————————

QUESTION 29

You want to see data on charters flown by either Robert Williams (employee number 105) or Elizabeth Travis (employee number 109) as pilot or copilot, but not charters flown by both of them. Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by either employee 105 or employee 109. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image043.jpg

Make sure that the file is saved as ch3_question29_Deleon.doc

———————————————————————————————————-

QUESTION 30

You want to see data on charters flown by either Robert Williams (employee number 105) or Elizabeth Travis (employee number 109) as pilot or copilot, but not charters flown by both of them. Create the table that would result from applying a DIFFERENCE relational operator of your result from Problem 29 to your result from Problem 30. 

SEE IMAGE LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image043.jpg

Make sure that the file is saved as ch3_question30_Deleon.doc

    Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

    Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

    Do you need an answer to this or any other questions?

    Do you need help with this question?

    Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

    WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

    With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

    Chat with us today! We are always waiting to answer all your questions.

    Click here to Place your Order Now