BCA-202: Database Management System - Notes
UNIT-I: Introduction to DBMS
- Data: Raw facts and figures.
- Database: Organized collection of data.
- DBMS: Software to manage databases.
- Advantages: Redundancy control, data consistency, easy access, security, backup.
- Three-Schema Architecture: Internal, Conceptual, External.
- Data Independence: Logical and Physical.
- DBMS Languages: DDL, DML, DCL.
UNIT-II: Data Modeling and Indexing
- ER Model: Entity, Attributes, Key, Relationships.
- Relationship Types: 1-1, 1-M, M-M.
- Weak Entity: Depends on another entity.
- Indexing: Primary, Secondary, Clustering.
- Hashing: Used for fast data retrieval.
UNIT-III: Relational Model & Normalization
- Relational Model: Tables (rows and columns).
- Constraints: Domain, Entity, Referential.
- Relational Algebra: Select, Project, Join.
- Functional Dependency: A -> B.
- Normal Forms: 1NF, 2NF, 3NF, BCNF.
UNIT-IV: SQL and Transactions
- SQL Types: DDL, DML, DQL, DCL.
UNIT-I: Introduction to DBMS
- Data: Raw facts and figures.
- Database: Organized collection of data.
- DBMS: Software to manage databases.
- Advantages: Redundancy control, data consistency, easy access, security, backup.
- Three-Schema Architecture: Internal, Conceptual, External.
- Data Independence: Logical and Physical.
- DBMS Languages: DDL, DML, DCL.
UNIT-II: Data Modeling and Indexing
- ER Model: Entity, Attributes, Key, Relationships.
- Relationship Types: 1-1, 1-M, M-M.
- Weak Entity: Depends on another entity.
- Indexing: Primary, Secondary, Clustering.
- Hashing: Used for fast data retrieval.
UNIT-III: Relational Model & Normalization
- Relational Model: Tables (rows and columns).
- Constraints: Domain, Entity, Referential.
- Relational Algebra: Select, Project, Join.
- Functional Dependency: A -> B.
- Normal Forms: 1NF, 2NF, 3NF, BCNF.
UNIT-IV: SQL and Transactions
- SQL Types: DDL, DML, DQL, DCL.
