DATABASE MANAGEMENT

DATABASE MANAGEMENT
AREA OF STUDY: CORE
BAC 353

Year: 3
Semester: 6

________________________________________
* Continuous
** Duration: 3 hours

Objective
This course aims at providing students with the fundamental knowledge of database systems in general and database management systems in particular.
Course Contents
Unit 1: Introduction T.H.5
Data and information; Definition of database systems; Characteristics of database approach and definition of database management system.
Unit 2: Database Systems, Concepts and Architecture T.H.5
Data models; DBMS architecture and data independence; Database environment; Data dictionary; E-R model; Entity types, attributes, keys and relationship types.
Unit 3: Filing and File Structure T.H.5
Storage devices; Organization of records; File organizations; The sequential file organizations; The indexed sequential file organization.
Unit 4: Relational Model T.H.6
Introduction to relational database; Relational algebra; Kinds of relation.
Unit 5: Integrity Constrains T.H.4
Security and integrity violations; Access control and authorization; Security and views; Encryption and decryption.
Unit 6: Introduction to SQL T.H.9
Set operations; Null values; Queries, view, joined relation, DDL and DML.
Unit 7: Query Processing T.H.4
Introduction to Query processing; Equivalence of expressions; Query optimization; Query decomposition; Introduction SQL.
Unit 8: Object Oriented Model T.H.3
Introduction; Design of object oriented model.
Unit 9: Applications of Database Systems in Organizations: T.H.7
Students themselves will have to study and submit the report on database systems of any one of the Nepalese originations (such as payroll, inventory, airlines reservations, online banking systems).
Suggested Readings
1. Hansen, Giary W. and Hansen, James V., Database Management and Design, New Delhi: Prentice Hall of India Pvt. Ltd.
2. Silbersphatz, Alraham etal, Database Systems Concepts, New York, McGraw Hill Company.