Database Management System

In this page Database Management System we give the syllabus for BCA II year semester three with related point and their simple notes with diagram and related examples. 

Database Management System:

Unit 1: Introduction of DBMS

Introduction to Databases: Definition of Data, Database, and DBMS

Applications of DBMS, Advantages and Disadvantages of DBMS

Roles of Database Users and Administrators

Data Models: Introduction to Data Models, Types of Data Models: Hierarchical, Network, Relational, Object-oriented

Importance of Data Models in DBMS

Unit 2: 

Entity-Relationship (ER) Model, Entities and Entity Sets, Attributes and Relationships

ER Diagrams

Key Constraints and Weak Entity Sets

Introduction to the Relational Model and Relational Schema

Operations: Selection, Projection, Set Operations, Join Operations, Division, Tuple and Domain Relational Calculus

Unit 3: Normalization and Database Design:

Functional Dependencies

Concept of normalization, advantages, First NF, Second NF, Third NF and BCNF. examples of normalizations

Case Studies:

Library System

Sales System

Hospital System

Database Design:

Keys: Primary Key, Candidate Key, Super Key, Foreign Key, Unique Key

Unit 4: DBMS using MS access

Introduction and features

Tables, DDL DML and DQL queries using wizards

Join tables and queries using wizard

Relationships, Macros

Forms, Reports, Module

Join Now: Data Warehousing and Data Mining