we are given with some data that we need to use in mysql [login to view URL] the given data we need to make an ER DIAGRAM. then we need to make a new ER diagram from the given one by showing some normalization, denormalization (mentioned in the assignment). after that we need to make some changes in the coding for the new ER diagrams (only create and alter table) and need to make 2 procedures. In the end, the result of these two procedures should be popped up with the python (means in a html page). Brief description is attached and further information will be provided later.