DBMS Book for MBA

[pooja]

Welcome to MBA Forum. This is Dbms book for MBA discussion page. Here you can discuss about Dbms book for MBA in details. Please ask your question about Dbms book for MBA in the quick reply box mention below. Our member will try to answer your question about it as soon as possible. Furthermore, please provide your full details with your question. Your Name, email address, phone numbers, also you education / University in which you are studying. If your question is related to any institution / University / Business School/ Online MBA / Distance MBA or Jobs related to MBA, then mention that in your question as well.

Can you provide me the syllabus of DBMS (Database Management Systems) under B.Sc. Information Technology Program offered by University of Mumbai?

[pawan]

The syllabus of DBMS (Database Management Systems) under B.Sc. Information Technology Program 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


Syllabus DBMS under B.Sc. Information Technology Program University of Mumbai






Syllabus DBMS under B.Sc. Information Technology Program University of Mumbai
archive.mu.ac.in/myweb_test/syllFybscit/DBMS.pdf