Database Systems

(Click to Download PDF Slides)

Text Book:     

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

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:  Download 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). Download 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).   Download 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). 
Download 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). Download Slides in PDF

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

- Chapter 6: The Relational Algebra and Relational Calculus (Basic Relational Algebra Operations and Additional Relational Algebra Operations). Download 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).Download 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).  
Download Slides in PDF