Prior to beginning work on this interactive assignment, read chapter 6 of your textbook as well as the Absolute Beginner's Guide to Database Normalization (Links to an external site.), Database Normalization (Links to an external site.) and Normalization: How far is far enough (Links to an external site.) online resources, and review any relevant information in this week’s lecture.Normalization is an important step towards translating models and diagrams into relational databases. In this exercise, you will need to normalize the Grade_Report table below and explain the steps needed to do so.For this assessment, consider the following entity and its attributes and normalize the entity Grade_Report to 3NF.Entity: Grade_Report (StudentID, StudentName, Phone, DOB, Address, Email_Address, CourseNumber, CourseName, Grade, DepartmentID, DepartmentName)Explain the steps needed to normalize this entity to 1NF, 2NF and 3NF. List the resultant Normalized entities in the same format as the original Grade_Report.Once the entity is normalized to 3NF, describe any issues this entity might have that can be solved by normalization. Explain the functional dependencies that exist between the attributes. Provide the steps required to break up the Grade_Report entity into multiple entities that each have a single theme.Your response must be a minimum of 250 words.Guided Response: Review several of your colleagues’ posts, and respond to at least two of your peers by 11:59 p.m. on Day 7 of the week. You are encouraged to post your required replies earlier in the week to promote more meaningful interactive discourse in this interactive assignment.Review your classmate’s proposed normalized tables and discuss whether the tables are fully normalized. Suggest at least one improvement or additional step needed to normalize the tables. In addition, suggest whether or not your classmate should normalize the entity to a higher normalization form (.i.e.: 4NF or 5NF). Describe a database environment that would require normalization to a higher normal form. Explain at least one advantage and one disadvantage for normalizing to 4NF or 5NF.Your response must be a minimum of 250 words.

PLEASE SEE PDF FOR FULL QUESTIONProject Outcomes1. Use the Java selection constructs (if and if else).2. Use the Java iteration constructs (while, do, for).3. Use Boolean variables and expressions to control iterations.4. Use arrays or ArrayList for storing objects.5. Proper design techniques.Project RequirementsYour job is to implement a simple amusement park information system thatkeeps track of admission tickets and merchandise in the gift shop. Theinformation system consists of three classes including a class to model tickets, aclass to model gift shop merchandise, the amusement park, and the amusementpark tester. The gift shop supports access to specific merchandise in the park’sgift shop and to purchase the merchandise or to order new merchandise for thegift shop. The UML diagram for each class (except the tester class) is givenbelow.

Checking for Winners and Managing the GameAll code is correct but there are two methods below in red where you need to do the logic for the game. Basically, checking the board to see if anyone has won and if there are more spaces to be selected.