Course Code :  CIS 260
Course Name : Database Systems     
Credit Hours : 3 Hrs

Course Prerequisites :  CS 117 (Object Oriented Programming)

Text Book:     

 Fundamentals of Database Systems, 5^th  Ed.,  Ramez Elmasri, and Shamkant B. Navathe,  Addison–Wesley, 2007.

Go to Book Website

If you have the original book then you can get all slides in the Book Companion Website. Just use the provided username and password.

Software:

DBDesigner 4: DB Designer 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.  [Get Presentation Slides about the DBDesigner in PDF]

You can download the Software (it is free) from this site : www.fabforce.net/dbdesigner
 

Course Short Description:

Concepts, database architecture, relational algebra, the relational model and the normalization process, functional dependencies, database integrity and security, concurrent operations on database, distributed database systems architecture, object-oriented database approach, and deductive databases.

Detailed Course Outlines:  Get the PDF version of the Course Syllabus

  
- Chapter 1: Databases and Database Users ( Introduction, Characteristics of the Database Approach, Actors on the Scene, Advantages of Using a DBMS, Implications of the Database Approach, When Not to Use a DBMS). Get Slides in PDF

- Chapter 2: Database System Concepts and Architecture (Data models, Schemas, and Instances, DBMS Architecture and Data Independence, Database Languages and Interfaces, The Database System Environment, and Classifications of Database Management Systems).   
Get Slides in PDF

- Chapter 3: Data Modeling Using the Entity-Relationship (ER) Model (Using High-Level Conceptual Data Models for Database Design, An Example-Company, Entity Types, Entity Sets, Attributes, and keys, Relationships, Relationship Types, Roles, and Structural Constraints, Weak Entity Types, Refining the ER Design for the Company Database, ER Diagrams, Naming Conventions, and Design Issues).
Get Slides in PDF

- Chapter 4: Enhanced Entity – Relationship (EER) model and Object Modeling (Subclasses, Super classes, and Inheritance, Specialization and Generalization, Constraints and Characteristics of Specialization and Generalization, Modeling of UNION Types  Using Categories, An Example UNIVERSITY EER Schema and Formal Definition for the EER Model, Conceptual Object Modeling Using UML Class Diagrams, Relationship Types of Degree Higher Than Two, Data Abstraction and Knowledge Representation Concepts).
Get Slides in PDF

- Chapter 5: The Relational Data Model and Relational Database Constraints (Relational Constraints, and the Relational Algebra (Concepts, Constraints, Schemas, Update Operations-Constraint Violations). Get Slides in PDF

- Chapter 6: The Relational Algebra and Relational Calculus (Basic Relational Algebra Operations and Additional Relational Algebra Operations). Get Slides in PDF
 

- Chapter 8: SQL-The Relational Database Standard (Definition, Constraints, and Schema Changes in SQL2, Basic Queries in SQL, More Complex SQL Queries, Insert, Delete, and Update Statements in SQL, Views(Virtual Tables) in SQL, Additional Features).
Get Slides in PDF

- Chapter 10: Functional Dependencies and Normalization for Relational Databases (Informal Design Guidelines for Relation Schemas, Functional Dependencies, Normal Forms Based on Primary Keys, General Definitions of Second and Third Normal Forms, Boyce-Codd  Normal Form).  
Get Slides in PDF

Final Exams

Grading Scheme:

First Exam:                                                          20%.
Second Exam:                                                      20%.
Assignments and Practical Lab Exam:               10%.
Final Exam:                                                          50%.