Database Management Systems I
COSC 640
Fall 2009

Credit Hours : THREE (3)
Time : 3:00 PM - 5:50 PM (W)
Location : LH 201
Prerequisite: Admission to Computer Science Masters                           Program

Power Point Presentations:

• Chapter 1
• Chapter 2
• Chapter 3
• Chapter 4
• Chapter 5
• Chapter 6
• Chapter 7
• Chapter 8
• Chapter 9
• Chapter 10
• Chapter 11
• SQL Loader
• Chapter 12
• Chapter 13
• Chapter 14

Detailed Topics:

1. Introduction
2. DB Life Cycle
3. Architecture of DBMS
4. Data Models
5. DB Design
6. ER Model
7. Relationship Types
8. Functional Dependency
9. Relational DB
10. Normal Forms(1st, 2nd, 3rd, and BC)
11. Multivalued Dependency
12. Normal Forms (4th, and 5th)
13. Relational Algebra
14. Relational Calculus
15. SQL- DDL/Type/Constraints
16. SQL- Introduction to DML
17. Single Row Functions / Multiple Row Functions / Nested Query / Views
18. PL/SQL
19. Transaction Control
20. Composite Database / Subprogramming / Packages
21. Cursors / Error Handling
22. Triggers
    

References:

1. A First Course in DATABASE SYSTEMS ; BY Jeffrey Ullman and Jennifer Widom; Prentice Hall; ISBN 0-13-600637-X
   
2. Oracle Database 10g. The Complete Reference
   By Kevin Loney; Oracle Press. ISBN 0-07-225351-7
3. The Relational Model for Database Management(Version 2)
   By E. F. Codd. Publisher: Addison Wesley Company.
4. Database Systems: Principles, Design and Implementation
   By C. Ricardo, Publisher: Macmillan Company.
5. Database Management: Theory and Application
   By J.C. Shepherd. Publisher: Irwin Company.
6. An Introduction to Database Systems
   By B.C. Desa Publisher: West Company
7. Database System Concepts. 5Th Edition
   By Silberschatz, Korth, and Subarshan. McGraw Hill.
8. Database Systems
   By C. J. Date Addison and Wesley

URL:

• ER Diagram Tools
• Entity/Relationship and Relational Models
• Oracle Documentation

Database design and implementation, data models, database programming using relational database management systems as well as object oriented databases. An implementation of a comprehensive project using a commercial DBMS.

Course Objectives:

1. Introduction of DBMS applications
2. Introduction of database management system life cycle
3. Basic database design
4. Learn Structure Query Language (SQL)
5. Study of at least one commercial database management system
6. Design and implement a database for an enterprise

Projects & Assignments:

Students will be required to complete a paper/project and give a presentation in class

Grading Policy and Tentative Schedule

Note: There will be no make-up exams.