DIS-390-001

Database Management

Instructor:

Anita Lee-Post

Semester:

Spring 2004

Office:

BE 455F

Office Hours:

MW 3:30-4:30pm

Classroom:

BE 213

Class Time:

MW 4:30-5:45pm

Homepage

http://www.uky.edu/~dsianita/390db

 

Textbook

Modern Database Management, Fred R. McFadden, Jeffrey A. Hoffer, and Mary B. Prescott, 6th Edition, Prentice Hall, 2002.

ISBN 0-13-033969-5.(required)

http://myphlip.pearsoncmg.com/phlip/mpbookhome.cfm?vbookid=321

 

 

New Perspectives on Microsoft Access 2002 - Comprehensive, Joseph J. Adamski, and Kathleen T. Finnegan.  Course Technology, 2002.  ISBN: 0-619-02089-X. (required)

 

http://www.course.com/catalog/downloads.cfm?isbn=0-619-02089-X

 

Objectives

To develop an appreciation for data as a resource in an organization and to discuss the technical issues in managing data. Topics to be included are as follows

 

(1)  Basic concepts of data base systems and the advantages of using a data base approach for information processing;

 

(2)  Fundamentals of file organization and data structures necessary to understand data models and the operation of a data base management system;

 

(3) File and database design process.  This includes conceptual data model, logical and physical data base design;

 

(4) Issues involved in implementing database applications and managing a database systems;

 

(5)  Hands-on experience with a relational data base management system (ACCESS 2002) for the development of data base applications.

 

Assignments

There will be assignments involving the use of ACCESS 2002, written assignments, and a group project.  Details for these assignments will be announced in class with at least one week's notice.  Except for the group project, all other assignments are individual works (i.e., no copying from others or group work).

 

Quizzes:

To encourage student preparedness, attendance, attention, and participation, a total of 8 concept quizzes will be given during the semester, each marked on a scale of 10, with a guaranteed minimum of 5 awarded for merely being present. Of the 8 quizzes, only the best 7 will count. There will be no "make-up" quizzes, for any reason. 

 

 

Grading:

Class Behavior*

3%

 

Concept Quizzes

7%

 

Written Assignments

15%

 

ACCESS Assignments

20%

 

Group Project

30%

 

Final Exam.

25%

DIS-390-001

Database Management

Tentative Course Outline

 

Week

Dates

Topic

Readings

1-2

1/14-1/21

Introduction

Ch. 1, 2

3-4

1/26-2/4

Conceptual Design

Ch. 3, 4, Appendix A

5-7

2/9-2/25

Logical Design

Ch. 5, Appendix B

8

3/1-3/3

Physical Design

Ch. 6

9

3/8-3/10

ACCESS: Basic

 

11-14

3/22-4/14

ACCESS: Advanced

 

15

4/19-4/21

Data Administration

Ch. 12, 11

16

4/26-4/28

Presentation 

 

5/5

Final Exam., 3:30 – 5:30pm

 

*  Proper class etiquette is expected.  The following in-class behavior will count against your class behavior score:

·         Reading newspaper

·         Doing cross-word puzzle

·         Engaging in any class unrelated activities

·         Answering/making cell phone calls

·         Chatting

·         Eating/drinking

·         Personal web-surfing

·         Personal e-mailing

·         Walking in and out of the classroom