Question: 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do

1. For each table, identify the primary key and the foreign

1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.

2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.

3. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.

4. Describe the type(s) of relationship(s) between EMPLOYEE and JOB.

5. Create the ERD in Crows foot notation to show the relationship between EMPLOYEE and JOB.

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

7. Describe the type(s) of relationship(s) between EMPLOYEE and PROJECT. (hint: there are two relationships between them: participate and manage)

8. Create the ERD in Crows foot notation to show the relationships among EMPLOYEE, ASSIGNMENT, and PROJECT

9. Write expressions in the Relational Algebra language to answer the following queries.

Find EMP_NUM of the employees who participate the project with PROJ_NUM=15

Find FNAME, LNAME, and JOB_DESCRIPTIONM of the employee with EMP_NUM=108

Find FNAME, LNAME, JOB_DESCIPTION, and JOB_CHG_HOUR of the manager of the project Rolling Tide

Find EMP_NUM of the employees who are system analysts (Hint: job description is system analyst)

Find EMP_NUM of the employees who participate PROJ_NUM=15, but not system analysts (hint: use the answers from 1) and 4))

EMPLOYEE Evergreen105 Anber Wave 0 oling Tide11 ASSIGNMENT Systems Analys Electrical Engineer Cercal Support

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Use the database shown above to answer Problems 1- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2- Do the tables exhibit entity...

database tables need help woth questions 1,2,3,4,7,9 Figure P3.1 The CH03_Storeco Database Tables Dhes Storeco Details 1. For each table, identify the primary key and the foreign key(s). If a table...

Use the database shown in Figure 1 to answer Problems 1-5. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

The zip file for chapter 3 that you have downloaded will contain this database . 1. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write...

Database Management, guaranteed thumbs up! 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None . 2. Do the tables exhibit entity...

Complete all problems, thank you P 3 . 1 THE CH 0 3 _ STORECO DATABASE TABLES Table name: EMPLOYEE Database name: Ch 0 3 _ StoreCo Table name: STORE Table name: REGION 1 . For each table, identify...

Use the database shown in Figure 1 to answer Problems 1-5. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

Use the database shown in Figure 1 to answer Problems 15. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

Use the database shown in Figure 1 to answer Problems 1-5. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

Which of the following is NOT true of classical and operant conditioning? 1) Classical conditioning, but not operant conditioning, involves spontaneous recovery. 2) Both involve acquisition,...

Show that FIAMAO) =F FLA)F:()] - F;(x)F2(o - x)dx

Which of the following is correct regarding primary jurisdiction? Multiple Choice It is imvoked when judicial review is avalatie only for final actions by an agency If avoids the premature intemption...

Which of the following refers to the risk that a lender will not be able to sell the security to another investor? Illiquidity risk Default risk Real rate of interest None of these

In addition to patterns of interaction, in what ways are organizational structure and strategy responsible for the managerial climate?

What would be an example of line responsibilities that have been inappropriately assumed by a staff function? What would it take for the line operations to reclaim their appropriate role?

Employee participation in organizational decision making was, as McGregor reports, viewed with skepticism at the time he was writing. Is it now more widely valued and utilized? If so, why? If not,...