Database Management Systems

UNIT 1

Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management Data Models The importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction. Database Design,ER Diagram and Unified Modeling Language Database design and ER Model:overview, ERModel, Constraints, ERDiagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML

UNIT 2

Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management Data Models The importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction. Database Design,ER Diagram and Unified Modeling Language Database design and ER Model:overview, ERModel, Constraints, ERDiagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML

UNIT 3

Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management Data Models The importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction. Database Design,ER Diagram and Unified Modeling Language Database design and ER Model:overview, ERModel, Constraints, ERDiagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML

UNIT 4

Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management Data Models The importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction. Database Design,ER Diagram and Unified Modeling Language Database design and ER Model:overview, ERModel, Constraints, ERDiagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML

UNIT 5

PL-SQL: Beginning with PL / SQL,Identifiers and Keywords, Operators, Expressions, Sequences,Control Structures, Cursors and Transaction,Collections and composite data types, Procedures and Functions, Exceptions Handling,Packages,With Clause and Hierarchical Retrieval,Triggers.