2023 2024 Student Forum > Management Forum > Main Forum

 
  #2  
7th July 2015, 04:14 PM
Super Moderator
 
Join Date: Apr 2013
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;
Attached Files
File Type: doc Mumbai University Database Management Systems syllabus.doc (820.0 KB, 529 views)


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 01:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4