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.

Answered: u must design a Microsoft Access…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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

3) Queries:
Select and display all Employee records where the Department is Security
Select and display all Project codes and names where the Client is Burger King
Select and display all Employee first & last names where the Department is not Finance
Select and display all Client records where the zip code is 60607
Select and display all Employee records where the Project's Client is Epic Games
Select and display all Employee phone numbers where the last name is Smith and the
Department is Security
Select and display all Client names and emails whose Projects had a start date in October 2020
Checklist
1. 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.

Expert Solution

Introduction

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

**As the post contains many question parts and each part is itselft a question, As per Bartleby guidlines, we haveto sokvefirst question of first 3 sub parts. Kindly find solution to first 2 questions(table creation and relationship creation)