01-05-2012, 04:08 AM
Cs403 database quiz on 4 January 2012-01-04
Please download the PDF to get full marks
[FONT="]A relation is said to be in BCNF when[/FONT]
it has overlapping composite keys
[FONT="]In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.[/FONT]
Access data from second vertical partition
[FONT="]Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of members of an entity set[/FONT]
[FONT="] [/FONT]
[FONT="]General reasoning for horizontal or vertical partitioning is.[/FONT]
Increasing the consistency
[FONT="]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[/FONT]
it has more than 3 non-key attributes
[FONT="]BCNF is needed because[/FONT]
[FONT="]A second Normal Form (2 NF) relation should[/FONT]
be in 1 NF
[FONT="]Boye Codd Normal Form (BCNF) is needed when[/FONT]
there are two or more possible composite overlapping keys and one attribute
of a composite key is dependent on an attribute of another composite key
[FONT="]A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency[/FONT]
i and ii
[FONT="]The process of normalization[/FONT]
requires one to understand dependency between attributes
ramiz
[FONT="]Atomicity is a feature of ______.[/FONT]
[FONT="]If A -> B and A -> C, then A -> BC The Inference Rule applies is;[/FONT]
[FONT="] [/FONT]
Augmentation
[FONT="]A relation is said to be in BCNF when[/FONT]
it has no overlapping composite keys which have related attributes
[FONT="]A 3 NF relation is converted to BCNF by[/FONT]
dependent attributes of overlapping composite keys are put in a separate relation
[FONT="]Normalization is a process of restructuring a relation to[/FONT]
minimize duplication of data in a database
[FONT="]An attribute y may be functionally dependent on (i) a composite attribute x,y (ii) a single attribute x (iii) no attribute[/FONT]
i and ii
[FONT="]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[/FONT]
vendor (vendor no, vendor name, qty supplied, price/unit), vendor no is PK
vendor order (order no, vendor no), order no and vendor no is PK
[FONT="]Normalization of database is essential to (i) avoid accidental deletion of required data when some data is deleted (ii) eliminate inconsistencies when a data item is modified in the database (iii) allows storage of data in a computer’s disk (iv) use a database management system[/FONT]
i and ii
Please download the PDF to get full marks
[FONT="]A relation is said to be in BCNF when[/FONT]
it has overlapping composite keys
[FONT="]In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.[/FONT]
Access data from second vertical partition
[FONT="]Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of members of an entity set[/FONT]
[FONT="] [/FONT]
[FONT="]General reasoning for horizontal or vertical partitioning is.[/FONT]
Increasing the consistency
[FONT="]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[/FONT]
it has more than 3 non-key attributes
[FONT="]BCNF is needed because[/FONT]
[FONT="]A second Normal Form (2 NF) relation should[/FONT]
be in 1 NF
[FONT="]Boye Codd Normal Form (BCNF) is needed when[/FONT]
there are two or more possible composite overlapping keys and one attribute
of a composite key is dependent on an attribute of another composite key
[FONT="]A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency[/FONT]
i and ii
[FONT="]The process of normalization[/FONT]
requires one to understand dependency between attributes
ramiz
[FONT="]Atomicity is a feature of ______.[/FONT]
[FONT="]If A -> B and A -> C, then A -> BC The Inference Rule applies is;[/FONT]
[FONT="] [/FONT]
Augmentation
[FONT="]A relation is said to be in BCNF when[/FONT]
it has no overlapping composite keys which have related attributes
[FONT="]A 3 NF relation is converted to BCNF by[/FONT]
dependent attributes of overlapping composite keys are put in a separate relation
[FONT="]Normalization is a process of restructuring a relation to[/FONT]
minimize duplication of data in a database
[FONT="]An attribute y may be functionally dependent on (i) a composite attribute x,y (ii) a single attribute x (iii) no attribute[/FONT]
i and ii
[FONT="]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[/FONT]
vendor (vendor no, vendor name, qty supplied, price/unit), vendor no is PK
vendor order (order no, vendor no), order no and vendor no is PK
[FONT="]Normalization of database is essential to (i) avoid accidental deletion of required data when some data is deleted (ii) eliminate inconsistencies when a data item is modified in the database (iii) allows storage of data in a computer’s disk (iv) use a database management system[/FONT]
i and ii