Relationship between tables and apply referential integrity

Assignment Help Management Information Sys

Reference no: EM13896547

Access Assignment

Use the input document to create two tables in Access. You are creating a database for a fitness club.

The tables in the input document are only data for creating the tables in Access. They are not an example of what the finished product will look like

The field names for creating the tables are in the first row of each table. They are in bold to distinguish them from the data in the rows below them. They will not be in bold in Access.

In each table, use the field that uniquely identifies each record as the primary key

Do not use the ID/AutoNumber field as the primary key. You will select a field from the input tables to be the primary key as described above

All of the fields will be text data type except the Number of Clients field which will be Number data type and Pay Rate which will be Currency data type

In the trainer table, use a caption for the Pay Rate field. The caption will be Hourly Pay.

The fitness club has 3 locations. You will add a lookup field call Location and use codes for the locations as the lookup values. The values are:

BR
CM
LS

Create a relationship between the tables and apply referential integrity

Client Table

CLINET NUMBER	FIRST NAME	LAST NAME	ADDRESS	CITY	STATE	ZIP	PHONE NUMBER	TRAINER NUMBER
CN2314	Brenda	Kee	123 Main	Tacoma	WA	98401	253-555-1212253-555-1212 FREE253-555-1212253-555-1212 FREE	26
CN2134	Jim	Bowles	1514 Oak	Tacoma	WA	98401	253-555-2629253-555-2629 FREE253-555-2629253-555-2629 FREE	25
CN2152	Susan	Jamie	1424 W.28^th street	Tacoma	WA	98402	253-555-6542253-555-6542 FREE253-555-6542253-555-6542 FREE	26
CN1634	Karen	Quo	5436 Kensington	Tacoma	WA	98402	253-555-4875253-555-4875 FREE253-555-4875253-555-4875 FREE	25
CN2214	Bill	Simms	3258 Brentwood	Tacoma	WA	98401	253-555-0932253-555-0932 FREE253-555-0932253-555-0932 FREE	24
CN2331	Liz	Timmons	1862 Liberty	Tacoma	WA	98402	253-555-2178253-555-2178 FREE253-555-2178253-555-2178 FREE	25
CN2147	Tim	Dooley	6523 Dooley	Tacoma	WA	98401	253-555-9371253-555-9371 FREE253-555-9371253-555-9371 FREE	24

Trainer Table

Trainer number	First name	Last name	Address	City	State	Zip	Number of clients	Pay rate
24	Lucy	Leman	5847 Washington	Tacoma	WA	98402	2	20.00
25	Brain	Kasey	1827 35^th street	Tacoma	WA	98401	3	25.00
26	Ken	Jacobs	6309 Brogan	Tacoma	WA	98402	2	20.00

Reference no: EM13896547

Questions Cloud

Associate victorianism with extremes of doubt : Readers associate Victorianism with extremes of doubt and faith. Major Victorian poets certainly reflect these extremes, ideas which continue to circulate in our own century.

How many customers is current process able to accommodate : How many customers is the current process able to accommodate per hour? Use line balancing and service blueprinting to redesign the process at Sonnie's. What changes do you recommend? Why?

Methods to a real-world situation : methods to a real-world situation

Examine exile through emotion : 1. Can you explain and give references from the poems (quotes, etc.) how the two poems examine exile through emotion and what emotions accompany exile in the two poems?

Relationship between tables and apply referential integrity : Use the input document to create two tables in Access. You are creating a database for a fitness club. Create a relationship between the tables and apply referential integrity

What steps are required to change a dysfunctional culture? : What steps are required to change a dysfunctional culture?

Explain secured and unsecured bebt : The law firm is in the process ofpurchasing a number of new company desktop computers, printers, notebook computers and servers. Your firm is planning to borrow money from a bank to complete the transaction.

Which processes are likely to be used by ohoris and folgers : Is the operations layout likely to be the same or to be different at Ohori's and Folgers? Why? Using the product-process matrix, which processes are likely to be used by Ohori's and Folgers? Why?

What personal property is exempt from bankruptcy proceedings : What personal property is exempt from bankruptcy proceedings in the state of Ohio? I understand there are different laws for each state within the United States - however is there a standard for the United States compared to other countries? I wa..

User Account

All Pages