The Portable MBA in Finance and Accounting, 3rd Edition

550

EXHIBIT 16.6 Database example.

EMPLOYEE TABLE

Social

Date of

Hourly

Employee

Security

Marital

Number of

Date of

Date of

D

ate of

Last

or

Number

First Name

Initial

Last Nam

e

Number

Status

Dependents

Birth

Hi

re

Termination Pay Raise Pay-Rate

Salary

1

Mary

E

Smith

123456789

M

4

4/1/63 7/21/91

9/1/96

8.505

H

2

Tom

T

Day

234567890

M

3

3/2/55 11/15/91

1/15/96 750.000

S

3

Harry

F

Jones

345678901

S

1

11/30/71 1/15/92

9/24/96

11/6/94

12.500

H

4

Sally

D

Kraft

456789012

S

0

10/5/65

3/6/92

3/5/96

14.755

H

5

Charlie

Malt

567890123

S

1

6/6/80

6/2/93

6/17/96 900.000

S

6

John

K

Free

678901234

M

5

8/5/49 11/1/94

12/15/95

17.500

H

PAY TA BL E

Number of

Number of

Social

Federal

Employee

Regular

Overtime

Security

Medicare

Withholding

Check

Number

Date

Hours

Hours

Gross Payroll

Tax

Tax

Tax

Net Pay

Number

1

1/7/96

40.0

4.0

391.23

24.26

5.67

101.1642534

21.52

238.62

1

2

1/7/96

40.0

0.0

750.00

46.50

10.88

193.935

41.25

457.44

2

3

1/7/96

40.0

0.0

500.00

31.00

7.25

129.29

27.50

304.96

3

4

1/7/96

40.0

4.0

678.73

42.08

9.84

175.5060034

37.33

413.97

4

5

1/7/96

40.0

0.0

900.00

55.80

13.05

232.722

49.50

548.93

5

6

1/7/96

40.0

2.5

765.63

47.47

11.10

197.9753125

42.11

466.97

6

1

1/14/96

40.0

12.0

493.29

30.58

7.15

127.5549282

27.13

300.87

7

2

1/14/96

40.0

0.0

750.00

46.50

10.88

193.935

41.25

457.44

8

3

1/14/96

40.0

8.0

650.00

40.30

9.43

168.077

35.75

396.45

9

4

1/14/96

40.0

7.9

765.05

47.43

11.09

197.8257886

42.08

466.62

10

5

1/14/96

40.0

0.0

900.00

55.80

13.05

232.722

49.50

548.93

11

6

1/14/96

40.0

0.0

700.00

43.40

10.15

181.006

38.50

426.94

12

1

1/21/96

40.0

0.0

340.20

21.09

4.93

87.968916

18.71

207.49

13

2

1/21/96

40.0

0.0

750.00

46.50

10.88

193.935

41.25

457.44

14

3

1/21/96

40.0

2.4

545.00

33.79

7.90

140.9261

29.98

332.41

15

4

1/21/96

40.0

6.7

738.49

45.79

10.71

190.9581624

40.62

450.42

16

5

1/21/96

40.0

0.0

900.00

55.80

13.05

232.722

49.50

548.93

17

6

1/21/96

40.0

5.0

831.25

51.54

12.05

214.944625

45.72

507.00

18