You must design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. Please submit your Access file without any data – the TAs will import data to test your work. However, you may find it useful to temporarily add some data to your tables, especially to test your queries You must design a Microsoft Access database file for managing project & employee data with tables,fields, relationships, and queries as given below. Please submit your Access file without any data – theTAs will import data to test your work. However, you may find it useful to temporarily add some data toyour tables, especially to test your queries.1) Tables: Fields (keys in yellow, foreign keys in blue)Project: code (short text, input mask 000000-0000), name (short text, maximum length 30),location (short text, maximum length 30), client (short text, input mask 000000), startDate (shortdate)Client: code (short text, input mask 000000), name (short text, maximum length 40), email (shorttext, maximum length 30), address (short text, maximum length 50), zip code (short text, inputmask 00000-0000), phone number (short text with phone number input mask)Department: name (short text, maximum length 20), email (short text, maximum length 30),phone number (short text with phone number input mask)Employee: idNumber (short text, input mask 000000), firstName (short text, maximum length 20),lastName (shortText, maximum length 20), phone number (short text with phone number inputmask), email (short text, maximum length 30), department (short text, maximum length 20),project (short text, input mask 000000-0000)2) Relationships: Link all foreign key fields to their original tablesProject.client to Client.codeEmployee.project to Project.codeEmployee.department to Department.name 3) Queries:Select and display all Employee records where the Department is SecuritySelect and display all Project codes and names where the Client is Burger KingSelect and display all Employee first & last names where the Department is not FinanceSelect and display all Client records where the zip code is 60607Select and display all Employee records where the Project's Client is Epic GamesSelect and display all Employee phone numbers where the last name is Smith and theDepartment is SecuritySelect and display all Client names and emails whose Projects had a start date in October 2020Checklist1. Check your fields and make sure they match all the assignment specifications.2. Check your relationships - referential integrity is unnecessary and can make testing more difficult.3. Test your queries: including one match & one non-match for each query. then, when you run the query,you should get only one matching result. and if you do, then your query is probably correct.4. Delete your data, if any.

Question

Accepted Answer

The given problem is related to MS Access where the database tables are to be created with given…