Database Systems II

CSEN5314 Database Systems II

Advanced concepts and architecture of database systems, ER model, relational model, relational algebra, SQL, ER-to-rational mapping, functional dependencies normalization, database design process, object-oriented database, and distributed database.

List of topics

• Course Description and Overview

• Databases and Database Users

• Database System Concepts and Architecture

• Data Modeling Using the Entity-Relationship (ER)

• Enhanced Entity-Relationship (EER) Model

• The Relational Data Model and Relational Database

• Mapping a Conceptual Design into a Logical Design

• SQL

• Object and Object-Relational Databases

• Introduction to SQL Programming Techniques

• Web Database Programming Using PHP

• Introduction to Normalization Using Functional Dependencies

• No-SQL Databases

Textbook

Fundamentals of Database Systems, by Ramez Elmasri & Shamkant Navathe. Pearson Education. 6th Edition. ISBN: 9780133001655.