As a database administrator, you may often encounter old legacy databases created years or possibly decades ago. These will often be poorly normalized and may impact application performance or your ability to manage the data effectively. You may be called upon to refactor the databasethat is, redesign and upgrade it to better fit with modern requirements but still work with existing applications. In this modules discussion, you will practice evaluating a legacy database and normalize the design with a partner by creating an ER diagram and having your partner normalize it for you. Step 1 In your initial post, create a new relational database design that differs significantly from any previous designs you created for this class and any examples in the modules resources. Use the notation introduced in pages 88 and 104 of the textbook. The database design should represent a design that is lower than third normal form (i.e., it should be in first or second normal form but no higher). Refer to the weeks notes and readings for information on the normal forms. Post your design to the discussion forum (by directly write on your ). Please also describe in the post body the purpose of the database you designed, together with the meaning of each table and the relationships between the tables. Reply to the discussion topic and title your reply appropriately according to the database design content. **Note that, in order for your classmates to conduct normalization, at least one table in your database design MUST have partial and/or transitive dependencies within.