atomic values.

I want you to create... and then solve... a 2NF issue and a 3NF issue. You each have 5 students in your group. Pick one of the students to have the 'before' schema, and pick one of the students to have the 'after' schema For example, your group is going to tackle the 2NF issue. Build a table or tables that meet the requirements- a table with a primary key, no repeating groups or columns and atomic values. But the table is not certified 2NF. Pick someone in your group and use their schema as the starting point You will have to write scripts (Create, alter, update, insert commands) to massage the schema. Pick someone in your group to have the solution in their schema. Deliverables... the bad schema, denoting the 2NF violation. The good schema, denoting the 'fix'. And the scripts that fixed our issue. Those scripts should be evergreen-I can run them over and over and they'll still work. Then do the same for a 3NF violation. There are a billion examples online, but this one's not bad (easy to do): https://beginnersbook.com/2015/05ormalization-in-dbms/ This is a group assignment... only one person in the group needs to submit. 'll need a map of the schema names, the scripts executed to get the data normalized and a note of who helped with the project