As a final project I am asking you to transform the table representing the Customer Order Table of the Equipment Store for Athletes normalizing it into 4NF. The store sells baseballs, basketballs, and golf equipment. Remember to follow the normalization process described in the textbook, which includes:

* Each relation (table) represents a single subject. For example, a COURSE table will contain only data that directly pertain to courses.

* Each row/column intersection contains only one value and not a group of values.

* No data item will be unnecessarily stored in more than one table (tables have minimum controlled redundancy).

* All nonprime attributes in a relation (table) are dependent on the primary key - the entire primary key and nothing but the primary key.

* Each relation (table) has no insertion, update, or deletion anomalies, which ensures the integrity and consistency of the data.

Once you complete the normalization into 4NF, create a prototype of the normalized database using Microsoft-Access.

Instructions:

Study the table that you can open using Excel. Create a document (e.g. Word file, or PowerPoint) describing with diagrams (preferably using Visio) your results. Your work will be better supported if you include and explain every step you take to achieve the final report, since I can see your progress, and, if needed, I can consider any deviation/error to grant you partial credit. Include any business rules assumed (if any) when making decision during the transformation.

As you can check in the Excel file, I have highlighted in yellow the attributes constituting the composite primary key. From here, follow the normalization process to reach a database with all its tables in 4NF.

Then, create the database's prototype in MS-Access including all relationships between tables. Enter all corresponding records for each table.