III BCA V SEM SYLLABUS
PAPER - I Title of the Course/ Paper –XIV DATABASE MANAGEMENT SYSTEMS Core III Year Credit: 4 Objective of the course This course introduces the basic concepts of database management systems Unit 1: Advantages and Components of a Database Management Systems – Feasibility Study – Class Diagrams – Data Types – Events – Normal Forms – Integrity – Converting Class Diagrams to Normalized Tables – Data Dictionary. Unit-2: Query Basics – Computation Using Queries – Subtotals and GROUP BY Command – Queries with Multiple Tables – Subqueries – Joins – DDL & DML – Testing Queries Unit 3: Effective Design of Forms and Reports – Form Layout – Creating Forms – Graphical Objects – Reports – Procedural Languages – Data on Forms – Programs to Retrieve and Save Data –...