RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Relational Data Analysis
Relational Constraints
DB Normal Forms
Third Normal Form
Table Joins User Views
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:
Cat (CatID, Name, Birthdate, Fur, Eyes, Sex, OwnerID)
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.
