Part 1:Directions: Use the following information to complete the questions below. While APA format is not required for the body of this assignment, solid academic writing is expected, and documentatio

PRJ 2 - Database Design - 75 Points This deliverable appl ies database des ign patterns that we leaned in class ( transaction s and objects , categor y, and intersection tables ) in creat ing and query ing the data base schema for your process. The following 4 items are needed : 1. A data /relationship diagram showing tables, attributes, primary keys, and foreign key relationships . 2. At least one category table and a t least one intersection table . 3. The number of object and transaction tables will vary depending upon the complexity of your process. 4. A data design explanation section . o For each object , transaction , category and intersection table that you include in the data diagram , include 1 paragraph e xplaining the purpose served by the table and the logic for including the attributes. Clearly identify the primary key and foreign key(s) (if applicable) for each table. Also specify the purpose served by each foreign key. o For each intersection table , ALSO copy this paragraph filling in the parameters as appropriate : - Th e A_B_Intersection_Table_Name intersection table supports a many -to-many relationship between the Table_One table and the Table_Two table. Th e intersection table , itself, is not a list of individual events or objects of interest , rather its purpose is to record an association between items in the other tables . It has its own primary key and has two foreign key attributes Att_A which points to the primary key of Table_One and Att_B which points to the primary key of Table_Two . o Example data from ALL the tables in your Access database . Include enough data to demonstrate how the table works, e.g., category tables include at least 2 different categories and intersection tables show M:M relationships in action . A minimum of 2 rows for a category table , a minimum of 5 rows for object and transaction tables , and a minimum of 10 rows for intersection tables. - A copy of your Access database file which includes the data /relationship diagram and the tables with example data , so we can verify your work . - Also include the REVISED version of your PRJ1 document with your submission.