Go Back   2022-2023 StudyChaCha > StudyChaCha Discussion Forum > General Topics

  #1  
Old May 27th, 2017, 12:00 PM
Unregistered
Guest
 
Default DBMS SMU

I am pursuing MBA Distance Learning Degree Program of Sikkim Manipal University (SMU). I need detailed syllabus of DBMS Subject of MBA Program. So do you know from where I can download detailed syllabus of DBMS Subject of MBA Program offered by Sikkim Manipal University (SMU)?
Reply With Quote
Other Discussions related to this topic
Thread
VTU DBMS Notes PDF
DBMS VTU Syllabus
DBMS SBI Questions
WBUT DBMS Book
IIT Bombay DBMS Workshop
DBMS RGPV
WBUT DBMS Syllabus
VTU DBMS Lab Programs
RGPV DBMS Syllabus
DBMS Syllabus For MBA
DBMS University of Wolverhampton
DBMS Notes For MBA PDF
IGNOU DBMS Books
DBMS IIT Madras
DBMS BITS Pilani
VTU DBMS Notes Doc
DBMS School
MBA in DBMS
VTU Programs DBMS
DBMS notes MBA PDF DBMS notes MBA students






  #2  
Old May 27th, 2017, 12:23 PM
Super Moderator
 
Join Date: May 2011
Default Re: DBMS SMU

As you are looking for detailed syllabus of DBMS Subject of MBA Distance Education Program offered by Sikkim Manipal University (SMU), so here I am providing following syllabus:

Sikkim Manipal University (SMU) MBA – DBMS Syllabus

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
__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6. The time now is 09:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8