An-Najah Staff

Course title and number

Database Systems - 66315

Instructor(s) name(s)

Anas Tomeh

Contact information

tomeh@najah.edu. Office: 1360

Semester and academic year

First Semester 2010/2011

Compulsory / Elective

Compulsory

Course

Contents

(description)

Introduction

·         Database Users

·         Database system Concepts

·         Advantages of Using a DBMS

·         DBMS Architecture and Data Independence

Data Modeling Using the Entity-Relationship (ER) Model

·         Entity Types, Entity Sets, Attributes, and Keys

·         Relationships, Relationship Types, Roles, and Structural Constraints

·         ER Diagrams, Naming Conventions, and Design Issues

Enhanced Entity-Relationship and Object Modeling

·         Subclasses, Superclasses, and Inheritance

·         Specialization and Generalization

·         Modeling of UNION Types Using Categories

ER- and EER-to-Relational Mapping

Relational Data Model

·         Relational Model Concepts

·         Relational Algebra

·         Relational Calculus

SQL - The Relational Database Standard

·         Basic Queries in SQL

·         Insert, Delete, and Update Statements in SQL

·         Aggregations, Modifications, Advanced Operations

·         Views (Virtual Tables) in SQL

·         Specifying General Constraints as Assertions

·         Additional Features of SQL

Database Design Theory and Methodology

·         Informal Design Guidelines for Relation Schemas

·         Functional Dependencies

·         Normalization

·         Normal Forms Based on Primary Keys

·         General Definitions of Second and Third Normal Forms

·         Boyce-Codd Normal Form

Constraints and Triggers

Oracle's PL/SQL

Course Objectives

This course will provide a thorough introduction to the theory and practice of database systems. The emphasis will be on theoretical considerations involved in modeling data and in designing easy to use and efficient database systems. Students will also use the Oracle database management system for course project.

Intended learning

Outcomes and

Competences

At the end of this course students should be able to:

·         Know the difference between database system and file system

·         Represent the database system using (ER/EER) model

·         Construct relational data model

·         Represent database queries using relational algebra and relational calculus

·         Write SQL and PL/SQL

·         Write constraints and triggers

• Explain the concepts of functional dependencies and normalization.

Textbook and  References

Fundamentals of Database Systems 6^th edition by Elmasri & Navathe

Assessment Criteria

Activity

Percent (%)

Midterm Exams

40

Project

20

Final Exam

40

Week

Subject

1

Introduction

2

Data Modeling Using the Entity-Relationship (ER) Model

3

4

Relational Data Model

5

6

ER-to-Relational Mapping

7

MIDTERM EXAM 1

8

SQL - The Relational Database Standard

9

10

Database Design Theory and Methodology

11

12

Enhanced Entity-Relationship and Object Modeling and EER-to-Relational Mapping

13

MIDTERM EXAM 2

14

Constraints and Triggers

15

Oracle's PL/SQL

16

Final Exam