The following is an example of a grade report for two students at the University of Southern New Jersey: Professor’s DepCarotmuresnetPTroitfleeIs’¡Gs>orar de 403Systems AnMalIySsis Diggs, T. I B 411ConcAeptual MFIoSundBatairornes, G. CHAPTER 13 • DESIGNING DATABASES 435 Major: MIS Status: Senior Major: MIS Status: Senior USN) Grade Report Spring Semester 2010 USN) .Grade Report Spring Semester 2010 Name: I. M. Smarte Student: 053-6929-24 Professor’s DGepraCadrotemuresnetPTroitfleeIssor 403SysteAms AnMalIySsisDiggs, T. 411ConceAprualMFISoundBaatiroren,s G. 420HumaBn FacMtoIrSs inBaISrre, 412DatabAase DCeIsSign Menzel, 1. 353Managem~nt ModMelusmey, J. A MIS L Name: E. Z. Grayed Student: 472-6124-59 Draw a data model diagram with associations for the user view. Convert the user view in Problem 2 to a 3NF relation. Show each step along the way. What problem might arise when using a primary key of course number for the data in Problem 2? (Hint: Think about what would happen if the Department Name [not shown in the data] changes.) Draw an entity-relationship diagram for the following situation: Many students play many different sports. One person, called the head coach, assumes the role of coaching all these sports. Each of the entities has a number and a name. (Make any assumptions necessary to complete a reasonable diagram. List your assumptions.) The entity-relationship diagram you drew in Problem 5 represents the data entities that are needed to implement a system for tracking students and the sports that they play. List the tables that are needed to implement the system, along with primary, secondary, and foreign keys that are required to link the tables .. 7. Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients ~uch as flour, spices, and milk are purchased from vendors. SO.!lletimes an ingredient is…