Jerry Post

BUSI 137: Database Management

E-mail: Jerry@JerryPost.com

Supplemental Material


Course Objectives

Course Description

Database administration with focus on management problems and decision support issues; database design; normalization of data.

Software Used to Support Class

Microsoft Access, Microsoft SQL Server, Oracle 10g

Required Materials

Database Management Systems/4e Gerald Post, e-Book.


Projects and Assignments

Fundamental cases and exercises are detailed in the textbook. The specific assignments are listed in the following table.

Class Schedule and Assignments

January

Sun

Mon

Tue

Wed

Thu

Fri

Sat



1

2

3

4



5

6

7

8

9

10

11



12

13

14

A1: Ex #1

15

16

Lab 1

17

18




19

20

21

Lab 2

22

23

A2: Ex #4

24

25




26

A3: Ex #5

27

28

Lab 3

29

30

31

 

February

Sun

Mon

Tue

Wed

Thu

Fri

Sat

1




2

3

4

5

6

Lab 4

7

8




9

A4: Ex #5

10

11

12

13

A5: Ex #6

14

15




16

17

18

A6: Ex #7

19

20

Test 1

21

22




23

24

25

Lab 5
Case 1

26

27

A7: Ex #5,6,7

28

 

March

Sun

Mon

Tue

Wed

Thu

Fri

Sat

1




2

A8: Ex #15,16,17
Lab 6

3

4

Lab 7
A9: Ex #35,36,37

5

6

A10: Ex #4,5,6

7

8




9

10

11

12

13

14

15




16

17

18

A11: Ex #30,31,32

19

20

21

22




23

Lab 8

24

25

A12: Ex #23

26

27

Test 2

28

29




30

Lab 9

31

 

April

Sun

Mon

Tue

Wed

Thu

Fri

Sat




1

2

3

Lab 10

4

5




6

A13: Ex #3

7

8

Case 2

Lab 11

9

10

A14: Ex #22

11

12




13

14

15

Lab 12

16

17

A15: Ex #16

18

19




20

A16: Ex #18

21

22

Lab 13

23

24

A17: Ex #6

25

26




27

A18: Ex #29

28

29

Lab 14

30

 

May

Sun

Mon

Tue

Wed

Thu

Fri

Sat




1

A19: Ex #3

A20: Ex #9

2

3




4

Project

5

6

7

8

Final Exam 8:00

9

10




11

12

13

14

15

16

Commencement

17




18

19

20

21

22

23

24




25

26

27

28

29

30

31




Grading: Scale based on total points

x >= 90A
87.5 <= x < 90A-
85.0 <= x < 87.5B+
80.0 <= x < 85.0B
77.5 <= x < 80.0B-
75.0 <= x < 77.5C+
70.0 <= x < 75.0C
67.5 <= x < 70.0C-
65.0 <= x < 67.5D+
60.0 <= x < 65.0D
0.0 <= x < 60.0F

Instructor

Jerry Post

Email: Jerry@JerryPost.com

Phone: 209-946-2627

Office Hours: MW: 9-11, 1-3; Th: 10-12

Attendance

Attendance is the responsibility of the student. Historically, students who miss several classes tend to receive one grade lower than other students.

I will give "make-up" exams only in the case of emergencies. The student is responsible for notifying me before the scheduled test.

Assignments

Assignments are due at class time on the specified date. Late assignments might not be accepted and can be penalized 10% per day.

Cheating

If I find assignments that are copies of each other, all students involved will receive a zero for the assignment.