You must design a Microsoft Access database file for managing project & employee data with tables,

fields, relationships, and queries as given below.

( please i want a full answer explained! expecially at number 3 (queries)

1) Tables: Fields (keys in yellow, foreign keys in blue) - ZipCode: zipCode (short text, input mask 00000-0000), city (short text, maximum length 30) - Client: code (short text, input mask 0000 ), name (short text, maximum length 40 ), email (short text, maximum length 30 ), address (short text, maximum length 50 ), zipCode (short text, input mask 00000-0000), phone number (short text with 000-000-0000 input mask) - Project. code (short text, input mask 0000-0000), name (short text, maximum length 20), client (short lext, input mask 0000), zipCode (short text, maximum length 30), startDate (short date) - Department name (short text, maximum length 20), location (short text, maximum length 30), email (short text, maximum length 30), phone number (short text with 000-000-0000 input mask) - Employee: idNumber (short text, input mask 0000), firstName (short text, maximum length 20), lastName (shortText, maximum length 30), email (short text, maximum length 30 ), phone number (short text with 000-000-0000 input mask), department (short text, maximum length 20 ), project (short text, input mask 000000-0000) 2) Relationships: Link all foreign key fields to their original tables - Client zipCode and Project.zipCode to ZipCode.zipCode - Project.client to Client.code - Employee.project to Project.code - Employee department to Department.name 3) Queries: - Select and display all Project names with a startDate in the years 2021 or 2022 - Select and display all Employee first \& last names where the Department is Accounting - Select and display all Client names and emails. - Select and display all Employee phone numbers where the last name is Williams and the department is Finance - Select and display all Employee records (all fields) where the Project's client is Riot Games - Select and display all Project names and startDates where the city (from ZipCode) is Boston 1) Tables: Fields (keys in yellow, foreign keys in blue) - ZipCode: zipCode (short text, input mask 00000-0000), city (short text, maximum length 30) - Client: code (short text, input mask 0000 ), name (short text, maximum length 40 ), email (short text, maximum length 30 ), address (short text, maximum length 50 ), zipCode (short text, input mask 00000-0000), phone number (short text with 000-000-0000 input mask) - Project. code (short text, input mask 0000-0000), name (short text, maximum length 20), client (short lext, input mask 0000), zipCode (short text, maximum length 30), startDate (short date) - Department name (short text, maximum length 20), location (short text, maximum length 30), email (short text, maximum length 30), phone number (short text with 000-000-0000 input mask) - Employee: idNumber (short text, input mask 0000), firstName (short text, maximum length 20), lastName (shortText, maximum length 30), email (short text, maximum length 30 ), phone number (short text with 000-000-0000 input mask), department (short text, maximum length 20 ), project (short text, input mask 000000-0000) 2) Relationships: Link all foreign key fields to their original tables - Client zipCode and Project.zipCode to ZipCode.zipCode - Project.client to Client.code - Employee.project to Project.code - Employee department to Department.name 3) Queries: - Select and display all Project names with a startDate in the years 2021 or 2022 - Select and display all Employee first \& last names where the Department is Accounting - Select and display all Client names and emails. - Select and display all Employee phone numbers where the last name is Williams and the department is Finance - Select and display all Employee records (all fields) where the Project's client is Riot Games - Select and display all Project names and startDates where the city (from ZipCode) is Boston