Top banner

Wednesday, March 7, 2012

DBMS Sem 2

Introduction to Databases and Transactions :
What is database system, purpose of database system, view of data,
relational databases, database architecture, transaction management,

Data Models : The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Database Design, ER-Diagram and Unified Modeling Language: Database design and ER Model:overview, ER-Model, Constraints, ERDiagrams, ERD Issues, weak entity sets, Codd’s rules, Relational
Schemas, Introduction to UML

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, relational comparison.
Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.

Constraints, Views and SQL: What is 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.

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.

1 comment:

  1. where can i download f.y bsc.it sem 2 book in pdf plz plz help me

    ReplyDelete