CIS 426 - Spring 1998
DATA BASE MANAGEMENT
CLASS HOURS: TTH. 4:30-5:45 p.m.
INSTRUCTOR: DR. AMINILARI, ABD
OFFICE: COMBS 319, PHONE: 783-2770
OFFICE HOURS: TTH 12:30-3:00 OR BY APPOINTMENT
EMAIL: MDUMAMIN@UKCC.UKY.EDU
=====================================================================
COURSE DESCRIPTION:
We will examine database systems as effective tools for business data management. This due to the significant role they play in a variety of computerized support systems. Being a senior-level business school course, the course equally emphasizes theoretical and practical considerations underlying database analysis, design, implementation, maintenance, and manipulation.
We will study three kinds of "data models" and representative "data base management systems" in depth. Namely, the hierarchical, the CODASYL-DBTG network, and the relational model, although more emphasis is placed on the currently-popular relational data model and relational data base management. Our discussions will also span topics such as data base administration, concerns in multi-user environments (security, integrity, locking, and concurrency control), distributed data bases, objected-oriented data bases, temporal data bases, statistical databases, and client-server systems. Also, we will review the current articles on DBMS throughout the semester. We will touch upon the concept of object oriented data bases by working on MultiMedia Database presentation systems.
Students will get the opportunity of participating in a project involving the analysis, design, and implementation of a Multimedia Database systems using MultiMedia ToolBook software.
PLEASE NOTE:
Students are expected to have a working knowledge of some third generation programming language, and the willingness and ability to quickly pickup corresponding programming constructs in MultiMedia ToolBook Scripts. This course involves a project which requires you to program extensively in ToolBook Software.
READINGS & REFERENCE MATERIAL:
1. For the theoretical material, there is no single "required" text for this course although there are two recommended texts.
The recommend texts are:
(a) Class Notes
(d) Multidatabase Systems: An Advanced Solution for Global
Information Sharing, IEEE Computer Society Press.
(e) Current articles on DBMS from different Journals and
commercial magazines.
2. For hands-on experience with a relational DBMS, the highly recommended book is:
Exploring Microsoft Access 97, By Rober Grauer and Barber.
(b) Advanced dBASE IV Programming, Phillip J. Pratt & Mary Z. Last, Boyd & Fraser.
3. For hands on experience with Object Oriented concept, the recommended book which describes MultiMedia Toolbook:
(a) Using Multimedia ToolBook 3.0. Hall, Boyd & Fraser
Publishing Co. (Available in Bookstore)
(b) Welcome To MultiMedia, Linda Tway, MIS Press.
can be bought at Joseph Beth Book
Seller in Lexington (Greenwood Mall). A CDROM is included.
Note: Each student must have two 3 1/2" HD floppy diskettes which are already formatted. They should only be used for the course.
EVALUATION:
Points Distribution:
ITEM POINTS SCHEDULE
------------------------------------------------------------
Mid Term Exam: 50 points (to be announced)
Group Project: 20 points (to be announced)
Student Lecture: 20 points (to be announced)
Homework & class
Participation: 10 points (every class meeting)
-------------------------------------------------------------
Total: 100 points
-------------------------------------------------------------
You will be given at least a one week notice for the midterm exam.
Assignments:
There will be current articles assigned in DBMS, and they will be discussed in the classroom.
The assigned project involves the analysis, design, and implementation of a database systems using the scripts of MultiMedia ToolBook software. The project will be subdivided into various phases or subtasks and I may set up individual due dates for the subtasks. The weight of 20 points for the project will be divided as appropriate for these subtasks. I will give you details as we proceed through the semester.
Each student gives one in-class lecture to the class on recent database research. The student will be the teacher for the lecture. It is a formal lecture and should be of more depth and duration than a typical in-class oral "presentation" of a topic. Topic assignment and scheduling of student lectures will be done in class during the early part of the semester.
For all of the activities in the course (exams, project subtask, student lecture), a student who is not present or does not complete assignments is liable to lose the entire weight of that activity, unless he/she demonstrates compelling reasons that warrant a schedule revision. If such events/reasons are known in advance, I must be notified in advanced.
Homework, Assignments and participation:
Weekly summary of articles
Participation is required in each meeting
GRADING POLICY:
The strictest grading policy that I may choose to enforce is:
TOTAL PERCENTAGE GRADE
90 - 100 = A
80 - 89 = B
70 - 79 = C
60 - 69 = D
59 - 00 = F
I may choose to relax this scheme, at my discretion, depending on how the class, as a whole, reacts to the material.
Attendance Policy:
Students are expected to be present in each class. Students who miss three or more classes a semester will receive a failing grade, unless the absences are excused in conformity with the University's attendance policy.
Semester Schedule:
Chapter 1-3 from notes.
Chapters to be covered in the Utilizing MultiMedia ToolBook, 3.0 (Chapters 1-17, Chapters 1-7 review briefly, and students responsible to read it on their own, chapter 8-17 will be discuss in the classroom in more details.).
Student Lectures:
The main topic sources to be used in the student lectures come
from C.J. Date, "An Introduction to Data Base". Other
sources depend on your preferences.
Page Chapter
Recovery and concurrency 401 16
Security and Integrity 429 17
Query Optimization 455 18
Semantic Modeling 579 22
Distributed Systems 617 23
Logic-Based System 641 24
Object-Oriented Systems 683 25
MultiMedia Database