![]() ![]() 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. Operators, grouping and ungrouping, relational comparison.Ĭalculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilitiesĬonstraints, 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. Relational Algebra and Calculus: Relational algebra: introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. ![]() ![]() 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). ![]() Introduction to Databases and Transactions: What is database system, purpose of database system, view of data, relational databases, database architecture, transaction managementĭata Models: The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.ĭatabase Design, ER Diagram and Unified Modeling Language: Database design and ER Model: overview, ER Model, Constraints, ER Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML Database Management Systems Syllabus Unit ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |