Chapter 3 - Relational Database Model 1. What is the difference between a database and a table? 2. What is attribute domain and give an example. 3. What is a composite key? 4 When does a table exhibit entity integrity? 5. What is a foreign key? 6. Use the figure below to answer the questions that follow: Database name:CHO3 College Que Table name: STUDENT Table name: PROFESSOR STU_CODE. PROF_CODE PROF_CODE - DEPT_CODE 12 128569 26 512272 36 531235 531268 553427 100278 + 44 a Draw the basic entity relationship diagram for the database shown above. b. Draw the relational schema also. 7. Suppose that you have the entity relationship model shown below: drives Driver Truck A driver can chrive many different Trucks and any Truck can be driven by many Drivers. Convert the above scenario into an entity relationship model that displays only 1:M relationships? Hint: You have to use a conposite entity. 8. Use the database shown in the diagram below to answer the following questions. Note that the database is composed of four tables and reflects 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. E EMPLOYEE : Table EMP_CODE EMP_LNAME JOB_CODE + Rudell 2 + 15 McDade 1 16 Ruellardo 1 17 Smith 3 20 Smith 2 3 + BENEFIT : Table EMP_CODE PLAN_CODE 15 2 15 3 16 1 17 1 17 3 17 4 20 3 3 + | JOB : Table JOB_CODE JOB_DESCRIPTION Clerical 2 Technical 3 Managerial PLAN: Table PLAN_CODE PLAN_DESCRIPTION 1 Term life + 2 Stock purchase + 3 Long-term disability + 4 Dental + a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space. TABLE PRIMARY KEY FOREIGN KEY(S) EMPLOYEE BENEFIT | PLAN b) Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB. c) Do the tables exhibit entity integrity? Answer Yes or No, then explain your answer. Table Entity Integrity Explanation Employee Benefit Job Plan d) 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. Table Referential Integrity Explanation Employee Benefit Job Plan e Draw the entity relationship diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. f. Draw the relational schema also