Question: You must design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. *can you

You must design a Microsoft Access database file for managing project & employee data with tables,
fields, relationships, and queries as given below.
*can you please explain the queries which is the most important part?
You must design a Microsoft Access database file
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 text, 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!