RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
Relational Concepts
«Prev
Next»
SQL Database Creation
SQL - Server
Relational Database
Client Server Architecture
SQL Server Services
EM Administer SQL-Servers
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database Normalization
Data Normalization
Database Denormalization
Primary Keys Unique Constraints
Foreign Keys
Relational Concepts
Column Attributes Table
Table Columns Types
Specifying Length Precision Scale
SQL Allow Null
Specify Default Column Values
Table Identity Columns
Rowguidcol Attribute Flag
Create Transact SQL Datatype
TableColumn Attributes Conclusion
SQL-Server DB Tables
Data Normalization - Exercise
Data normalization
Objective:
Explain how to normalize sample data.
Exercise Scoring
This exercise is worth a total of 10 points. You will receive up to five points for correctly answering each of the questions below.
Instructions
The following table is a prime candidate for normalization.
Sample table
Examine the data contained in it and explain in your own words how you would normalize it. In particular, answer the following questions:
How many tables are required to normalize the data effectively, and what will they be titled?
How many columns will be included in each of the new tables, and what will their headings be?
Explain the rationale behind your answers to these questions.
Submitting the exercise
Once you have entered your responses into the text boxes, click the
Submit
button to submit the exercise and view one way in which the data might be normalized. Remember that you must submit all your responses to this exercise at once.