-
Semester 1
This Semester consist of 15 Credits.
5 -
Semester 2
This Semester consist of 15 Credits.
5 -
Semester 3
This Semester consist of 15 Credits.
5 -
Semester 4
This Semester consist of 15 Credits.
5 -
Semester 5
This Semester consist of 15 Credits.
5 -
Semester 6
This Semester consist of 15 Credits.
5 -
Semester 7
This Semester consist of 15 Credits.
5 -
Semester 8
This Semester consist of 15 Credits.
5
Data Base Management System
Course Title: Database Management System
Course Code: MGT 133
Area of Study: Core
Credit Hour: 3
Course 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 I: Introduction L.H. 4
1.1 Definition of database and database system
1.2 Characteristics of database approach
1.3 Database system versus Traditional file processing system
1.4 Advantages and limitations of using DBMS
Unit II: Database System Concepts and Architecture L.H.6
2.1 Data models
2.2 DBMS architecture and Data independence
2.3 Database languages
2.4 Database users and Database administrators
2.5 E-R Model: Entities, Attributes, Relationships, Keys, Cardinalities, Participation constraints, E-R
Diagram
2.6 Data dictionary
Unit III: Relational Model L.H.6
3.1 Properties of relation
PURBANCHAL UNIVERSITY, Faculty of Management
Bachelor of Business Administration
2012
39
3.2 Schemas, Tuples, Domains, and Schema diagram
3.3 Relational Algebra: Select, Project, Union, Intersection, Difference, Product, Join, Rename,
Assignment, and Division operations
Unit IV: SQL L.H. 12
4.1 Introduction to SQL, DDL, and DML
4.2 Basic structure of SQL statements
4.3 SQL Queries: DDL operations, DML operations, Null values, String operations, Aggregate functions
4.4 Joined relations, Sub-queries
4.5 Set operations
4.6 Views
4.7 Laboratory classes on SQL covering all topics
Unit V: Integrity Constraints L.H. 4
5.1 Domain constraints
5.2 Entity integrity
5.3 Referential integrity
5.4 Laboratory classes implementing all topics of this using SQL
Unit VI: Relational Database Design L.H.6
6.1 Pitfalls of Relational Model: Redundancy and Anomalies
6.2 Functional dependency
6.3 Normalization, its need and objectives
6.4 1NF, 2NF, 3NF, BCNF and 4NF
Unit VII: Database Security L.H.4
7.1 Access Control: Discretionary and Mandatory
PURBANCHAL UNIVERSITY, Faculty of Management
Bachelor of Business Administration
2012
40
7.2 Authorization and Authentication
7.3 Data encryption and decryption
Unit VIII: Transaction Management, Recovery, and Query Processing L.H. 6
8.1 Introduction to transaction, ACID properties
8.2 Introduction to concurrency control
8.3 Reasons of transaction failure, System recovery and Media recovery
8.4 Introduction to query processing, steps in query processing
Case Study: Students themselves will have to study, prepare, and submit a report on database system of any
one of the Nepalese organizations (such as Airlines Companies, Banks, Governments organizations, NGO,
INGO, Private organizations)
References:
C. J. Date, “Introduction to Database Systems”, Addison-Wesley
Abraham Silberschatz et. al., “Database System Concepts”, McGraw Hill
Ramez Elmasri & Shamkant B. Navathe, “Fundamentals of Database Systems”
Gursharan Singh, “A Guide to Oracle Developer 2000/Forms”, Khanna Book Publishing Co. P. Ltd.