Second+Normal+Form

**Introduction**

The next step is to produce the data in Second Normal Form (2NF). Second Normal Form removes any partial dependencies from any of the relations. An attribute has partial dependency it is only depends on only part of a composite key.

1. Look at tables with a composite key 2. Review each non-key attribute to identify whether the attribute is dependent on part of the key or all of the key 2. Remove any partial key and dependants to a new table

**Example**

Working with our courses entity from First Normal Form...



...f ollow the steps to show the data in Second Normal Form (2NF)


 * 1. Look at tables with a composite key **

The only table with a composite key is the table //**pupil**//. Pupil has a composite key of //**pupil_id**// and //**course_id**//.


 * 2. Review each non-key attribute to identify whether the attribute is dependent on part or all of the key **

//**pupil_name**// is dependent on //**pupil_id**// only //**dob**// is dependent on //**pupil_id**// only //** tutor_group **//is dependent on //**pupil_id**// only

//**grade**// is dependent on //**pupil_id**// and //**course_id**//


 * 3. Remove any partial key and dependants to a new table **