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 - Part II with Solution" (1.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 . REA Diagram + Employee(CEO) Flower Inventory Order Inventory 888 Employee Purchasing Cierto Vendor Receive Order Employee (Warehouse Clerk Employee (CEO) Cash Make Payment 88& Employee (AP Clerk) Vendor Table Name Primary Key Foreign Key Other Attributes OrderInventory PODate Purchase OrderNo PreparedEmployeeNo, AuthorizedEmployeeNo, Vendor No ReceiveOrder ReceiptNo EmployeeNo, VendorNo, Receipt Date Payment No, PurchaseOrder No MakePayment Payment No PaymentDate, Payment Amount, PreparedEmployeeNo, AuthorizedEmployeeNo, Vendor No, AccountNo, Flower Inventory ProductNo Description, QtyOn Hand, List Price Cash Account No AccountType, Bank, Account Balance Vendor Vendor No VendorName, VendorAddress, Balance Employee EmployeeNo EmployeeName, Employee Address, DateStarted, Job Title, Phone Flower Inventory- PurchaseOrderNo, OrderInventory Product No QtyOrdered, Order Price ProductCondition FlowerInventory- ProductNo, ReceiveOrder ReceiptNo Note: Law o lint Electable Note: For OrderInventory table, we do not need to have ProductNo as a foreign key to link Flower Inventory table. Instead, Flower Inventory-OrderInvetory table will link the Orderloventory table and Flowerinventory table together. For ReceiveOrder table, we do not need to have Product No as a foreign key to link Flowerinventory table. Instead, FlowerInventory-ReceiveOrder table will link the ReceiveOrder table and FlowerInventary table together, 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 - Part II with Solution" (1.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 . REA Diagram + Employee(CEO) Flower Inventory Order Inventory 888 Employee Purchasing Cierto Vendor Receive Order Employee (Warehouse Clerk Employee (CEO) Cash Make Payment 88& Employee (AP Clerk) Vendor Table Name Primary Key Foreign Key Other Attributes OrderInventory PODate Purchase OrderNo PreparedEmployeeNo, AuthorizedEmployeeNo, Vendor No ReceiveOrder ReceiptNo EmployeeNo, VendorNo, Receipt Date Payment No, PurchaseOrder No MakePayment Payment No PaymentDate, Payment Amount, PreparedEmployeeNo, AuthorizedEmployeeNo, Vendor No, AccountNo, Flower Inventory ProductNo Description, QtyOn Hand, List Price Cash Account No AccountType, Bank, Account Balance Vendor Vendor No VendorName, VendorAddress, Balance Employee EmployeeNo EmployeeName, Employee Address, DateStarted, Job Title, Phone Flower Inventory- PurchaseOrderNo, OrderInventory Product No QtyOrdered, Order Price ProductCondition FlowerInventory- ProductNo, ReceiveOrder ReceiptNo Note: Law o lint Electable Note: For OrderInventory table, we do not need to have ProductNo as a foreign key to link Flower Inventory table. Instead, Flower Inventory-OrderInvetory table will link the Orderloventory table and Flowerinventory table together. For ReceiveOrder table, we do not need to have Product No as a foreign key to link Flowerinventory table. Instead, FlowerInventory-ReceiveOrder table will link the ReceiveOrder table and FlowerInventary table together
