Satisfaction Guarantee

First time here?

usewelcome15 to get 15% off

choose a database optimization strategy, whether physical or logical, and describe how it could potentially benefit any or all of your normal form examples. Provide a comparison between a use case with and without this strategy implemented.

For the database concept you have chosen for Parts 1 and 2, provide the following:Display your entities/tables in first normal form (1NF)Display your entities/tables in second normal form (2NF)Display your entities/tables in third normal form (3NF)You may need to rework your relationships to achieve this. For each form, provide the tables and the defining associations.Next, define three (3) business processes that will access a particular table and attribute. For example: “A customer login process will require accessing the CUSTOMER table and retrieving the CustomerID and CustomerPassword attributes.” Provide detail on what the business process is and who is involved. For each business process, provide the SQL that would need to be run to access it in the first, second, and third normal forms you provided in the previous section.Finally, choose a database optimization strategy, whether physical or logical, and describe how it could potentially benefit any or all of your normal form examples. Provide a comparison between a use case with and without this strategy implemented.