#1
11th March 2016, 05:03 PM
| |||
| |||
DBMS for MBA PPT
Hello sir I am here as I want to get the syllabus of the MBA - Database Management Systems of Sikkim Manipal University Distance Education??
|
#2
11th March 2016, 05:03 PM
| |||
| |||
Re: DBMS for MBA PPT
Sikkim Manipal University is a co-educational public-private funded university located in Gangtok, Sikkim, India. It was established in 1995 and is the first government-private initiative in the region Here as per your demand I am providing you syllabus of the MBA - Database Management Systems of Sikkim Manipal University Distance Education 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 Contact Details: Sikkim Manipal University - Directorate of Distance Education 5th Mile, Tadong, Gangtok, Sikkim – 737102 | |