Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245

Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel

1st Edition

3030548317, 978-3030548315

Students also viewed these Databases questions