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) |