CS403 Current Quiz

BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 84
sec(s)



Question # 5 of 10 ( Start time: 04:07:36 PM ) Total Marks: 1
Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address), where roll no is PK
Select correct option:


BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 86
sec(s)



Question # 6 of 10 ( Start time: 04:08:48 PM ) Total Marks: 1
Consider the following relation vendor_order (vendor no, order no, vendor name, qty supplied , price/unit) where 'vendor no, order no' is PK. The second normal form relations are
Select correct option:


BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 88
sec(s)



Question # 7 of 10 ( Start time: 04:09:02 PM ) Total Marks: 1
A relation which is in a higher normal form
Select correct option:



BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 87
sec(s)



Question # 8 of 10 ( Start time: 04:09:20 PM ) Total Marks: 1
Correct statement for creating table in Microsoft SQL server is.
Select correct option:

BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 88
sec(s)



Question # 9 of 10 ( Start time: 04:09:36 PM ) Total Marks: 1
At which design level de-normalization will take place.
Select correct option:



BC090401275 : Sadia Tufail



Quiz Start Time: 03:54 PM Time Left 88
sec(s)



Question # 10 of 10 ( Start time: 04:09:51 PM ) Total Marks: 1
A second Normal Form (2 NF) relation should
Select correct option: