DATABASES- 16 QUESTIONS

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