MBA DBMS Syllabus

[pooja]

Welcome to MBA Forum. This is MBA dbms syllabus discussion page. Here you can discuss about MBA dbms syllabus in details. Please ask your question about MBA dbms syllabus 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.

Hi buddy here I am looking for Sikkim Manipal University Distance Education MBA DBMS paper syllabus so will you plz provide me same here ??

[pooja]

As you want here I am giving below Sikkim Manipal University Distance Education MBA DBMS paper syllabus, so on your demand I am providing same :

Sikkim Manipal University Distance Education MBA DBMS paper syllabus
Course Contents



Unit 1

DBMS [Database Management System]: Introduction, Database Environment, Working of a Simple Centralized Database System, Tradition al File Systems vs. Modern Database Management Systems, Properties of Database, Types of Database Users, Advantages of using DBMS, Applications of traditional Database



Unit 2

Database Core Concepts and Applications: Introduction, Data Model, Schemas and Instances, three schema architecture, Languages and Interfaces, DBMS Components, Classification of Database Management Systems



Unit 3

Record Storage and Primary File Organization: Introduction, Memory Hierarchy, Secondary Storage Devices, Buffering of Blocks, Placing File Records on Disk, Operation on Files, Files of Unordered Records (Heap Files), Files of Ordered Records, Hashing Techniques



Unit 4

Index Structures of Files: Introduction , Primary index, Clustering Index, Multilevel indexes, B+Tree Index Files, B-tree



Unit 5

Entity-Relationship Model: Introduction, Conceptual Data model for Database Design, ER Model Concept with an example:, Components of an ER Model, Relationships, Roles and Structural Constraints, Constraints on Relationship Types



Unit 6

Relational Algebra: Introduction, Relational Model Constraints, Update Operation on Relations, The Relational Algebra



Unit 7

Relational Calculus: Introduction, Tuple Relational Calculus, Domain Relational Calculas



Unit 8

SQL: Introduction, SQL, Multi table Queries, Nested Queries or Sub queries, Multiple Row Nested Queries, Data Manipulation Language, The Create Table Statement



Unit 9

Functional Dependencies and Normalization For Relational Databases: Introduction, Information Design Guide Lines for Relational DB, Levels of Relation Schema, Normal forms Based on Primary Keys, Boyce Codd Normal Form (BCNF), Fourth Normal Form (4NF), Normalization using Join Dependencies



Unit 10

Transaction Processing: Introduction, Transaction Processing Concepts, Transactions in a multiuser system, Desirable Properties of Transactions



Unit 11

Concurrency Control Techniques: Introduction, Types of Locks: Locking Technique for Concurrency Control, the Two Phase Locking Protocol



Unit 12

Recovery Techniques: Introduction, Recovery Process, Deferred Update, Immediate Update



Unit 13

Distributed Databases: Introduction to Distributed DBMS Concepts, Client-Server Model, Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design



Unit 14

Object-Relational Databases: Introduction, Basics of Object Oriented Design (OOD), Characteristics- Advantages-Object oriented development-Objects and Object classes-Object Oriented data Model, Object oriented databases, Object Relational Database Management Systems



Unit 15

Security and integrity:Introduction, Security and Integrity Violations, Authorization, Granting of Privileges, Security Specification in SQL