MBA DBMS Syllabus

Hello sir, I am Mohan. I am from Delhi. I want you to help me by giving me some information about the syllabus of the Database Management System (DBMS) subject of Master of Business Administration (MBA) program of Guru Gobind Singh Indraprastha University (GGSIPU). Can you help me?

[Rajkumar Agarwal]

As you have asked about the syllabus of the Database Management System (DBMS) subject of Master of Business Administration (MBA) program of Guru Gobind Singh Indraprastha University (GGSIPU), I am giving you information about it, check below for the details

Database Management Systems
Course Code: MS 239 L-2 Credits: 2

Course Contents:

1. Purpose, Advantages and Disadvantages of DBMS, Data Models, Schemas and Instances, DBMS Architecture and Data Independence, Types of DBMS – Hierarchical, Network, Relational, Object-oriented and Object relational. (04 Hours)

2. ER-Model – Basic concepts, Design Issues, Mapping Constraints, Keys, E-R Diagram, Design of an E-R Database Schema, Reduction of E-R Schema to Tables.
SQL: Background, Basic Structure, Set Operations, Aggregate Functions, Null Values, Nested Sub Queries, Derived Relations, Views, Modification of Database, Joined Relations, Data Definition Language, Domain Constraints, Referential Integrity. (10 Hours)

3. Oracle: Basic Architecture, Data Definition, Data Manipulation (LIKE Operator, String Commands, Numeric Function, Date Function, Translate and Decode Function), Introduction to PL/SQL (Conditional, Logic, Loops, Go to Statements, Exceptional Handling, Triggers, Procedures, Functions, Cursor, LOB’s). (10 Hours)

4. Structure of Relational Databases, Relational Algebra, Functional Dependencies, Normal forms NF1, NF2, NF3 and BCNF, Multivalued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form. Transaction, Concurrency: ACID Properties, Transaction State, Locks, Deadlock Condition, Two- Phase Locking protocol.