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 |
All times are GMT +5. The time now is 08:18 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2