An-Najah National University
Engineering Faculty – Computer Engineering Department
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
|
|
Textbook and References |
Fundamentals of Database Systems 6th 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 |