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 30%

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. 15 - 17 Jan. Basic concepts of database management systems; comparison of DBMS and file systems; the relational database model.

Read: ch. 1,2.

2. 22 - 24 Jan. Entity-Relationship Modeling; Normalization

E-R modeling exercises will be assigned. Read. chs. 4,5.

3. 29 - 31 Jan Introduction to Structured Query Language

SQL exercises will be assigned. Read ch. 3

 4. 5 - 7 Feb. Normalization.

Normalization exercises will be assigned. Read. ch. 5

5. 12 - 14 Feb. Database Design.

Read ch 6; skim chs 7,8.

6. 19 - 21 Feb Transaction and concurrency management; distributed DBMS.

Exercises will be assigned. Read chs 9,10.

7. 26 - 28 Feb. Object-Oriented and Client-Server DBMS; Data Warehouses

Exercises will be assigned. Read chs 11, 12, 13.

8. 5 - 7 Mar. Database Administration.

Read ch 14.

Tentative Due Dates for Project.

24 January: Project proposal

31 January: Entity-Relationship Diagram for Project

14 February: Conceptual Database Design (Normalized Tables with Keys indicated)

5 March: Final Design Document; SQL statements to produce specified reports; working implementation of database system.

Return to: Graduate Programs Syllabi