Indiana University of Pennsylvania                               Dr. Shubra
Computer Science Department                                       Fall 1996
CO 441 - Data Base Management

Introduction

         This three credit upper level course is being offered to provide 
interested motivated students with a fundamental knowledge of, and a 
practical experience with, the database concept.  The course is a logical 
extension of the concepts taught in CO 315 Large File Organization and 
Access, CO 310 Data Structures and CO 220 Applied Computer Programming.

The course texts are:

         Required:

            Elmasri, R., Narathe, S., Fundamentals of Database Systems, 
		Second Edition

            Codd, E. F., "Relational Database:  A Practical Foundation 
		for Productivity",Communications of the ACM, Vol. 25, No. 2, 
			February, 1982, pp. 109- 117. 

            Kent, William, "A Simple Guide to Five Normal Forms in 
		Relational  Database Theory", Communications of the ACM, 
			Vol. 26, No. 1,  February, 1983, pp. 120-124.  

Objectives

1.       Extend integrated file systems to the data base concept of data 
	 storage and retrieval.

2.       Define the terminology embodied in data base systems and that used 
	 with specific software packages.

3.       Develop an understanding of the three fundamental approaches to a 
	 data base model.  Namely, relational, hierarchical, and network.

4.       Discover the advantages and limitations of the three approaches.
         
5.       Study end-user query languages available with existing DBMS 
	 software packages and categorize these languages using relational 
	  algebra or relational calculus theory.

6.       Study the theory behind the relational approach to dbms and the 
	 impact of this theory on data model design.

7.       Gain practical programming experience with the relational DBMS 
	 package available on the IUP Dec Vax System, i.e., VAX/RDB/SQL.

8.       Gain practical programming experience with a microcomputer based 
	 data base package such as Microsoft Access, DBASE III PLUS, Paradox, 
	  Oracle, etc.


Tentative Course Schedule where:

         E = Elmasri's Text
         Codd = E. F. Codd paper
         Kent = William Kent paper


Week            Topic                                    Reading    

1 - 2           Course Introduction, DBMS Concepts,      E1, E2, E3
                ER Model 

3               Network Data Model, Hierarchical         E10, E11
                Datamodel                        

4               Exam 1

4-5             Relational Data Model
                Relational Algebra                       Codd, E6

6               SQL Standard                             E7

7-8             Exam 2                                   E1 - E7, Codd
                VAX/RDB/SQL                          
                SQL Project (online)

9               Embedded SQL                             E7.7
	        Embedded SQL Project

10              Normalization & Data Base Design         E12, E13.1.4 - 13.6   
                Process                                  E14, Kent

11-12           Microcomputer DBMS                       Microsoft Access
                Microsoft Access Project

13              Emerging Trends                          E22.1-E22.4, E23.1-
							 23.4, E25.3.2

Grading
         Exam 1 and 2                200 points
         Final                       100 points
         Homework                     50 points
         SQL Online Project           50 points
         SQL Embedded Project         50 points
         Micro DBMS Project           50 points

                                500 points   

At worst, I will draw the line for the course grades as follows:

Total Possible Points

100 - 90%   -   A
 89 - 80%   -   B
 79 - 70%    -  C
 69 - 60%    -  D
 59 -  0%   -   F

         Because of the need to demonstrate software packages and to have 
hands-on exercises, the class will not always be held in the originally 
scheduled room.  Room changes will be announced in class.