information system

would you please do this work for me. 

To do

REQUIRED Overall, you have to create 3 Tables, link the tables between themselves and prepare an Activity diagram You must prepare a Word document containing the following A) Printscreen of the DESIGN VIEW (not the datasheet view) of the Table 1 -2 -3 B) Printscreen of the DATASHEET VIEW (not the datasheet view) of the Table 1 -2 -3 C) Printscreen of the Form LAYOUT VIEW (Table 2 only)

D) Printscreen of the relationships between the tables (into

Database

tool)

E) Printscreen of the DESIGN VIEW (not the datasheet view) of the Query F) One Activity Diagram showing the 3 tables at the same time (Diagram must be created on Power point and copied on Word) STEP 1 (prepare Table 1) Table 1 will contain information about employee identiication Go to the next sheet named “Database” Show the employees with postal code containing the letter “N” and with the phone finishing by 7 You must replace “student name” by your own name ( My name will be: Bappi Barua Sraman) Record the above into Access as Table 1 named “

Employee

s” Make sure you adjust the column width so we can see all of the information Table 1 must be linked to Table 2 STEP 2 (prepare Table 2) Table 2 will contain information about employee salary 1st column = paycheck number 2nd column = rate per hour (ex : earn 20$ per hour) 3rd column = annual salary 4th column = make the link with Table 1 = you have to define what will be on that column Create data to fill each column. There must be data for all of the employees shown on Table 1 STEP 3 (prepare Table 3) Table 3 will contain information about employee department 1st column = work order number 2nd column = department number 3rd column = supervisor name 4th column = make the link with Table 2 = you have to define what will be on that column

Create data to fill each column. There must be data for all of the employees shown on Table 1

STEP 4 (prepare a Form) Prepare a Form using TABLE 2 only Make sure you modify the layout so we can see all of the fields on the screen STEP 5 (connect the Tables) Connect the 3 Tables (into Database tool) STEP 6 (prepare a Query) Prepare the following query Employee name – Rate/hour – Supervisor name – Phone – Cell – Paycheck number Must be only for

Montreal

employees STEP 7 (prepare Activity Diagram) You must build the Activity diagram on POWER POINT and copy the result on the Word document Table 1-2-3 must be shown on the same diagram There must be 1 decision node shown per Table (total of 3 decision node for the diagram)

Database

Employee

Montréal

Montréal

Montréal

Montréal

Longueuil

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

St-Hubert

Montréal

Montréal

Longueuil

Montreal

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

(438) 555-8690

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

Montréal

(438) 555-8598

Santa Clara

Montréal

(438) 555-3647

Granby

(438) 555-4564

Otterburn

(438) 555-4698

Montréal

(438) 555-6775

Longueuil

(438) 555-4657

Montréal

Québec

(418) 555-2424

Montréal

(438) 555-2834

St-Jean

(438) 555-7384

Ville D’Anjou

(438) 555-7398

Montréal

(438) 555-2101

St-Laurent

(438) 555-8566

Longueuil

(438) 555-8567

Montréal

(438) 555-7576

Montréal

(438) 555-9005

(438) 555-7487

Montréal

(438) 555-8598

Montréal

(438) 555-8690

St-Hubert

(438) 555-6374

Montréal

(438) 555-5984

Ste-Thérèse

(418) 555-6868

St-Hubert

(438) 555-7689

Montréal

(438) 555-8590

Montréal

(438) 555-9367

Montreal

(438) 555-8484

Montréal

(438) 555-4636

Montréal

(438) 555-5896

Beloeil

(438) 555-7388

Montréal

(438) 555-8697

St-Hilaire

(438) 555-5683

Montréal

Montréal

Montréal

(438) 555-8690

Montréal

(438) 555-7849

Montréal

(438) 555-6478

Montréal

Montréal

(438) 555-9236

Drummondville

Montréal

(438) 555-7639

Montréal

(438) 555-5894

Montréal

(438) 555-8490

Montréal

(438) 555-5858

Montréal

(438) 555-8598

Santa Clara 17075 (408) 562-8800

Montréal H9F 9D9 (438) 555-3647

Granby J3R 3H9 (438) 555-4564

Otterburn J5F 9D9 (438) 555-4698

Montréal H1B 3M9 (438) 555-6775

Longueuil J7G 5R9 (438) 555-4657

Montréal

Québec K7B 5S9 (418) 555-2424

Montréal H9C 9E5 (438) 555-2834

St-Jean J9F 7D9 (438) 555-7384

Ville D’Anjou H9V 9M1 (438) 555-7398

Montréal H9W 9I1 (438) 555-2101

St-Laurent H9F 9N5 (438) 555-8566

Longueuil J7U 9H7 (438) 555-8567

Montréal H3G 7N9 (438) 555-7576

Montréal H9G 7V7 (438) 555-9005

Montréal H9N 9K1 (438) 555-7487

Montréal H3G 9D5 (438) 555-8598

Montréal H1V 5D3 (438) 555-8690

St-Hubert J9R 7G9 (438) 555-6374

Montréal H9C 1B7 (438) 555-5984

Ste-Thérèse J1M 5V9 (418) 555-6868

St-Hubert J9G 9V1 (438) 555-7689

Montréal H9D 5V7 (438) 555-8590

Montréal

Laval J9N 9V5 (438) 555-9367

Montreal H9N 5O9 (438) 555-8484

Montréal H9M 5N5 (438) 555-4636

Montréal H9D 7B7 (438) 555-5896

Beloeil J9R 9U7 (438) 555-7388

Montréal J9M 5F1 (438) 555-8697

St-Hilaire J5H 3W7 (438) 555-5683

Montréal

Montréal

Montréal H9N 5S7 (438) 555-8690

Montréal J9N 7W5 (438) 555-7849

Montréal H1V 7F1 (438) 555-6478

Montréal

Montréal J9G 1N0 (438) 555-9236

Drummondville H5F 9J9 (825) 555-8699

Montréal J9D 9C7 (438) 555-7639

Montréal H9F 7D1 (438) 555-5894

Montréal H9G 1N5 (438) 555-8490

Montréal H9V 7R9 (438) 555-5858

Montréal J9B 7G7 (438) 555-8598

Santa Clara 17075

Montréal H9F 9D9 (438) 555-3647

Granby J3R 3H9 (438) 555-4564

Otterburn J5F 9D9 (438) 555-4698

Montréal H1B 3M9 (438) 555-6775

Longueuil J7G 5R9 (438) 555-4657

Montréal

Québec K7B 5S9

City

Postal Code

Cell phone

ACCPAC INTERNATIONAL, INC.

Santa Clara

95054

(408) 562-8800

Active Rental

Montréal

H7F 8D8

(438) 555-3647

Aladin Centre d’Achat

Granby

J1R 2H7

(438) 555-4564

Alarme Moderne

Otterburn

J3F 7D8

(438) 555-4698

Chanteclerc Ind. Inc.

H9B 1M8

(438) 555-6775

Chantier Cloutier Enr.

Longueuil

J6G 4R7

(438) 555-4657

CSST

Dandurand & Fils Enr.

Québec

K5B 4S7

(418) 555-2424

Entr. Poile Enr.

H7C 8E4

(438) 555-2834

Entr. Rigodon Inc.

St-Jean

J7F 5D8

(438) 555-7384

Entre Nous Ltée

Ville D’Anjou

H7V 8M9

(438) 555-7398

Fogarty Motors

H7W 8I9

(438) 555-2101

Forget & Cie

St-Laurent

H7F 8N4

(438) 555-8566

Fournitures Kenney

J5U 8H6

(438) 555-8567

Garde et Frères

H1G 6N8

(438) 555-7576

Harold & Cie

H7G 5V6

(438) 555-9005

Hugo Salvo Inc.

H7N 8K9

(438) 555-7487

Igloo Equip. Ltd.

H2G 8D3

(438) 555-8598

Island Voyages Inc.

H9V 4D2

(438) 555-8690

Jacques et Bernard

St-Hubert

J8R 6G7

(438) 555-6374

La Valise Enr.

H8C 9B6

(438) 555-5984

Le Store Ltée

Ste-Thérèse

J9M 4V8

(418) 555-6868

Maurice & Frères Inc.

J7G 8V9

(438) 555-7689

Meilleur Services

H8D 4V5

(438) 555-8590

Ministère du Revenu du Québec

GSP, Anthony

J8N 7V3

(438) 555-9367

OCS Hardware Inc.

H8N 3O8

(438) 555-8484

Octave Electrique

H8M 4N4

(438) 555-4636

Oyo Shu Shu & Assoc.

H8D 6B5

(438) 555-5896

Pavé Exclus Enr.

Beloeil

J7R 8U5

(438) 555-7388

Performance Assurée

J8M 4F9

(438) 555-8697

Pierre Boisvert Ltée

St-Hilaire

J3H 1W6

(438) 555-5683

Receveur general

REER Fonds Canadien

Remorques Tremblay

H7N 4S6

Roulottes & Cie

J8N 6W4

(438) 555-7849

Sable & Gravier Mtl

H9V 5F9

(438) 555-6478

Syndicat local #50

Terrasse Jolie Enr.

J8G 9N0

(438) 555-9236

Terrassement Delorme

Drummondville

H4F 7J8

(819) 555-8699

Transport Gilbert

J8D 7C6

(438) 555-7639

Ull. Aubaines

H8F 6D9

(438) 555-5894

Utilité Charbonneau Ltée

H7G 9N4

(438) 555-8490

Voyageur Affilier

H8V 5R7

(438) 555-5858

Walla Affaires Inc.

J8B 6G5

gruel, amy

17075

(417) 562-8800

vandal, remi

H9F 9D9

nassau, marie

J3R 3H9

alouette, pierre

J5F 9D9

guay, joffrey

H1B 3M9

fleur, vanessa

J7G 5R9

tremblay, chantale

verra, marie

K7B 5S9

chaumière, maria

H9C 9E5

norpart, françois

J9F 7D9

giasson, alexandre

H9V 9M1

boulanger, jonathan

H9W 9I1

boulanger, alain

H9F 9N5

poulain, yves

J7U 9H7

gruel, paul

H3G 7N9

vandal, émile

H9G 7V7

nassau, rosaire

Blainville

H9N 9K1

alouette, simon

H3G 9D5

guay, hubert

H1V 5D3

fleur, jasmin

J9R 7G9

tremblay, hugues

H9C 1B7

verra, gustave

J1M 5V9

chaumière, philippe

J9G 9V1

norpart, andré

H9D 5V7

giasson, jocelyn

Student Name

Laval

J9N 9V5

quirion, christian

H9N 5O9

poulain, justin

H9M 5N5

gruel, brandon

H9D 7B7

vandal, manuel

J9R 9U7

nassau, amel

J9M 5F1

alouette, antoine

J5H 3W7

guay, louis

fleur, gaspard

tremblay, henri

H9N 5S7

verra, victor

J9N 7W5

chaumière, mélodie

H1V 7F1

norpart, annie

norpart, amélie

J9G 1N0

boulanger, caroline

H5F 9J9

(825) 555-8699

quirion, éliane

J9D 9C7

poulain, marguerite

H9F 7D1

gruel, violette

H9G 1N5

vandal, anouk

H9V 7R9

nassau, lise

J9B 7G7

alouette, judith

guay, lara

fleur, suzanne

tremblay, marianne

verra, jessica

chaumière, sandie

boulanger, anouk

giasson, geneviève

boulanger, suzie

quirion, virginie

poulain, aurélie

quirion, amy

poulain, remi

gruel, marie

vandal, pierre

nassau, joffrey

alouette, vanessa

guay, chantale

fleur, marie

fleur, gustave

verra, françois

chaumière, alexandre

norpart, jonathan

giasson, stéphane

boulanger, yves

quirion, paul

poulain, émile

gruel, rosaire

vandal, simon

nassau, hubert

alouette, jasmin

guay, hugues

guay, henri

tremblay, philippe

verra, andré

chaumière, jocelyn

norpart, alain

giasson, christian

boulanger, justin

quirion, brandon

poulain, manuel

gruel, amel

vandal, antoine

nassau, louis

alouette, gaspard

gruel, joffrey

(412) 562-8800

fleur, victor

tremblay, mélodie

verra, annie

chaumière, julie

norpart, caroline

giasson, éliane

boulanger, marguerite

(407) 555-2424