RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Relational Databases
«Prev
Next»
SQL Introduction
Course Prerequisites
Select Statement
What is SQL
Client/Server Request
SQL 92 (History)
SQL Dialect Variations
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Database Normalization
Data Table Example
Normalization Example Table
Table Normalization - Exercise
Three Normalization Levels
Relational Flatfile DB
SQL Columns Rows
SQL Foundations
Database Elements
Database Parts - Quiz
Database Spreadsheets
Databases Column Types
Create Index Column
SQL Select Statement
Selecting Information
Database Foundations - Quiz
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select Statement
Joining Tables
Database Table Normalization - Exercise
Breaking apart a database table from de-normalized form
Objective:
Understand normalization by breaking apart a table. Consider the following to-do list:
Task ID #
Task Description
Employee ID #
Due Date
Last Name
1
Management meeting
02
02/17/2008
Gauss
2
Create budget
02
01/01/2008
Gauss
3
Employee reviews
01
02/01/2008
Coulomb
4
Employee reviews
02
02/01/2008
Gauss
How can you break apart the table to normalize it for later use?
You might make several subsets of tables.
One example is a task table, which contains the task ID number and the task description.
Question:
Can you name two more possible tables?
Type your answer in the text area below and click the
Submit
button to submit your answer .
Submit