Hire > Membership Member_Id {pk) Name Gender DOB Tel_No Trainer Trainer_Id {pk) Name Specialty Telephone_No 0..1 |{mandatory,or) Full Member Monthly Fee Parking No Assoc Member Daily Fee Program Type Diagram 1 7. What is the DISJOINT CONSTRAINT for the above subclasses (Diagram 1)? A. Mandatory B. Optional C. Disjoint D. Non-Disjoint 7 E du dloud The Taqwa Funiture Sdn Bhd is a company that sells living furniture to the public. The table below is an example of the company typical business report. Answer questions 8 and 9 based on Table 1. Order Id 1006 Order Date 3/3/2014 Staff | Cust Id No 101 125 Prod Prod Prod Desc Price Finish Dining Table S520 Maple Chair 532 Oak Dresser $240 Maple Chair $32 Oak Queen Bed $995 Cherry Ordered Oy 2 8 3 12 1 1007 Cust Cust Prod Name Addr Id Hassan Ipoh 25 36 Fatimah Seremban 21 36 42 Table 1 20/3/2014 106 140 8. Which of the following attribute(s) the best option as primary key? A. Order Id B. Staff Id C. Ordered Qty D. Order Id and Prod Id 9. Which of the following statement is best to describe the functional dependency (6 - Cust_No) below? a. Order_id > Order_date,Staff_Id, Cust_No,Cust_name, CustAddr b. Cust_No Cust_name, CustAddr A. Full functional Dependency B. Partial dependency C. Transitive dependency D. Primary key 10. Which of the following one-to-one relationship will produce only one logical data model relation? A. Mandatory participation on both sides of 1:1 relationship B. Mandatory participation on one sides of 1:1 relationship C. Optional participation on both sides of 1:1 relationship D. None of the above Question 11 and 12 are based on the following diagram. Patient Patient History Registration No Record No Name Date Address 1...1 1. Description Td_No Diagnose has Diagram 2 11. Which of the following statements is NOT TRUE about the Diagram 2? A. Patient is the strong entity B. Each patient history record must belong to a patient C. This is a one-to-many relationship D. Some history record can exist independently 12. Which of the following logical data models correctly represents the above conceptual model (Diagram 2) after conversion from conceptual to logical data model? A. Patient(RegistrationNO,Name, Address, Tel_No) Primary key - Registration No B. Patient History(RecordNo, Date,Description, Diagnose) Primary Key - Record No C. Patient History(RecordNo, Date, Description, Diagnose) Primary Key - RecordNo Foreign Key - RegistrationNo D. Both answers 'A' and 'C' is correct