Year 2: Third Semester (Compulsory Modules)

         Module              : BIM 202: Introduction of Database Management System (DBMS)

         Programme       : B.Com

Prerequisite    : None

General Objectives

• To develop skills on decision making based on information that is obtained through data processing. The students of commerce are expected to explain on how best the business data can be stored, maintained and retrieved for decision making. Therefore, this module is designed to cover concepts and principles of database system, its application in business world.

Learning Outcomes

Upon successful completion of the module, student should be to:

• Manage huge amount of data of a business organization through simplification of complex data, store, maintain and retrieve information using Database Software viz. ORACLE, MYSQL etc.  

CONTENT

Unit- I: Basic Concepts                                                                                             (10 Hours)

Definition Database System, Operational data, Why Database, Data independence, Database Architecture, Distributed Database. 

Unit – II: Data Structures and Corresponding operations  (8 Hours)

Introduction and Definition Data Structures, general Indexing Techniques, Relational Approach, hierarchical Approach, Network Approach, Higher-Level Operators.

Unit –III: Relations                                                                                                   (2 Hours)

Introduction, Tuples, Relation Types, Relation Values, Relation Variables. Creation of Table, Primary Key , Reference Key,  Simple Queries Like Select, Insert, Update, Delete, Modify etc.

Unit – IV: Normalization                                                                                          (10 Hours)

Introduction, Nonloss , Decomposition and Functional Dependencies, First, Second , and Third Normal Forms. Dependency Preservation, Boyce/  Codd Normal Form.

Unit- V:  The E/R Model, E/R Diagrams, Database Design with the E/R model.    (10 Hours)

Teaching Strategies

• Lecture
• Practical sessions for online demonstration of manipulation of data in the Data base

Assessment

·         Assignments:                     25%

·         Mid-term Exam                 25%

·         Final Exam                        50%

Total                                 100%

Essential Texts

1. Data Management Data bases and Organizations(1998)- Richand T.Watson  Willey Publication
2. Introduction to Data base System(2008)-C.J.Date, A. Kannan, S.Sominathan Pearson Publication.

References

1.  Introduction to Data base System (1998)– C.J.Date, Narosa Publications
2. Database system Design implementation and management-(1993) Peter Rob, Carlos cornel .Words worth Publicatios