Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read carefully the instructions below before you start working on your project. You should submit your database file related to the question 1&2 and a separate word document with answers/explanations to the question 3 as requested below.

1. Create tables in the MS Access file by using the provided solution of "Group Project REA - Part II with Solution" (i.e., the normalized tables). In each table, define the primary key. Primary keys cannot be null. For each attribute, define the data type, provide a field description, and define the field properties if necessary

2. Establish relationships between all the tables you created. You may take a look at the video "How to add relationship between tables in Microsoft Access" on Canvas to add relationships between tables. Make sure that you enforce the referential integrity in all your relationships. Referential integrity rule: Foreign key which link rows in one table to rows in another table must have values that correspond to the value of a primary key in another table.

3. Document the existing internal control structure based on your current design.

You may refer to some controls we discussed in Chapter 13. You only need to specify one threat and one related control. For example, the threat to the database could be entering an invalid supplier when an employee enters the purchase order. To control the threat, we can apply the validity check by comparing the supplier ID which the employee enters with the purchase order with the supplier ID in the supplier mater file to verify that the account exists. (Please do not use this example in your submission)

I only need #3 answered.