Practice Exercise: Second Normalization Form Example

Normalization Practice Exercise

Examine the Relational Schema below.  Translate the relational schema into a schema that is normalized into Second  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 Second 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 Second Normal Form.

Submit your Normalized Schema in a Microsoft Word or PDF Format