munotes®
Sign in
Home / Syllabus / Master of Commerce (M.Com.) / E Commerce / Semester 1 / Database Management System

Master of Commerce (M.Com.) Database Management System Syllabus - Mumbai University

Database Management System Syllabus.pdf
Mandatory course · Semester 1 · M.Com. E-Commerce · 4 credits · 100 marks

Loading syllabus...

Syllabus for Database Management System

Mandatory course · Semester 1 · M.Com. E-Commerce · 4 credits · 100 marks

Module I: (2CREDITS)

  • Unit 1 Introduction to Database Management System (DBMS) A. Concept of Database, Database Management System:Concept, features, Importance &Evolution, Environment,Classifications,AdvantagesandIssuesofusingDBMS.
  • B. Three Level of Architecture, Implications of the Database Approach, Database
  • Languages and Interfaces.
  • Unit 2 Relational Database Design A. Codd’s rule, Entity relationship model, Entity Types, Attributes, Keys, Roles
  • and Structural Constraints, Constraints on Relationship Types, Basic
  • Relational Algebra Operations ,Additional Relational Operations.
  • B. Roles and functional Dependencies, Normalization, Mapping the ER model to Relational DB.

Module II: (2CREDITS)

  • Unit 3 Transaction Management and RecoverySystem
  • A. Transaction Management: Transaction Concept, Transaction State, Implementation of Atomicity and Durability.
  • B. Recovery System: Failure Classification, Storage Structure, Recovery and Atomicity- Log - Based Recovery - Recovery with Concurrent Transactions.
  • Unit 4 SQLConcept
  • A. Basics of SQL: Form of Basic SQLQuery-ExamplesofBasicSQLQueries, Multi table Queries.
  • B. Introduction to Nested Queries, Correlated Nested Queries, NULL values - Comparison using Null values - Disallowing NULL values, ComplexIntegrityConstraints inSQLTriggersandActive.

References

  • 1 Database System Concepts" by Abraham Silberschatz, Henry F. North, and S. Sudarshan.
  • 2 "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.
  • 3 "SQL Programming and Database Design Using Microsoft SQL Server" by KalmanToth.
  • 4 "SQL Cookbook" by Anthony Molinaro.
  • 5 "Learning SQL" by Alan Beaulieu.
  • 6 "Head First SQL: Your Brain on SQL -- A Learner's Guide" by Lynn Beighley.

Reproduced from the University of Mumbai syllabus for M.Com. (E-Commerce) under NEP 2020, in force from the academic year 2023-24. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its specialisation. Open a document here if you want the whole thing rather than a single subject.

PDF M.Com. Business Management Semester 1 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Management Semester 2 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Management Semester 3 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Management Semester 4 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Banking and Finance Semester 1 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Banking and Finance Semester 2 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Banking and Finance Semester 3 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Banking and Finance Semester 4 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Advance Accountancy Semester 1 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Advance Accountancy Semester 2 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Advance Accountancy Semester 3 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Advance Accountancy Semester 4 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. E-Commerce Semester 1 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. E-Commerce Semester 2 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. E-Commerce Semester 3 and Semester 4 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Economics Semester 1 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Economics Semester 2 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Economics Semester 3 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF M.Com. Business Economics Semester 4 Syllabus NEP 2020 syllabus, in force from 2023-24 Read full PDF Read
PDF MCom Semester III And IV (2017 18) Earlier CBCS syllabus, still set for ATKT and distance candidates Read full PDF Read
PDF MCom Semester I And II (2016 17) Earlier CBCS syllabus, still set for ATKT and distance candidates Read full PDF Read
Report or request
Done!