Course Description

With the rapid emergence of Relational Databases in today’s workplace, Database System’s skills are of critical importance. This course provides participants with the necessary skills to use and design Relational Database Systems. The in depth nature of course provides students with an understanding of what goes on “Behind the Sciences” inside a Database System for complete understanding of Relational Database Fundamentals.

Course will focus on Database System Architecture and the Functions of Database Management System (DBMS). Topics will include Data Modeling using Entity-Relationship Model, Storage of Databases, Hierarchical, Network and Relational Data Model, Formal and Commercial Query Languages, Functional Dependencies and Normalization for Relational Database Design, Relational Composition, Concurrency Control and Transactions Management.

Course Objectives

Upon completion of the course the student will be able to:

1. Understand the impact that Database Designs have on user interface and application program structure
2. Design and Implement a Relational Database and supporting applications
3. Design and Implement a Data Dictionary for a Relational Database
4. Understand multi-user database processing on LANs in Client-Server Systems

Course Outline

1. File Systems and Databases
   1. File Systems
   2. Database Systems
   3. Database Models
2. The Relational Model
   1. Logical View of Data
   2. Integrity Rules
   3. Relational Database Operators
   4. Relational Database Software Classification
   5. Data Redundancy
3. Introduction to SQL
   1. Data Definition Commands
   2. Data Management
   3. Queries
   4. Advanced Data Management Commands
4. Data Models
   1. Conceptual Model
   2. Internal Model
   3. External Model
   4. Physical Model
5. Entity-Relation Modeling
   1. The Entity-Relation Model
   2. Developing an ER Diagram
6. Normalization of Database Tables
   1. Normalization
   2. First Normal Form
   3. Second Normal Form
   4. Third Normal Form
   5. Boyoe-Codd Normal Form
7. Database Design
   1. Systems Development Life Cycle
   2. Database Life Cycle
8. Case Study University Lab
   1. Conceptual Design
   2. Logical Design and Implementation
9. Client Server Systems
   1. Client Server Environment
   2. Client Server Architecture
   3. Managerial Expectations

Text Books

1. C.J. Date, "An Introduction to Database Systems"

2. Catherine Recardo, "Database Systems Principles, Design and Implementation"

3. Thomas Connolly, Carolyn and Anne Strachan, "Database Systems A Practical approach to Design, Implementation and Manegement"

4. Raghu Ramakrishnan, Hohannes Gehrke, "Database Management Systems"