Search This Blog

Database Systems PDF Elmasri and Navathe

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

Go to Book Website


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 :

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

1 comment: