take un-normalized data and create tables with primary key fields that are in 3rd normal form. Review the un-normalized data below and then answer the questions.

Which attributes would you consider to be primary key fields and why?

Do you see any transitive dependencies?

What tables and attributes would be considered in 3NF?

Example of Unnormalized Data STUDENT Figure 1-13 Example of unnormalized data