#1
7th July 2015, 08:22 AM
| |||
| |||
DBMS Mumbai University Notes
I am looking for the Database Management Systems syllabus of Mumbai University ? Will you please provide it ?
|
#2
7th July 2015, 04:14 PM
| |||
| |||
Re: DBMS Mumbai University Notes
As you are looking for the Database Management Systems syllabus of Mumbai University , here I am providing same for you . Unit – I Introduction to Databases and Transactions What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management Unit- II Data Models The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction Unit-III Database Design ,ER-Diagram and Unified Modeling Language Database design and ER Modelverview, ER-Model, Constraints, ER-Diagrams, 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). Unit- IV 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. Unit- V 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. Unit-VI 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 Mumbai University Database Management Systems syllabus For detailed syllabus , here is the attachment; |