information system
bappi
Information_SystemBappiBaruaSraman.xlsxTo 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 "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) |
Database
| Employee | 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. | Montréal | H9B 1M8 | (438) 555-6775 |
| Chantier Cloutier Enr. | Longueuil | J6G 4R7 | (438) 555-4657 |
| CSST | Montréal | ||
| Dandurand & Fils Enr. | Québec | K5B 4S7 | (418) 555-2424 |
| Entr. Poile Enr. | Montréal | 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 | Montréal | H7W 8I9 | (438) 555-2101 |
| Forget & Cie | St-Laurent | H7F 8N4 | (438) 555-8566 |
| Fournitures Kenney | Longueuil | J5U 8H6 | (438) 555-8567 |
| Garde et Frères | Montréal | H1G 6N8 | (438) 555-7576 |
| Harold & Cie | Montréal | H7G 5V6 | (438) 555-9005 |
| Hugo Salvo Inc. | Montréal | H7N 8K9 | (438) 555-7487 |
| Igloo Equip. Ltd. | Montréal | H2G 8D3 | (438) 555-8598 |
| Island Voyages Inc. | Montréal | H9V 4D2 | (438) 555-8690 |
| Jacques et Bernard | St-Hubert | J8R 6G7 | (438) 555-6374 |
| La Valise Enr. | Montréal | H8C 9B6 | (438) 555-5984 |
| Le Store Ltée | Ste-Thérèse | J9M 4V8 | (418) 555-6868 |
| Maurice & Frères Inc. | St-Hubert | J7G 8V9 | (438) 555-7689 |
| Meilleur Services | Montréal | H8D 4V5 | (438) 555-8590 |
| Ministère du Revenu du Québec | Montréal | ||
| GSP, Anthony | Longueuil | J8N 7V3 | (438) 555-9367 |
| OCS Hardware Inc. | Montreal | H8N 3O8 | (438) 555-8484 |
| Octave Electrique | Montréal | H8M 4N4 | (438) 555-4636 |
| Oyo Shu Shu & Assoc. | Montréal | H8D 6B5 | (438) 555-5896 |
| Pavé Exclus Enr. | Beloeil | J7R 8U5 | (438) 555-7388 |
| Performance Assurée | Montréal | J8M 4F9 | (438) 555-8697 |
| Pierre Boisvert Ltée | St-Hilaire | J3H 1W6 | (438) 555-5683 |
| Receveur general | Montréal | ||
| REER Fonds Canadien | Montréal | ||
| Remorques Tremblay | Montréal | H7N 4S6 | (438) 555-8690 |
| Roulottes & Cie | Montréal | J8N 6W4 | (438) 555-7849 |
| Sable & Gravier Mtl | Montréal | H9V 5F9 | (438) 555-6478 |
| Syndicat local #50 | Montréal | ||
| Terrasse Jolie Enr. | Montréal | J8G 9N0 | (438) 555-9236 |
| Terrassement Delorme | Drummondville | H4F 7J8 | (819) 555-8699 |
| Transport Gilbert | Montréal | J8D 7C6 | (438) 555-7639 |
| Ull. Aubaines | Montréal | H8F 6D9 | (438) 555-5894 |
| Utilité Charbonneau Ltée | Montréal | H7G 9N4 | (438) 555-8490 |
| Voyageur Affilier | Montréal | H8V 5R7 | (438) 555-5858 |
| Walla Affaires Inc. | Montréal | J8B 6G5 | (438) 555-8598 |
| gruel, amy | Santa Clara | 17075 | (417) 562-8800 |
| vandal, remi | Montréal | H9F 9D9 | (438) 555-3647 |
| nassau, marie | Granby | J3R 3H9 | (438) 555-4564 |
| alouette, pierre | Otterburn | J5F 9D9 | (438) 555-4698 |
| guay, joffrey | Montréal | H1B 3M9 | (438) 555-6775 |
| fleur, vanessa | Longueuil | J7G 5R9 | (438) 555-4657 |
| tremblay, chantale | Montréal | ||
| verra, marie | Québec | K7B 5S9 | (418) 555-2424 |
| chaumière, maria | Montréal | H9C 9E5 | (438) 555-2834 |
| norpart, françois | St-Jean | J9F 7D9 | (438) 555-7384 |
| giasson, alexandre | Ville D'Anjou | H9V 9M1 | (438) 555-7398 |
| boulanger, jonathan | Montréal | H9W 9I1 | (438) 555-2101 |
| boulanger, alain | St-Laurent | H9F 9N5 | (438) 555-8566 |
| poulain, yves | Longueuil | J7U 9H7 | (438) 555-8567 |
| gruel, paul | Montréal | H3G 7N9 | (438) 555-7576 |
| vandal, émile | Montréal | H9G 7V7 | (438) 555-9005 |
| nassau, rosaire | Blainville | H9N 9K1 | (438) 555-7487 |
| alouette, simon | Montréal | H3G 9D5 | (438) 555-8598 |
| guay, hubert | Montréal | H1V 5D3 | (438) 555-8690 |
| fleur, jasmin | St-Hubert | J9R 7G9 | (438) 555-6374 |
| tremblay, hugues | Montréal | H9C 1B7 | (438) 555-5984 |
| verra, gustave | Ste-Thérèse | J1M 5V9 | (418) 555-6868 |
| chaumière, philippe | St-Hubert | J9G 9V1 | (438) 555-7689 |
| norpart, andré | Montréal | H9D 5V7 | (438) 555-8590 |
| giasson, jocelyn | Montréal | ||
| Student Name | Laval | J9N 9V5 | (438) 555-9367 |
| quirion, christian | Montreal | H9N 5O9 | (438) 555-8484 |
| poulain, justin | Montréal | H9M 5N5 | (438) 555-4636 |
| gruel, brandon | Montréal | H9D 7B7 | (438) 555-5896 |
| vandal, manuel | Beloeil | J9R 9U7 | (438) 555-7388 |
| nassau, amel | Montréal | J9M 5F1 | (438) 555-8697 |
| alouette, antoine | St-Hilaire | J5H 3W7 | (438) 555-5683 |
| guay, louis | Montréal | ||
| fleur, gaspard | Montréal | ||
| tremblay, henri | Montréal | H9N 5S7 | (438) 555-8690 |
| verra, victor | Montréal | J9N 7W5 | (438) 555-7849 |
| chaumière, mélodie | Montréal | H1V 7F1 | (438) 555-6478 |
| norpart, annie | Montréal | ||
| norpart, amélie | Montréal | J9G 1N0 | (438) 555-9236 |
| boulanger, caroline | Drummondville | H5F 9J9 | (825) 555-8699 |
| quirion, éliane | Montréal | J9D 9C7 | (438) 555-7639 |
| poulain, marguerite | Montréal | H9F 7D1 | (438) 555-5894 |
| gruel, violette | Montréal | H9G 1N5 | (438) 555-8490 |
| vandal, anouk | Montréal | H9V 7R9 | (438) 555-5858 |
| nassau, lise | Montréal | J9B 7G7 | (438) 555-8598 |
| alouette, judith | Santa Clara | 17075 | (408) 562-8800 |
| guay, lara | Montréal | H9F 9D9 | (438) 555-3647 |
| fleur, suzanne | Granby | J3R 3H9 | (438) 555-4564 |
| tremblay, marianne | Otterburn | J5F 9D9 | (438) 555-4698 |
| verra, jessica | Montréal | H1B 3M9 | (438) 555-6775 |
| chaumière, sandie | Longueuil | J7G 5R9 | (438) 555-4657 |
| boulanger, anouk | Montréal | ||
| giasson, geneviève | Québec | K7B 5S9 | (418) 555-2424 |
| boulanger, suzie | Montréal | H9C 9E5 | (438) 555-2834 |
| quirion, virginie | St-Jean | J9F 7D9 | (438) 555-7384 |
| poulain, aurélie | Ville D'Anjou | H9V 9M1 | (438) 555-7398 |
| quirion, amy | Montréal | H9W 9I1 | (438) 555-2101 |
| poulain, remi | St-Laurent | H9F 9N5 | (438) 555-8566 |
| gruel, marie | Longueuil | J7U 9H7 | (438) 555-8567 |
| vandal, pierre | Montréal | H3G 7N9 | (438) 555-7576 |
| nassau, joffrey | Montréal | H9G 7V7 | (438) 555-9005 |
| alouette, vanessa | Montréal | H9N 9K1 | (438) 555-7487 |
| guay, chantale | Montréal | H3G 9D5 | (438) 555-8598 |
| fleur, marie | Montréal | H1V 5D3 | (438) 555-8690 |
| fleur, gustave | St-Hubert | J9R 7G9 | (438) 555-6374 |
| verra, françois | Montréal | H9C 1B7 | (438) 555-5984 |
| chaumière, alexandre | Ste-Thérèse | J1M 5V9 | (418) 555-6868 |
| norpart, jonathan | St-Hubert | J9G 9V1 | (438) 555-7689 |
| giasson, stéphane | Montréal | H9D 5V7 | (438) 555-8590 |
| boulanger, yves | Montréal | ||
| quirion, paul | Laval | J9N 9V5 | (438) 555-9367 |
| poulain, émile | Montreal | H9N 5O9 | (438) 555-8484 |
| gruel, rosaire | Montréal | H9M 5N5 | (438) 555-4636 |
| vandal, simon | Montréal | H9D 7B7 | (438) 555-5896 |
| nassau, hubert | Beloeil | J9R 9U7 | (438) 555-7388 |
| alouette, jasmin | Montréal | J9M 5F1 | (438) 555-8697 |
| guay, hugues | St-Hilaire | J5H 3W7 | (438) 555-5683 |
| guay, henri | Montréal | ||
| tremblay, philippe | Montréal | ||
| verra, andré | Montréal | H9N 5S7 | (438) 555-8690 |
| chaumière, jocelyn | Montréal | J9N 7W5 | (438) 555-7849 |
| norpart, alain | Montréal | H1V 7F1 | (438) 555-6478 |
| giasson, christian | Montréal | ||
| boulanger, justin | Montréal | J9G 1N0 | (438) 555-9236 |
| quirion, brandon | Drummondville | H5F 9J9 | (825) 555-8699 |
| poulain, manuel | Montréal | J9D 9C7 | (438) 555-7639 |
| gruel, amel | Montréal | H9F 7D1 | (438) 555-5894 |
| vandal, antoine | Montréal | H9G 1N5 | (438) 555-8490 |
| nassau, louis | Montréal | H9V 7R9 | (438) 555-5858 |
| alouette, gaspard | Montréal | J9B 7G7 | (438) 555-8598 |
| gruel, joffrey | Santa Clara | 17075 | (412) 562-8800 |
| fleur, victor | Montréal | H9F 9D9 | (438) 555-3647 |
| tremblay, mélodie | Granby | J3R 3H9 | (438) 555-4564 |
| verra, annie | Otterburn | J5F 9D9 | (438) 555-4698 |
| chaumière, julie | Montréal | H1B 3M9 | (438) 555-6775 |
| norpart, caroline | Longueuil | J7G 5R9 | (438) 555-4657 |
| giasson, éliane | Montréal | ||
| boulanger, marguerite | Québec | K7B 5S9 | (407) 555-2424 |
