placeholder image to represent content

THIRD NORMAL FORM

Quiz by Ms M Vinodhini Vel Tech, Chennai

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
5 questions
Show answers
  • Q1
    In the __________ normal form, a composite attribute is converted to individual attributes.
    Second
    Fourth
    Third
    First
    30s
  • Q2
    Tables in second normal form (2NF):
    Have all non key fields depend on the whole primary key
    Eliminate the possibility of a insertion anomalies
    Eliminate all hidden dependencies
    Have a composite key
    30s
  • Q3
    Which-one ofthe following statements about normal forms is FALSE?
    Any relation with two attributes is BCNF
    Loss less, dependency – preserving decomposition into BCNF is always possible
    BCNF is stricter than 3 NF
    Lossless, dependency -preserving decomposition into 3 NF is always possible
    30s
  • Q4
    Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
    3NF
    All of the mentioned
    2NF
    1NF
    30s
  • Q5
    Which forms are based on the concept of functional dependency:
    3NF
    4NF
    2NF
    1NF
    30s

Teachers give this quiz to your class