%20%20Curriculum/Exercises/Chapter%202/Exercise%202.2.pdf 1 /5 100% + Exercise 2.2 Use the ERM below to answer the following questions. Note that all employees, regardless if they work at the Division or Department level, are recorded in the EMPLOYEE table. Some employees will run divisions, some will manage departments, and other will not (they just work for a department or are a roamer.) DEPARTMENT EMPLOYEE DEPT CODE employs - of PK EMP NUM DIVISION operates FK1 DIV CODE DEPT NAME TO rapppes. | FK1|DEPT CODE PK DIV CODE EMP_LNAME EMP_FNAME FK1 EMP NUM EMP_INITIAL DIV NAME EMP_EXTENSION EMP_E-MAIL ecards PROJECT SSIGNMENT PK PROJ CODE PK ASSIGN NUM PROJ NAME FK2 PROJ_CODE FK1 EMPNUM ASSIGN DATE ASSIGN_HOURS Which entity is the Bridge/Composite Entity? a. DEPARTMENT b. EMPLOYEE c. ASSIGNMENT d. PROJECT 2. The participation between DEPARTMENT employs EMPLOYEE is? a. Mandatory b. Optional c. Indeterminate d. Weak . The participation between DIVISION operates DEPARTMENT is? a. Mandatory b. Optional C. Indeterminate d. Weak20%20Curriculum/Exercises/Chapter %202/Exercise%202.2.pdf 2 /5 100% + 4. The relationship strength between EMPLOYEE manages DEPARTMENT is a. Strong b. Weak c. Mandatory d. Optional 5. Regarding the relationship between EMPLOYEE manages DEPARTMENT (one employee manages each department), the maximum cardinality of an employee managing a department is? Enter a number. 6. The relationship between EMPLOYEE manages DEPARTMENT is a. 1:M b. M:M c. 1:1 7. Regarding the relationship between EMPLOYEE records ASSIGNMENT; a. ASSIGNMENT is a Weak Entity b. ASSIGNMENT is a Strong Entity c. EMPLOYEE is a Weak Entity d. EMPLOYEE is a Strong Entity Use the ERM below to answer the questions below. Note that FKs may exist but are not shown. MANUFACTURER MODEL PK Model Num PK |Man Code BRAND Model Jets Man_Name makes Model_Motors Man_Street PK Brand ID includes Model HP Man_City Model MSRP Man_State Brand Name Model HV Price Man ZIPCode Brand Level Model_Weight Man_AreaCode Model_WCapacity Man_Phone Model_Seats Man_AccNum 8. What is the relationship between MANUFACTURER and BRAND? a. 1:1 b. 1:M c. M:M3 5 100% 9. The minimum cardinality of manufacture making brand is? Enter a number. 1 10. The maximum cardinality of brand being made by manufacturer is? a. b. I c. Indeterminate, but many 11. What is the relationship between BRAND and MODEL? . 1:1 b. 1:M c. M:M 12. The maximum cardinality of brand including model is? a. 0 b. c. Indeterminate, but many 13. Regardless of which ERM is correct, and ignoring the solid line between entities, what kind of entity is BRAND? a. Weak Entity Strong Entity c. Indeterminate 14. BRAND may be missing a FK. What would be appropriate FK be in the BRAND table? a. No FK needed b. Man_Code C. Brand_ID d. Model_Num e. Man_Code and Model_Num 15. MODEL may be missing a FK. What would be appropriate FK be in the MODEL table? a. No FK needed b. Man_Code C. Brand_ID d. Model_Num e. Man_Code and Brand_ID16. Which entity is a bridge/composite entity? a. DOCTOR b. VISIT c. PAT PAYMENT d. BILLING e. None are Bridge Entities/5.%20%20Curriculum/Exercises/Chapter%202/Exercise%202.2.pdf 4 / 5 100% + Use the ERM below to answer the questions below PATIENT APPOINTMENT DOCTOR PK PAT NUM PK APPT NUM PK | DOC ID FK1 INSUR_CODE _requests APPT DATE PAT LNAME APPT TIME DOC_LNAME PAT_FNAME APPT SCHED DOC_FNAME PAT AREACODE FKI PAT NUM DOC_INITIAL PAT PHONE FK2 | DOC_ID DOC EXTENSION PAT E-MAIL DOC OFFICE PAT BALANCE attends records PAT PAYMENT PK | PATPAY NUM VISIT includes PK VISIT NUM OFK2 BILL CODE PATPAY_DATE FK2 DOC_ID PATPAY AMOUNT FK1 PAT_NUM PATPAY TYPE VISIT_DATE FK1 | PAT NUM VISIT TIME nsures produces s reduced by BILLING VISIT_DETAIL PK BILL CODE PK,FK1 VISIT NUM PK VISLINE NUM BILL DATE BILL CHG AMOUNT VISLINE PROBLEM BILL PAY_AMOUNT VISLINE_DIAGNOSIS BILL PAY DATE VISLINE CHARGE BILL BALANCE KI. | VISIT NUM INSURANCE adjusts PK INSUR CODE INSUR_NAME INSUR_CONTACT INSUR_AREACODE INSURE PAYMENT INSUR_PHONE INSUR EMAIL PK|INSUREPAY NUM FK2 INSUR CODE FKI BILL CODE INSUREPAY DATE INSURE AMOUNT INSURE PAY TYPE lenovo