Use SSMS and explain step by step how to do this. Up vote.

In this assignment you will create logical designs and then normalize them to specific levels. You are not creating tables, rather you are creating logical designs which are precursors to tables. a. Create a logical design for a relation that is in UNF. Use the notation introduced in the slides and videos. b. Explain why it is in UNF and not in 1NF C. Convert the logical design to 1NF. Explain your work. 2. Create another logical design for a relation that is in 1NF. Use the notation introduced in the slides and the videos a. Explain why it is in 1NF and not in 2NF. b. Convert the logical design to 2NF. Explain your work. In this assignment you will create logical designs and then normalize them to specific levels. You are not creating tables, rather you are creating logical designs which are precursors to tables. a. Create a logical design for a relation that is in UNF. Use the notation introduced in the slides and videos. b. Explain why it is in UNF and not in 1NF C. Convert the logical design to 1NF. Explain your work. 2. Create another logical design for a relation that is in 1NF. Use the notation introduced in the slides and the videos a. Explain why it is in 1NF and not in 2NF. b. Convert the logical design to 2NF. Explain your work