Flowcharting/Pseudocode
Assignment:
I am giving you the layout or structure of a file. This file was not created in access, it just a generic file. Below the structure, I am showing you the data that is on the file.
Employee File:
Characters |
Field Name |
Data |
Allowed codes |
Data Type |
1-5 |
IDNO |
Identification Number |
|
Num |
6-25 |
NAME |
Name |
|
Text |
26-29 |
YRBTH |
Year of Birth |
|
Num |
30 |
GEN |
Gender |
M, F, U |
Text |
31 |
MARSTAT |
Marital Status |
S, M, W, D, U |
Text |
32-33 |
NUMDEP |
Number of Dependents |
|
Num |
34-36 |
ED |
Education |
NOH, HSC, GED, C2, C4, M, PHD |
Text |
37 |
JBCD |
Job Code |
S, F, P |
Text |
38-42 |
PAYHR |
Pay per hour for full time and part time |
|
Num (2 dec) |
43 - 50 |
SAL |
Salary |
|
Num (2 dec) |
51-55 |
BONUS |
Bonus |
|
Num |
56-57 |
DEPT |
Department |
2 digit numeric |
Num |
58-59 |
STATE |
State |
2 char state code |
Text |
Sample data: Note
that on the disk this is a long string of data. I have broken it up so that the records are easy to see. Note that I have also put character
positions to help you read the data.
11111111111122222222222223333333333334444444444444555555555555
12345678901234567890123456789012345678901234567890123456789
11111Michael
Costa 1970MM03C2
S00000052000000600015MA
12121Susan
Morse 1980FS01C2
S00000052000000000015RI
12345John
Wilson
1975MM03GEDF03000000000000000015MA
12356Ann
Johnson 1977FM06C2
S00000060000000600015NY
12567Lee Stuart 1980UU00C4 S00000035000000000014MA
20000Linda
Costa 1956FM06C2
S00000060000000000008RI
21000James Allan 1981MM06C4 S00000065000000600016MA
21234Kevin
Brooks 1956MS01M F03500000000000000004MA
23456Stanley
Souza 1981MD06C2
F02600000000000000010MA
24567Jane
Trever 1982FM03C4
S00000045000000600016MA
27890Doris
Tyler 1984FM06C2
S00000075000000600015MA
30000Peter
Anders
1976MD01GEDP01875000000000000013RI
31234Al
Richards 1956MS01M S00000110000001000015MA
40000Susan
Jenkins 1950FM06C2
S00000090000001000010RI
41111Ann Lynch 1989FS01C4 F05000000000000550017MA
54321David Lee 1987MS01C2 F03000000000000000008MA
Problem #1: Print or display a list of all records
where the state is equal to either MA or RI.
Problem #2:
Print or display a list of all records where the year of birth is
greater than 1980 and the marital status is married.
Problem #3: The list you are printing or displaying
should have a message that says SALARIED if the job code is S should say HOURLY
for all other codes.
Problem #4:
Print a list of all people who make a bonus greater than 5000 and either
have a salary greater than 50000 or a pay per hour greater than 25 per hour.
Problem #5: Print a list of all people in department
15 who either are salaried and make more than 60000 or are part time or full
time and make more than 25 per hour.
Problem #6: Print or display a list of all people and their dept group. If the dept is greater than 16 they are in SALES, if the dept is between 10 and 15 inclusive they are in FINANCE, if the dept is between 7 and 9 inclusive they are in PAYROLL, otherwise they are in BUSINESS.
Problems #7: If the person is married and has more than 5 dependents MOVE MSG-1 TO MSG-PR, if the person is married and does not have more than 5 dependents MOVE MSG-2 TO MSG-PR, if the person is not married with more than 4 dependents MOVE MSG-3 TO MSG-PR, if the person is not married and does not have more than 4 dependents MOVE MSG-4 TO MSG-PR.
Problem #8: The list you are printing should meet the
following criteria:
·
If the person is female and married and has more than
three dependents print the message GROUP1
·
If the person is female and married and has 0, 1, 2, or
3 dependents print the message GROUP2
·
If the person is female and not married print the
message GROUP3.
·
If the person is male and married and has more than
three dependents print the message GROUP4
·
If the person is male and married and has 0, 1, 2, or 3
dependents print the message GROUP5.
·
If the person is male and not married print the message
GROUP6.
·
If the gender is not known, print the message GROUP 7.