DIS-622-001
Business Data Systems Analysis and Design
|
Instructor: |
Anita
Lee-Post |
Semester: |
Spring
2005 |
|
Office: |
BE 455F |
Office Hours: |
MW |
|
Classroom: |
BE
201 |
Class
Time: |
MW
|
|
Homepage |
http://www.uky.edu/~dsianita/622 |
|
|
Textbook |
Modern
Database Management, Jeffrey A.
Hoffer, Mary B. Prescott, and Fred R. McFadden, 7th Edition,
Prentice Hall, 2004. ISBN
0-13-145320-3.(required) http://wps.prenhall.com/bp_hoffer_mdm_7 |
|
|
|
New
Perspectives on Microsoft Access 2003 - Comprehensive, Joseph J. Adamski, and Kathleen T. Finnegan. Course Technology, 2004.
ISBN: 0-619-20672-1. (required) |
|
|
|
http://www.course.com/catalog/downloads.cfm?isbn=0-619-20672-1 |
|
|
Supplemental |
Available at Johnny Print,
254-6139 |
|
|
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 2003) for the development of data base applications. |
|
|
Assignments |
There
will be assignments involving the use of ACCESS 2003, written assignments,
and a group project. Details for these
assignments will be announced in class with at least one
week's notice. |
|
|
Late
Policy |
Assignments
submitted after the due date will be penalized 10% per day. |
|
|
Grading |
The
final grade will be determined as |
|
|
|
Class participation |
5% |
|
|
Written Assignments |
15% |
|
|
ACCESS Assignments |
25% |
|
|
Group Project |
30% |
|
|
Final Exam. |
25% |
Tentative Course
Outline
|
Week |
Dates |
Topic |
|
|
1-2 |
1/12-1/19 |
Introduction |
|
|
3-4 |
1/24-2/2 |
Conceptual Design |
|
|
5-7 |
2/7-2/23 |
Logical Design |
|
|
8 |
2/28-3/2 |
Physical Design |
|
|
9 |
3/7-3/9 |
ACCESS: Basic |
|
|
11-14 |
3/21-4/13 |
ACCESS: Advanced |
|
|
15 |
4/18-4/20 |
Data Administration |
|
|
16 |
4/25-4/27 |
Presentation |
|
|
|
5/2 |
Exam. @ |
|