Practice Exercise: First Normalization Form Example

Normalization Practice Exercise

Examine the Relational Schema below.  Translate the relational schema into a schema that is normalized into first normal form.

I created a video of a representing of what would be presented on a projection screen in an in class presentation.  The only difference is the presentation will be on your personal device.  You can ask questions  asynchronously using CCP email. 

Link to the Practice First Normal Form Video Links to an external site.

Add any additional attributes that you think may be needed during this design check

Place the schema listed above into First Normal form.

Submit your Normalized Schema in a Microsoft Word or PDF Format