u 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 y
u 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 y
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...
Related questions
Question
You must design a Microsoft Access
Transcribed Image Text: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.
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 (short
date)
Client: code (short text, input mask 000000), name (short text, maximum length 40), email (short
text, maximum length 30), address (short text, maximum length 50), zip code (short text, input
mask 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 input
mask), 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 tables
Project.client to Client.code
Employee.project to Project.code
Employee.department to Department.name
Transcribed Image Text: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)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 18 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY