Please help and explain.

Assignment

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)

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

3) Queries:

Select and display all Customer first & last names with a 2/29 birthday

Select and display all Agent first & last names where the Agent's Location is 1 or 2

Select and display all Location names & addresses

Select and display all Customer addresses, zip codes, & emails where the Customer's Agent has the last name "Jackson" & the first name "Bob"

Select and display all Account records (all fields) where the Account's status is "Platinum"

Select and display all Account ids, balances, & limits where the Account's Customer has the last name "Burns" & first name "Montgomery"

Checklist

1. Check your fields and make sure they match all the assignment specifications. 2. Check your relationships - referential integrity is unnecessary here and can make testing more difficult. 3. Test your queries: write one matching & one non-matching record for each query. then, when you run the query, you should get only the matching result. and if you do, then your query is probably correct. 4. Delete any records you have created in step 3.