Extended DB Features
Oracle SQL Extensions
DB Life Cycle
Database Null Values
Defining Foreign Keys
1st NF Limitations
Reduce Data Redundancy
Normalization - Quiz
Third Normal Form
1st, 2nd, 3rd NF
Achieve Third Normal Form
Joins, User Views
Permissions Design Role
SQL Joining Tables
Permissions Requirements Analysis
SQL Inner Join
Disadvantages Horizontal Partitioning
Disadvantages Vertical Partitioning
Database Vertical Partitioning
DB Design Mistakes
Business Objects Rules
Primary Foreign Key Mistakes
Database Course Project - Exercise
Download the materials needed to complete the course project.
This exercise is worth a total of two points. The exercise is auto-scored, which means there is nothing to submit. After completing the exercise, click the
button below to receive credit and view the results.
The project for this course is based on a case study involving a fictional company called Stories on CD, Inc., a mail order company that sells books on CD.
In this exercise, you will download a document describing the company and its needs as they relate to data storage and retrieval.
Submitting your exercise
There is nothing to submit with this exercise. To download the material, click here.
Database Design Term Table
After having downloaded the material, click the
button below to receive credit for having completed the exercise and view a results page.