Database Management System [BCA-402] Syllabus BCA 3rd-IV Sem Syllabus for DAVV Indore Affiliated Institutions

 DEVI AHILYA VISHWAVIDYALAYA (DAVV), INDORE

Bachelor Of Computer Applications (BCA) (Full-Time) 
Fourth-4th-IV Semester Curriculum/ Syllabus 2011-12 Academic Year Onwards

Database Management System – Syllabus 

 

Database Management System [BCA-402] Syllabus /Course contents

Max.Marks:50

Min.Marks:17

UNIT-I

Introduction: purpose of DBMS, view of data, data models: physical model, logical model, conceptual model, hierarchical model,  network model. Object oriented model. database language, Database administrator, database user, overall system structure.

UNIT-II

Entity relationship model: basic concepts, mapping constraints, keys, E-R diagram, weak, entity features, design of an E-R database schema, reduction of E-R schema to table.

UNIT-III

Structured Query Language(SQL):basic structure, set operations, aggregate functions, null values, nested sub queries, data definition language(DDL), data manipulation language(DML), data control language(DCL), transaction control language(TCL),QBE,QUEL.

UNIT-IV

Relational database design: pitfalls in relational database design, decomposition, normalization using functional dependencies, normalization using multivalve dependencies, normalization using joined dependencies. Integrity constraints: domain constraints, entity integrity constraints, referential integrity constraints, assertion, triggers, functions, procedures, cursors.

UNIT-V

Concept of RDBMS, characteristics of RDBMS, Codd’s 12 rules, introduction to oracle tools, security.

Text Book

1. Database system concepts by A.silberschatz, H.F.Korth, and S.Sudershan 5th Edition McGraw Hill

Reference Books

1. An introduction to database management system by Vipin Desai
2. Modern database system by Mcfadden

Objective: To introduce the concept of database management system

Examination: The examination will be of 50 marks. The question will contain questions equally distributed in all units. The balance of the paper will be maintained by including appropriate (numerical/objectives/conceptual/analytical/theoretical) combination of subsection in each question.