RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
Relational Constructs
«Prev
Next»
Data Analysis
Relational Constraints
DB Life Cycle
Relational Notation
Database Notation
Table Characteristics
Table Column Rules
Table Row Rules
Columns Entity Attributes
Calculate Domain Types
Database Null Values
Key Column Descriptors
Primary Key
Surrogate Keys
Concatenated Keys
Primary Foreign Key
Defining Foreign Keys
Referential Integrity
Relational Constructs Conclusion
Normal Forms
Reduce Data Redundancy
Normalization Defined
Normalization Objective
First Normal Form
Achieving First Normal
First NF Limitations
Second Normal Form
Define Functional Dependencies
Identify Functional Dependencies
Achieving 2ND Normal Form
Second NF Limitations
DB Normalization Conclusion
Normalization - Quiz
Third Normal Form
2NF Limitations
Transitive Dependencies
Eliminate Dependencies
Achieve Third Normal Form
1st, 2nd, 3rd NF
Codds Twelve Criteria
(BCNF) Four Important Rules
Codds Twelve Rules
Boyce Codd Normal Form
Denormalizing Tables
Joins, User Views
Permissions Design Role
SQL Joining Tables
Table Join Explanation
Create Equi Join
Permissions Requirements Analysis
SQL Inner Join
Physical Design
Database Clustering
Database Partitioning
Horizontal Partition
Disadvantages Horizontal Partitioning
DB Vertical Partitioning
Disadvantages Vertical Partitioning
Use SQL to Build DB
SQL Commands to Create Table
DB Design Mistakes
Business Objects Rules
Common Mistakes
Primary Foreign Key Mistakes
Rules for Database Rows - Exercise
Translate entities and attributes
Objective:
Translate entities and attributes into tables with column headings.
Exercise scoring
This exercise is worth a total of two points. This exercise 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.
Background/overview
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.
Instructions
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
Submit
button to receive credit for completing the exercise and view a results page.