Course Description

The main objective of this course is to provide students with the background to design, implement, and use database management systems. Database technology became very important due to the highly competitive environment and the explosive use of the internet in Business-to-Client and Business-to-Business applications and the need to store more business data. Recent developments in database technologies include the applications data warehousing and data mining.

Syllabus

Database Management
Data, Information and knowledge, Increasing use of data as a corporate resource, data processing verses data management, file oriented approach verses database oriented approach to data management; data independence, database administration roles, DBMS architecture, different kinds of DBMS users, importance of data dictionary, contents of data dictionary, types of database languages. Data models: network, hierarchical, relational. Introduction to distributed databases, Client/Server databases, Object-oriented databases, Object-relational databases, Introduction to ODBC concept. Introduction to decision support system.
 

The Relational Model 
Definition of relation; properties of relational model concept of keys;  candidate key, primary key, alternate key, foreign key, fundamental integrity rules : entity integrity, referential  integrity. Storage organizations for relations, Relational Algebra, Integrity constraints, Triggers and Cursors. Embedded SQL and Application Programming, Interfaces. Case studies of Commercial Relational DBMS implementations.

Database Design 
ANSI/SPARC 3 level architecture; Conceptual model, Logical model, Physical model.    Entity - Relationship model as a tool for conceptual design-entities attributes and relationships. ER diagrams; Converting and ER model into relational Schema. Functional dependencies and Normalization,  anomalies,  Normal  forms ( 1NF, 2NF, 3NF BCNF).

Storage Structure and Indexing
Storage classification, disk arrays and RAID, Issues in physical design; Concepts of indexes, File organization for relational tables, Introduction to Distributed Database. Case studies of Commercial Database design, Transaction Processing.

Query Processing and Protecting the Database
Parsing, translation, optimization, evaluation and overview of Query Processing, Database security principles.    

Recommended Books

Text Books

1. Introduction to Database Systems- Korth

2. Database Management Systems - Raghu Ramakrishnan and Johannes Gehrke

Reference Books

1. Introduction to Database Systems- B.C. Desai

2. Fundamental of Database Systems- Elmasari, Navathe

3. Database Management Systems by Jerry Post

Lab Guidelines

Before Mid Semester
Set of programming assignments to practice SQL query on RDBMS.
Set of Assignments on ER modeling.
Web Development using PHP/ASP/JSP/Servlet/.NET etc using DBMS at backend.

After Mid Semester
A project in a group of 3 to 4 students to implement a management information  system based on the tools and technology learned before mid semester.