DATABASE MANAGEMENT SYSTEM (CS443/G)- SPRING 2008

COURSE SYLLABUS

Instructor	Dr. Ahmed Emam
Phone	(270) 745-5011
E-mail	Ahmed.emam@wku.edu
Lectures	MWF    8:00 –8:55 p.m   TCCW 0306
Website	http://www.wku.edu/~ahmed.emam/CS443
Office Hours	MW 1:00 –3:00 p.m. & Tuesday 1:00 – 4:00 p.m @ TCCW 122 other times by appointment

Course Description:

This course covers the basic design and implementation of database management systems (DBMS). The following topics will be covered in the course : Database System Concepts and Architecture, Data Modeling Using the Entity-Relationship (ER) Model, The Relational Data Model and Relational Database, SQL and SQL Programming Techniques, and Practical Database Design using UML. Term project will be assigned and will require use of several established database systems.

Course Prerequisite:

Students have passed CS360( Software Engineering I) and CS338 ( Computer Science III) by grade of "C" or better.

Text:

Fundamentals of Database Systems, 5/E by Ramez Elmasri and Shamkant B. Navathe, Publisher: Addison-Wesley , ISBN # 0321369572

Reading Assignments:

Reading assignments serve as an aid to the class lecture topics. They will be assigned in the class and are expected to be completed before the next class.  Announced quizzes will be given on reading assignments.

Attending Policy:

Attendance will be recorded during each class meeting. You will miss a lot and your grade will be affected only by 5 % of class grade if you absence more than 3 classes without accepted excuse.

Grading Policy:

Your grade for this course will be calculated as a weighted average of the following:

Assignments	15 %
2 Quiz	10%
Mid Term Exam	20 %
Final Exam	25 %
Term Project	25%
Attendance	5%
Total	100%

(90% & up)               A	(60%-69.99%)             D
(80%-89.99%)           B	(below 60%)                F
(70%-79.99%)           C

Arrangements must be made IN ADVANCE if for some valid reason you cannot take an exam at the scheduled time.

Cheating Policy

Students are encouraged to work together and learn from each other.  However, cheating in any form on exams, or copying of homework or computer programs will not be tolerated.  Any evidence of cheating will result in a failing grade for the course. In addition, Moss Software which is an automatic system for determining the similarity of C, C++, Java will be used to detect plagiarism in programming classes.

General Policy:

Homework are due at the start of class on the due date. Late homework will only be accepted in extenuating circumstances.

Students with Disabilities:
If you need assistance under ADA, Pleases contact (745-5004). If you feel you need special accommodations, due to the physical or other situation. Pleases let me know in the first week of the course or make an appointment to discuss it with me as soon as possible.

Course Web Page

Keep an eye on this page for supplemental materials, copies of the lab assignments, notices, and important announcements. To get there, visit http://www.wku.edu/~ahmed.emam/CS443

Tentative Schedule:

Date	Topic
January 23	Introduction, An Example, Characteristics of the Database Approach, and Actors on the Scene
January 25	Workers behind the Scene, Advantages of Using the DBMS Approach
January 28	Data Models, Schemas, and Instances, Three-Schema Architecture
January 30	Data Independence, and Database Languages and Interfaces
February 1	The Database System Environment and Centralized and Client/Server Architectures for DBMSs
February 4	Classification of Database Management Systems
February 6	Using High-Level Conceptual Data Models for Database Design, An Example Database Application
February 8	Entity Types, Entity Sets, Attributes, and Keys, Relationship Types, Relationship Sets, Roles, and Structural Constraints, and Weak Entity Types
February 11	Refining the ER Design for the COMPANY Database, ER Diagrams, Naming Conventions
February 13	Design Issues, and Relationship Types of Degree Higher Than Two
February 15	Subclasses, Superclasses, and Inheritance, Specialization and Generalization
February 18	Constraints and Characteristics of Specialization
February 20	Generalization Hierarchies, and modelin of UNION Types Using Categories
February 22	An Example UNIVERSITY EER Schema, Design Choices, and Formal Definitions
February 25	Representing Specialization and Generalization in UML Class Diagrams, Data Abstraction, and Knowledge Representation
February 27	Unary Relational Operations: SELECT and PROJECT, and Relational Algebra Operations from Set Theory
February 29	Quiz #1
March 3	Binary Relational Operations: JOIN and DIVISION
March 5	Additional Relational Operations
March 7	Examples of Queries in Relational Algebra
March 10- 14	Spring Break Day
March 12	The Tuple Relational Calculus, and The Domain Relational Calculus
March 14	Midterm Exam
March 17	Relational Model Concepts, Relational Model Constraints and Relational
March 19	Database Schemas and Update Operations, Tranactions, and Dealing with Constraint Violations
March 21	Relational Database Design Using ER-to-Relational Mapping
March 24	Mapping EER Model Constructs to Relations
March 26	SQL Data Definition and Data Types, Specifying Constraints in SQL
March 28	Schema Change Statements in SQL, Basic Queries in SQL, and More Complex SQL Queries
March 31	INSERT, DELETE, and UPDATE Statements in SQL, Specifying Constraints as Assertions and Triggers, and Views in SQL
April 2	Database Programming: Issues and Techniques, Embedded SQL, Dynamic SQL, and SQLJ
April 4	Quiz #2
April 7	Informal Design Guidelines for Relation Schemas and Functional Dependencies
April 9	Normal Forms Based on Primary Keys, General Definitions of Second
April 11	Third Normal Forms, and Boyce-Codd Normal Form
April 14	Properties of Relational Decompositions
April 16	Algorithms for Relational Database Schema Design
April 18	Multivalued Dependencies
April 21	Fourth Normal Form m Join Dependencies and Fifth
April 23	Normal Form, Inclusion Dependencies, Other Dependencies and Normal Forms
April 25	The Role of Information Systems in Organizations, The Database Design and Implementation Process
April 28	Use of UML Diagrams As an Aid to Database Design Specification, and Rational Rose
April 30	Final Term Project Presentation-1
May 2	Final Term Project Presentation-2
Friday, May 9 : Final Exam from 8:00 a.m. to 10:00 a.m.

Important Dates:

· January 22 : Day and evening classes begin.

· February 1 : Deadline to apply for spring 2008 graduation..

· April 9 : Last day to drop a second bi-term course with a W.

· May 1 : Last day to apply for August 2008 graduation.

· March 26-March 28 Graduation Fair - Downing University Center