In this project deliverable, you should develop the 10 functionalities proposed in deliverable 2 in MS Access, and turn in the following files:
1) The updated project proposal (Word document) which has the same five sections as before. Copy my comments from the deliverable 2 and highlight any changes you made from the previous version by turning track changes on in MS Word (or using a different text color).
2) A MS Visio file that contains the updated ERD (even if you didn’t make any changes from the previous version).
3) An Access database should have all the tables shown in the ERD with at least 6 to 7 records in each table and all the PK/FKs/relationships/data types properly enforced. The referential integrity option should be checked when setting up the relationship in MS Access. The Access file should also include the 10 queries used to accomplish the 10 functionalities outlined in the proposal. Name the 10 queries based on the order of functionalities listed in the Word document.
Please name the above file as Project_3_Lastname.docx /.vsdx /.mdb, respectively). All group members need to submit the these three project files.
The final project deliverable is due on November 30 at 11:59 PM. This is a firm deadline and no extension will be given. You are strongly encouraged to submit your project files earlier to avoid any technical issues.