Cs403 database quiz on 4 January 2012-01-04View more random threads:
- vu online quiz Cs504 quiz no 3 fall 2012
- cs401 first quiz on 13th April 2012 Fresh and solved
- MGT201 - Financial Management solved mcqs data bank 2000...
- Quizes of MGT111 for Final Term....
- MGT613 Production Operations Management Solved Current...
- cs604 operating system quiz no 3 on 4 Junary 2012
- cs402 online quiz solved by vu student 2011
- MGT411 Current Online Quizzes Solved more than 100 MCQ's...
- cs401 Quiz spring May 2011
- MGT201 Financial Management solved mcqs and quiz Fall 2010
Please download the PDF to get full marks
A relation is said to be in BCNF when
it has overlapping composite keys
In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.
Access data from second vertical partition
Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of members of an entity set
General reasoning for horizontal or vertical partitioning is.
Increasing the consistency
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
it has more than 3 non-key attributes
BCNF is needed because
A second Normal Form (2 NF) relation should
be in 1 NF
Boye Codd Normal Form (BCNF) is needed when
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
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
i and ii
The process of normalization
requires one to understand dependency between attributes
ramiz
Atomicity is a feature of ______.
If A -> B and A -> C, then A -> BC The Inference Rule applies is;
Augmentation
A relation is said to be in BCNF when
it has no overlapping composite keys which have related attributes
A 3 NF relation is converted to BCNF by
dependent attributes of overlapping composite keys are put in a separate relation
Normalization is a process of restructuring a relation to
minimize duplication of data in a database
An attribute y may be functionally dependent on (i) a composite attribute x,y (ii) a single attribute x (iii) no attribute
i and ii
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
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
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
i and ii
Sponsored Links
03009520262
Rabeel Website
There are currently 1 users browsing this thread. (0 members and 1 guests)