Database Management System

Course Code: MIS 322

Credit Hour: 3

Course Group: Specialization Course: Management Information System

---

Overview: Definition & types of DBMS, Data Model; ER & rational model, FD constraints, assertions, triggers. Database design; logical database design, physical database design, data storage device and data formats.

Basic Database Concepts: Conventional file processing; three level architecture, Communication with database systems, database management systems. Distributed database, database machines, database administration; The hierarchical, network and relational database models and their languages, Data description and data manipulation languages. Structured query language (SQL), Storage representations and access methods.

Database Design: Functional dependencies decomposition to normal forms, the entity relationship model.

Database Components: Security, Data dictionary, transactions and recovery, concurrent processing.

Database Implementation: Physical representation, query, optimization, projects using on RDMS; Logic for relational database; First order logic, relational calculus and algebra.

 Intelligent Database: Deductive database with natural language interface, Specific database systems: FOXPRO / ORACL.

---

Recommended Books:

Abraham Silberschatz, Database System Concepts

Raghu Ramakrishnan, Database Management System

Carlo Zaniolo, Advanced Database Systems