Course Number:
CoSc 322
Course Title: Fundamentals of Database Systems
Credit: 4; Lecture: 3 hours; Lab: 3 hours; Prerequisite: none
Course Description: Database management systems; database design for real applications; database models: net
relational database concepts; standard SQL (relational algebra, relational calculus); transac
concurrency control and distributed database; and object-oriented databases.
Course Objectives: After completing this course the student will be able to:
define and explain database concepts;
design and develop databases using a standard and appropriate software; and
implement, use and evaluate developed databases.
Course outline Chapter One :Introducation to Database Management Systems
Introduction to database system
Database system and File System
Characteristics of the Database Approach
Actors on the Scene
Chapter Two : Data Models
Data Models, Schema and Instances
DBMS Architecture and Data Independence
Database Language and Interface
The Database System Environment
Introduction to ODL
E/R Model
Design principles, Network and hierarchical
Classification of DBMS
Chapter Three: Data Modeling using Relational Database
Using High level Data Models for Database Design
Entity types and Sets, Attributes and Keys
Relationships, Roles and Structural Constraints
Weak Entity Types
Database Abstraction
E/R Diagram naming conventions, and Design issues
Chapter Four : Data base Design
Introduction
Functional Dependency
Normalization
Chapter Five Standard SQL
Chapter Six : Database security.
Chapter seven: Object-Oriented Databases
Chapter Five : Structured Query Language(SQL)
SQL Statements
SQL Query
Data Manipulation Language
Constraints and Triggers
Chapter Six : Database security.
Chapter seven: Object-Oriented Databases
Compulsory
Course Status: Ramez Elmasri and Shamkant B. Navathe (2000) Fundamentals of Database Systems, 3rd e
Text Book
Reference Date, C. J. (2000) An Introduction to Database Systems. Massachusetts: Addison Wesley
Ramakrishman, Raghu & Johannes Gehrke (2000) Database Management Systems. 2nd ed.
Shepherd, John C. (1990) Database Management: Theory and Practice. Boston: IRWIN
Ramakrishman, Raghu & Johannes Gehrke (1998) Database Management Systems. 2nd ed.
Siberschatz, Abraham Henry F. Korth & S. Sudarshan (1997) Database System Concepts,
Ullman, Jeffrey & Jennifer Widom (1997) A First Course in Database Systems. Prentice-H
Garcia-Molina, Hector; Jeffrey Ullman & Jennifer Widom (2000) Database System Implem
Stonebraker, Michael & Joe Hellerstein, eds. (1998) Readings in Database Systems. Morga
Software Requirement: SQL/ORACLE
Instructional Methods: Lectures, Laboratory
Method of Evaluation: Continues Assessments and mini Project (50%) and Final Exams(50%)
