DBMS Notes Mumbai University
 

I am a student studying in Mumbai University under the graduation course and my specialization is Information Technology. I had my exams in few days and for that I needed DBMS notes . can you provide me with that?

Re: DBMS Notes Mumbai University
 

Can you provide me the notes/syllabus of DBMS (Database Management Systems) under FYB Sc. IT (Sem.-II) - offered by University of Mumbai?

Re: DBMS Notes Mumbai University
 

The notes/syllabus of DBMS (Database Management Systems) under FYB Sc. IT (Sem.-II) - offered by University of Mumbai is as follows:

DATABASE MANAGEMENT SYSTEMS
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 Model: overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codds 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.

Books:
A Silberschatz, H Korth, S Sudarshan, Database System and Concepts, fifth Edition McGraw-Hill, Rob, Coronel, Database Systems, Seventh Edition, Cengage Learning


Syllabus DBMS under FYB Sc. IT (Sem.-II) University of Mumbai

https://management.ind.in/img/w/DBMS...iversity-1.jpg
https://management.ind.in/img/w/DBMS...iversity-2.jpg
https://management.ind.in/img/w/DBMS...iversity-3.jpg
https://management.ind.in/img/w/DBMS...iversity-4.jpg

For more details here i am giving link of Syllabus DBMS under FYB Sc. IT (Sem.-II) University of Mumbai
archive.mu.ac.in/myweb_test/syllFybscit/DBMS.pdf