First Semester , 2020-2021
This module aims to give the students the main concepts of databases, database models, database design, relational algebra, query languages, object oriented database, normalization techniques, query optimization and database on the web.
Syllabus: click here
Book:
Title: Fundamentals of Database Systems
Author(s): El Masri Navathe
Publisher: Addison-Wesley, 6th edition, 2014.
Website: www.awlonline.com
In addition to the above, the students will be provided with handouts by the lecturer.
Chapters:
Topic #1: Part 1: Databases and Database Users Part 2: DB, DBMS and Actors
Topic #2: Part 1: Data Models Part 2: Basic Definitions
Topic #3: ER Diagrams ......... ER Examples
Topic #4: ER Tables
Topic #5: Relational Model - Formal Definition
Topic #6: Relational Model Algebra - Basic operators
Topic #7: Normalization