Att_Num: System-generated number. Att FName: The first name of the attendee. Pres_SessionNum: System-generated number. Att_LName: The last name of the attendee. Pres_Order: Number indicating the order of the presentations during the Att_Status: Whether or not the attendee has paid session. the registration fee. Pres_Date: The date that the presentation is scheduled to be given. Pres_Room: The room in which the presentation will be given. Pres_Title: The title of the presentation. Pros_AuthorlD: System gonerated number assignod to prosontation authors. Pres_FName: The first name of the presentation author. Pres_LName: The last name of the presentation author. Part 1. Using the descriptions of the attributes given in the figure, convert the ERD shown in into a dependency diagram containing entities in at least 3NF. Remember, you should work one entity at a time. For full credit, you need to include and clearly label all the dependency types in the initial dependency diagram (fully functional, partial, and transitive), all intermediate normalization steps/stages, and all the normal forms(1NF, 2NF,3NF) for every entity. To help you start on the right track. The correct initial dependency diagram with all the dependencies arrows is attached. This is best used after you come up with your own initial dependency diagram based on the question prompt. That way you can check your work and correct your design before starting the normalization process. You will still need to label all dependency types. Part 2. Use the dependency diagram below to work the following problems. a. Label all dependency types: fully functional, partial, and transitive dependencies. b. Break up the dependency diagram shown in above figure to at least 2NF. c. Modify the dependency dsagrams you created in part b to produce a set of entities that are in 3NF