Design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below. 1) Tables: Fields (keys in yellow, foreign keys in blue)Account: id (number), customer (number), balance (number), limit (number), status (short text, maximum length 10)Customer: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), address (short text, maximum length 40), zip code (short text, input mask 00000-0000), email (short text, maximum length 30), agent (number), birthday (short date format, mm/dd/yyyy)Agent: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), email (short text, maximum length 30), phone (short text with 000-000-0000 input mask), location (number)Location: id (number), code (number), name (short text, maximum length 20), address (short text, maximum length 40), zip code (short text, input mask 00000-0000)2) Relationships: Link all foreign key fields to their original tablesAccount.customer to Customer.idCustomer.agent to Agent.idAgent.location to Location.id

In Microsoft Access, tables are the fundamental components of a database. They are used to store and…

Answered: Design a Microsoft Access database file…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Related questions

Concept explainers

Question

Design a Microsoft Access database file for managing project & employee data with tables, fields, relationships, and queries as given below.

1) Tables: Fields (keys in yellow, foreign keys in blue)

Account: id (number), customer (number), balance (number), limit (number), status (short text, maximum length 10)
Customer: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), address (short text, maximum length 40), zip code (short text, input mask 00000-0000), email (short text, maximum length 30), agent (number), birthday (short date format, mm/dd/yyyy)
Agent: id (number), last name (short text, maximum length 20), first name (short text, maximum length 20), title (short text, maximum length 4), email (short text, maximum length 30), phone (short text with 000-000-0000 input mask), location (number)
Location: id (number), code (number), name (short text, maximum length 20), address (short text, maximum length 40), zip code (short text, input mask 00000-0000)

2) Relationships: Link all foreign key fields to their original tables

Account.customer to Customer.id
Customer.agent to Agent.id
Agent.location to Location.id

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.