GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Normalization Practice

Craig Willey 11 questions 10,239 views 4.0 (1 rating)

Take the quiz

Questions in this quiz (11)

  1. 1In which state are the attributes shown (see table)?Image for question 1
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  2. 2In which state is the table in (see table)?Image for question 2
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  3. 3The primary key in the first table is Booking ID, and the primary key in the second is Client ID.

    How advanced are the two tables in the normalization process (see tables)?    Image for question 3
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  4. 4What characteristic points to the tables shown above being in third normal form?Image for question 4
    1. AThe tables are completely free of data redundancy.
    2. B“Client ID” appears in more than one table.
    3. CEach primary key has a functional dependency on every other primary key in the table.
    4. DThe attributes are all single valued.
  5. 5The primary key of the table is a composite key made up of Registration ID and Activity ID. In which form is the table?Image for question 5
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  6. 6In which form is the table?Image for question 6
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  7. 7In which state are the attributes shown?Image for question 7
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  8. 8In which state are the attributes shown (see table)?Image for question 8
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  9. 9In which state are the attributes shown (see table above)?Image for question 9
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form
  10. 10In which state are the attributes shown?Image for question 10
    1. AUnnormalized
    2. BFirst Normal Form
    3. CSecond Normal Form
    4. DThird Normal Form

Information

Description
C175
Language
English
Views
10,239
Rating
4.0 out of 5 · 1 rating
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?