Friday, 18 April 2014

Database Normal Forms - Quiz 1

Normalization and Normal Forms in Database Design - Quiz 1


1. For a relation R, we are given that the domains of all attributes of R are indivisible. With this information, we can say the relation R is in
    1 NF
    2 NF
    3 NF
    BCNF

2. In a table with the schema STU(STUNO, STUNAME, ADDRESS, COURSENO, COURSENAME) and with the functional dependencies, STUNO --> STUNAME ADDRESS, COURSENO --> COURSENAME, STUNO COURSENO --> STUNAME ADDRESS COURSENAME, which of the following anomalies would present?
    Insetion Anomaly
    Deletion Anomaly
    Update Anomaly
    All of the above

3. A relation which has only atomic attributes and every non-key attribute fully functionally dependent on candidate keys is said to be in
    1 NF
    2 NF
    3 NF
    BCNF

4. Consider the schema given in question 2. Is the relation STU in 2 NF?
    YES
    NO

5. What does Atomic attribute mean?
    It is one type of attribute used in DBMS
    An attribute whose values can be divided into meaningful subparts
    An attribute whose values cannot be divided into meaningful subparts
    None of the above

6. If you have removed repeated groups of values from a relation and also removed the partial key dependencies, then we would say that the given relation is in
    1 NF
    2 NF
    3 NF
    BCNF

7. Assume a table with the schema STU(STUNO, STUNAME, ADDRESS, PINCODE) and with the functional dependencies, STUNO --> STUNAME ADDRESS PINCODE, PINCODE --> ADDRESS. Is this relation is in 2 NF?
    YES
    NO

8. A relation is said to be in 3 NF if which of the following is/are true?
    No partial key dependencies
    All attributes are atomic
    No presence of transitive dependencies
    All of the above

9. Assume a table with the schema STU(STUNO, STUNAME, ADDRESS, PINCODE) and with the functional dependencies, STUNO --> STUNAME ADDRESS PINCODE, PINCODE --> ADDRESS. Is this relation is in 3 NF?
    YES
    NO

10. Assume a table with the schema STU(STUNO, STUNAME, ADDRESS, COURSENO, COURSENAME) and with the functional dependencies, STUNO --> STUNAME ADDRESS, COURSENO --> COURSENAME, STUNO COURSENO --> STUNAME ADDRESS COURSENAME with no transitive dependency. The relation STU is in _______ NF?
    1 NF
    2 NF
    3 NF
    BCNF

Score =

Correct answers:

* You can also try other DBMS quizzes here

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...