CS409 Graded Quiz 1 May 2026

Quiz 1 - CS409 (Q1/10)

Question:

Which column can be an appropriate surrogated key for the following INVOICE table? INVOICE (Invoice_no, Incoice_date, Total_amount, Discount, Customer_name)

A. Customer_name B. Total_amount C. Total_amount

D. Invoice_no

Copied: 5/5/2026, 10:00:54 AM

Quiz 2 - CS409 (Q2/10)

Question:

Physical database design is all about _____________.

A. Identifying relationships among entities B. Converting entities into tables

C. Organization of data on disk

D. Identifying attributes of entities Copied: 5/5/2026, 10:01:14 AM

Quiz 3 - CS409 (Q3/10)

Question:

The length or size of foreign key and its referring primary key _____________.

A. May be same

B. May be different C. Must be different

D. Must be same

Copied: 5/5/2026, 10:01:29 AM

Quiz 4 - CS409 (Q4/10)

Question:

" Address" is an example of ___________________ of Employee entity.

A. Simple attribute B. Key Attribute C. Derived attribute

D. Composite attribute

Copied: 5/5/2026, 10:01:46 AM

Quiz 5 - CS409 (Q5/10)

Question:

Identify the primary key (composite key) for the following relation.

LABTEST (PatientID, Visit_No, TestID, Test_date)

A. PatientID , Visit_No B. PatientID , TestID C. PatientID , Test_date

D. PatientID , Visit_No , TestID

Copied: 5/5/2026, 10:02:03 AM

Quiz 6 - CS409 (Q6/10)

Question:

Which column can be an appropriate primary key for the following STUDENT table? STUDENT(Std_Rollno, Std_name, Std_Fname, Father_CNIC, Mobile_no)

A. Father_CNIC B. Std_name C. Mobile_no

D. Std_Rollno

Copied: 5/5/2026, 10:02:25 AM

Quiz 7 - CS409 (Q7/10)

Question:

Logical database design is a/an ___________________.

A. Mechanical design

B. Formal design

C. Informal design D. Conceptual design Copied: 5/5/2026, 10:02:44 AM

Quiz 8 - CS409 (Q8/10)

Question:

Identify the correct statement for the foreign key.