|
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
12
II Relational database model:
Logical view of data, keys, integrity rules, Relational Database
design: features of good relational database design, atomic domain
and Normalization (1NF, 2NF, 3NF, BCNF).
Relational Algebra and Calculus
Relational algebra: introduction, Selection and projection, set
operations, renaming,Joins, Division, syntax, semantics. Operators,
grouping and ungrouping,relationalcomparison.
Calculus: Tuple relational calculus, Domain relational Calculus,
calculus vsalgebra,computational capabilities
12
III Constraints, Views and SQL
Constraints, types of constrains, Integrity constraints, Views:
Introduction to views, data independence, security, updates on
views,comparison between tables and views SQL: data definition,
aggregate function, Null Values, nested sub queries, Joined relations.
Triggers.
12
IV Transaction management and Concurrency
Control Transaction management: ACID properties, serializability and
concurrency control, Lock based concurrency control (2PL,
Deadlocks),Time stamping methods, optimistic methods, database
recovery management.
12
V 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.