| 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 |
One thought on “GGSIPU (MS247) Database Management Systems”