Course Description: (three semester hours credit) Prerequisites: INSS 510 or 520 or 530 or permission of instructor. This course covers database design and relational database theory including characteristics of relational databases, domains and relations, relational integrity, relational operations (introduction to relational algebra and relational calculus), Structured Query Language, normalization, entity-relationship modeling, security, recovery, concurrency and data integrity in relational databases, distributed databases and client/server systems, data warehouses, and comparison of relational databases with object-oriented databases. An integral part of the course will be the design and implementation (in part) of a moderately complex database system.

Course Objectives: This course enables students to understand

1. The concept of information as a valuable organization resource requiring management to further the objectives of the organization

2. The use of computer-based database management systems to manage this valuable resource

3. Concepts of database architecture, design, administration and implementation.

Midterm Examination 30% Final Examination 35%

Class Project 20% Exercises 15%

Midterm and Final are closed-book examinations; the final is not comprehensive.

Students may work in groups to complete the class project, which involves the design and implementation (in part) of a functional database system.

Text: P. Rob and C. Coronel, Database Systems: Design, Implementation, and Management, 4th edition.

Instructor: The instructor, James Briscoe, has been involved with computer systems and database design for 15 years. He has a BS in Mathematics from Stanford University, an MBA (emphasis in MIS) from the University of Oklahoma, and a PhD (History) from Columbia University. He has taught programming, systems analysis and database design courses at the University of Maryland, European Division, and the University of Oklahoma. He was an instructor in Office Automation Systems Implementation for the Federal Aviation Administration.

(All readings from Rob and Coronel; supplemental readings TBA)

1. 24 March Basic concepts of database management systems; comparison of DBMS

and file systems; the relational database model.

Read: chs. 1,2.

2. 25 March Entity-Relationship Modeling;

E-R modeling exercises will be assigned. Read. ch. 4

3. 7 April Introduction to Structured Query Language

SQL exercises will be assigned. Read ch. 3

4. 8 April Normalization.

Normalization exercises will be assigned. Read. ch. 5

MIDTERM EXAM 28 April 0900-1200 references, chs 1-5.

5. 28 April. Database Design.

Read ch 6; skim chs 7,8.

6. 29 April Transaction and concurrency management; distributed DBMS.

Exercises will be assigned. Read chs 9,10.

7. 12 May Object-Oriented and Client-Server DBMS; Data Warehouses

Read chs 11, 12, 13.

8. 13 May. Database Administration.

Read ch 14.

FINAL EXAM. 13 March. 1300-1600 References, chs 6-14.

7. April Project Proposal

28. April Entity-Relationship models and Conceptual Database Design

12 May Final Design Document; SQL statements to produce specified reports; working implementation of database system.

Return to: Graduate Programs Syllabi