Assignment No 5 PL SQL Create Procedure for Student Categorization

 

Database Transaction Management: Introduction, ACID, Schedule

 Introduction to Database Transaction, Transaction states, ACID properties, Concept of Schedule, Serial Schedule 

Normalization: Algorithms for Decomposition, 2NF, 3NF, BCNF

Database Design: Features of Good Relational Database Design.

Relational Integrity: Domain, Referential Integrities, Enterprise Constraints.

 

Unit no 3 Relational Database Design: Relational Model: Basic concepts, Attributes and Domains, CODD's Rules.