RelationalDBDesign RelationalDBDesign



Normal Forms   «Prev  Next»

Second Normal Form - Exercise

Requirements for 1NF and 2NF


Objective:

List the requirements for 1NF and 2NF.

Exercise scoring

This exercise is worth a total of two points. It is auto-scored; when you have answered the question below, click the Submit button to receive credit for having completed the exercise and view a results page.

Instructions

For this exercise, examine two relations, determine which relation is in 1NF and which is in 2NF, and briefly explain why. In the text boxes below, type or paste your responses to the following:
  1. Cat (CatID, Name, Birthdate, Fur, Eyes, Sex, OwnerID)
  2. Cat (CatID, Name, Birthdate, Fur, Eyes, Sex, OwnerID, VetAddress)

Submitting the exercise

This exercise is auto-scored, which means there is nothing to submit. When you have answered the question, click the Submit button to receive credit for completing the exercise and view a results page.