# In-Class Activity - Normalization (Week 14)

Consider the following 1NF table:

![](https://1974645470-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MUHtAUgyY4OQkpmg5Kx%2F-MafKwd9ENplNwHu6Bh-%2F-MafLATNMPaiVlMJ4req%2Fimage.png?alt=media\&token=7b89e351-2a57-45fa-84f9-df9c66d30881)

1.Identify “partial dependencies” in the table above.

2.Create THREE tables in 2NF from the given table.

3\. Identify “transitive dependencies” from your answer in step 2.

4\. Create FOUR tables in 3NF from your answer in step 2.

## Solutions:

### 1. 2NF

![](https://1974645470-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MUHtAUgyY4OQkpmg5Kx%2F-MafKwd9ENplNwHu6Bh-%2F-MafLJVooZUTGHdPzD_s%2Fimage.png?alt=media\&token=c87df5f7-5faf-488e-b46d-001371474eb7)

### 2. Two Additional Relations for 3NF

![](https://1974645470-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MUHtAUgyY4OQkpmg5Kx%2F-MafKwd9ENplNwHu6Bh-%2F-MafLPomHBVFBHOTnbzt%2Fimage.png?alt=media\&token=b4518731-316f-4b3f-b186-d2d560d0bc87)
