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: Some More