Data Base Management Systems
ISQS 6339 Summer 1996 Syllabus
Contents
[Instructor |
Text |
Overview of Course |
Grades |
Outline and Course Schedule |
Project ]
[Course Policy |
Group Work on Homework |
Late Homework |
Makeup Exams |
Class Preparation |
Disabled Students ]
- Name
- Dirk Baldwin
- Office
- BA 609
- Phone
- 742-3167
- e-mail from campus
- odirk on ttacs and coba computers
- e-mail via internet
- d.baldwin@ttu.edu
- Office Hours
- 1:00-2:00 M, T; 9:30-11:30 W, Th
Elmasri, R. & Navathe, S. B., Fundamentals of Database Systems, 1994.
Wood, C. A., Using PowerBuilder 4, Que, 1995.
A database is a fundamental component of an information system. Database Management Systems
(DBMSs) support data creation, update, retrieval and integrity. In this course, the following DBMS topics
will be discussed: The objectives of DBMSs, the theory behind DBMS architectures, data modeling,
database normalization, relational algebra and calculus, SQL, client/server systems, and topics related to
multiple user DBMS. In addition, the student will receive hands-on experience with several commercial
DBMSs.
Grades are assigned as follows: 90-100% A, 80-89% B, 70-79% C, 60-69% D, less than 60% F. Final grades are based on the following percentages: Midterm 25%, Final 30%, Homework 20%, Project 20%, Class Participation 5%.
The following outline and schedule may be changed at the discretion of the instructor.
Objective of DBMS
| Date | Reading | HW | Subject |
| May 29 | | | Introduction and Overview |
| | EN 1-2 | | Concepts, Objectives and Architectures |
| May 30 | EN 3 | | Data Modeling and ER Model |
Relational Database Querying and Updating
| Date | Reading | HW | Subject |
| June 10 | PB 1 | | Intro. to Client/Server and PB |
| | PB 2, 8 | | Defining DB and Data Windows |
| June 11 | PB 3, 9,
10 pp.267-283 | HW 3 Due | User Interface |
| June 12 | PB 4-7 | | PowerScript |
| June 13 | PB 12-20
10 pp. 284-294 | | Completing the System |
Logical Database Design
Physical Database Design
| Date | Reading | HW | Subject |
| June 20 | EN 4-5 | | File Organization |
| June 21 | EN 16 | HW 4 due | Query Optimization |
| | EN 23.1-23.5 | | Client Server Considerations |
Multiple User Considerations
Other Database Models
| Date | Reading | HW | Subject |
| July 2 | EN 22 | Project due | Object-Oriented DB |
| July 3 | EN 25 | | Emerging Technologies |
| July 5 | Final Exam 11:00-1:30
|
The project requires a team (2 - 4 members) to develop a database application. The team can use
PowerBuilder, Access, Visual Basic, or other approved "client/server like" development tools. The system should include a well organized database supported by any approved DBMS (e.g., Oracle, Ingres,
Access, Watcom). The system should also provide an end user with a friendly user interface. Students will be able to select from a set of possible projects. Students are also encouraged to suggest applications
based on a real world problem. The project should include a cover page, table of contents, an overview
of the application, end-user documentation, the database schema, portions of the project code, and good system documentation. Projects will be judged based on the quality of the database design, the quality of
the system design, system functionality, user friendliness, quality of end user documentation, and quality of the system documentation.
Students must complete their own homework. Copying homework is not allowed. If help is needed, the
student is encouraged to ask the professor or another student. Note there is a fine line between "help"
and completing homework for a student. Students should be careful not to cross this line.
Homework must be turned in at the beginning of class. There is a 10% per day penalty for late homework.
Makeup exams will be given only when the instructor, prior to the exam, has approved the request to
change the exam time. Approval will be given for illness, sickness or death in the family etc.
Read materials before class. A portion of your final grade is based on class participation.
Any student who, because of a disabling condition, may require some special arrangements in order to
meet course requirements should contact the instructor as soon as possible to make necessary accommodations. Students should present appropriate verification from Disabled Student Services, Dean
of Students Office. No requirement exists that accommodation be made prior to completion of the
approved University process.
Last modified: June 21, 1996
Dirk Baldwin, ISQS, Texas Tech,
d.baldwin@ttu.edu