Welcome to Quality Essay Writers

information Systems homework help

information system
would you please do this work for me.

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 “Employees”

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)

Looking for a Similar Assignment? Our ENL Writers can help. Use the coupon code FIRSTUVO to get your first order at 15% off!
Let us help you
Customer Support
%d bloggers like this: