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
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
Rules for Database Rows - Exercise
Translate entities and attributes
Translate entities and attributes into tables with column headings.
This exercise is worth a total of two points. This exercise is auto-scored. When you have answered the question below, click the
button to receive credit for having completed the exercise and view a results page.
In this exercise, you will create tables with column headings based on the entities and attributes in the ER diagram for the course project. This is the beginning of a database design that tracks orders placed with Stories on CDs.
Below is an illustration of the ER diagram for the Stories on CD case study. Create tables with column headings for the Customer, Order, CD, Distributor, and Line Item entities on the diagram.
Stories on CD ER diagram
Submitting your exercise
This exercise is auto-scored, which means there is nothing to submit.
When you have answered the question, click the
button to receive credit for completing the exercise and view a results page.