DBMS an overview, Advantages of DBMS, Network, Hierarchical and Relational Model, Levels of abstraction, Data Independence, Data Models, Instances and schemes, Data independence Structures of a DBMS, Application Programmers & Data Base administrators – their function, Transaction Management Entity Relationship Model: Entities, Attributes and Entity Sets, Relation and Relationships sets, mapping and participation constraints, Aggregation, Specialization and Generalization, Features of ER Model.
UNIT-II Relational Model: Introduction to relational model, Integrity constraints over relations, Enforcing Data Integrity, Integrity Constraints, Relational Data, Logical Data Base Design, Reduction of E-R Diagrams to relations, Introduction to views, Querying Relational Algebra and Relational Calculus, Operations on Relational Algebra, Operations on Relational Calculus, Tuple Relational Calculus, Domain Relational Calculus
UNIT-III Database Design, Data Redundancy, Introduction to Schema Refinement, Functional Dependencies, Normal Forms-First , Second, Third, Boyce code, Fourth and Multivalued Dependencies Structured Query
Language:Basic SQL Queries, Nested Queries, Aggregate operator, Null Values, implementation of Various Relational Algebra operations, Embedded SQL UNIT-IV
Transaction management: ACID Properties, Transaction states, Concurrency control: Concurrency Control –Overview, Concurrency control problems, Locks, Locking Protocols, Deadlocks, Serializability, Recovery System: Types of Failures, Recovery Techniques, ARIES