Last updated on December 7th, 2019 at 05:58 pm
| |
UNIT 1 [Book Link] |
|
| 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 [Book Link] |
|
| 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 [Book Link] |
|
| 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 [Book Link] |
|
| 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 |
Like this:
Like Loading...
Related
One thought on “GGSIPU (MS247) Database Management Systems”