DATABASES

AIM

Understanding the concepts underlying the design and implementation of database systems. Establishing a solid background in data management, with a focus on relational database management systems and practicing actual database design, implementation, and query formulation through a term project.

CONTENT

This course contains; Database Management Systems,Relational Data Model ,Entity/Relationship Model,Relational Algebra,Structured Query Language, SQL ,Database Application Development,Relational Database Design,File Organization ,Tree-Structured Indexing ,Hash-Based Indexing,Query Processing,Query Optimization,Concurrency,Overview of Transaction Management.

1. 1

   At the end of this course the student would have a solid background on database management systems and their underlying data structures and algorithms

   Taught by: Problem Solving Method, Question - Answer Technique, Project Based Learning Model, Experiential Learning, Lecture Method · Assessed by: Traditional Written Exam, Homework, Project Task

2. 2

   At the end of this course the student would be able to design databases using relational database methods and apply this knowledge to the real life applications.

   Taught by: Problem Solving Method, Self Study Method, Project Based Learning Model, Experiential Learning, Lecture Method · Assessed by: Traditional Written Exam, Homework, Project Task

3. 3

   At the end of this course the student would learn the data structures underlying the database management systems and the access methods as well as the query processing that use them.

   Taught by: Problem Solving Method, Self Study Method, Question - Answer Technique, Lecture Method · Assessed by: Traditional Written Exam, Homework

4. 4

   During this course students are going to learn the SQL language for interacting with the database management systems.

   Taught by: Problem Solving Method, Self Study Method, Question - Answer Technique, Lecture Method · Assessed by: Traditional Written Exam, Homework, Project Task

WEEKLY PLAN

1. WEEK 0

   Database Management Systems

2. WEEK 1

   Relational Data Model

3. WEEK 2

   Entity/Relationship Model

4. WEEK 3

   Relational Algebra

5. WEEK 4

   Structured Query Language, SQL

6. WEEK 5

   Database Application Development

7. WEEK 6

   Relational Database Design

8. WEEK 7

   File Organization

9. WEEK 9

   Tree-Structured Indexing

10. WEEK 9

    Hash-Based Indexing

11. WEEK 10

    Query Processing

12. WEEK 11

    Query Optimization

13. WEEK 12

    Concurrency

14. WEEK 13

    Overview of Transaction Management

ASSESSMENT

• Rate of Midterm Exam to Success30%
• Rate of Final Exam to Success70%

READING

• Database Management Systems, 3rd Edition, R. Ramakrishnan, J. Gehrke McGraw- Hill, 2003
• The notes and the presentations will be delivered during the lectures.

TEACHING STAFF

• Prof.Dr. Reda ALHAJJCOORDINATOR
• Prof.Dr. Reda ALHAJJ