Milestone 2 Display Entities/Tables (24 pts

Subject:Computer SciencePrice: Bought3

Share With

Milestone 2

1. Display Entities/Tables (24 pts.)

For the database concept you have chosen for Milestone 1, provide the following:

• Display your entities/tables in first normal form
• Display your entities/tables in second normal form
• Display your entities/tables in third normal form

1. Business Processes (21 pts.)

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 run to access it in the first, second, and third normal forms you provided in the previous section.

1. Optimization Strategy (11 pts.)

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.