Relational database management BCA 3rd semester
UNIT - I
Overview of database management
Overview of Database Management: Introduction, Data Processing versus Data Management, Data Models: Network Model, Relational Model, Hierarchical Model, Instance and schema, View of Database system, File Oriented Approach vs Database Oriented Approach, Data Independence, DBMS Architecture, Database Administration Roles, Database languages: DDL, DML, DCL, TCL, Different kinds of DBMS users, Introduction to Data Dictionary
UNIT - II
Database design and ER model
Database Design and E-R Model: Introduction, Entity. Strong and weak entities, Relationship, Cardinality, Attributes, Concept of keys: Super key, Candidate key, Primary key, Alternate key, Foreign key, ER Diagram, Constraints in Database, Codd's Rules, Extended ER features: Generalization, Specialization and Aggregation, Participation, Converting an E-R model into relational Schema
UNIT - III
Regional database design and operations
Relational Database Design and Operations: Introduction, Dependencies: Functional dependencies, Multivalued Dependencies, Join dependencies, Database anomalies, Decomposition, Normalization: Normal forms INF, 2NF, 3NF, BCNF, 4NF, SNF, De-normalization. Relational Algebra: Select operation, Project operation, Union operation, Cartesian Product operation, Intersection operation, Join operation, Different types of joins (Inner join, Outer join, Self join).
UNIT - IV
Transactions
Transaction: Introduction, Desirable properties of transaction (ACID), Concurrency control techniques, Serializability.