Skip to content
Advertisements

GGSIPU (MBA) DATABASE MANAGEMENT SYSTEMS – 3RD SEMESTER

GGSIPU

  UNIT 1  
1 Purpose, Advantages and Disadvantages of DBMS VIEW
2 Data Models VIEW
3 Schemas and Instances VIEW
4 DBMS Architecture VIEW
5 Data Independence VIEW
  Types of DBMS  
6 Hierarchical VIEW
7 Network VIEW
8 Relational VIEW
9 Object- Oriented VIEW
10 Object Relational VIEW
  UNIT 2 ER-Model  
1 Concepts, Design Issues VIEW
2 Mapping Constraints VIEW
3 E-R Diagram VIEW
4 Design of an ER Database Schema VIEW
5 Reduction of E-R Schema to Tables VIEW
  SQL  
6 Background, Basic Structure VIEW
7 Set Operations VIEW
8 Aggregate functions VIEW
9 Null Functions VIEW
10 Derived Relations VIEW
  UNIT 3 Oracle  
1 Basic Architecture, Data Definition VIEW
2 Data Manipulation VIEW
  PL/SQL  
3 Introduction VIEW
4 Conditional, Logical, Loops VIEW
5 Go To Statements VIEW
6 Exceptional Handling VIEW
7 Triggers VIEW
8 Procedures VIEW
9 Functions VIEW
10 Cursor VIEW
11 LOB’s VIEW
  UNIT 4 Structure of Relational Database  
1 Relational Algebra VIEW
2 Functional Dependencies VIEW
3 Normal Forms NF1 VIEW
4 Normal Forms NF2 VIEW
5 Normal Forms NF3 VIEW
6 BCNF VIEW
7 Multivalued Dependencies and forth normal Form VIEW
8 Joint Dependencies and fifth Normal form VIEW
9 Concurrency, ACID Properties of Transaction VIEW
10 Locks, Deadlock Condition VIEW
11 Two-Phase Locking Protocol VIEW

 

Advertisements

1 Comment »

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: