| Name | Download | Download Size |
|---|---|---|
| Lecture Note | Download as zip file | 9.5M |
| Module Name | Download |
|---|---|
| noc20_cs03_assigment_1 | noc20_cs03_assigment_1 |
| noc20_cs03_assigment_10 | noc20_cs03_assigment_10 |
| noc20_cs03_assigment_11 | noc20_cs03_assigment_11 |
| noc20_cs03_assigment_12 | noc20_cs03_assigment_12 |
| noc20_cs03_assigment_13 | noc20_cs03_assigment_13 |
| noc20_cs03_assigment_2 | noc20_cs03_assigment_2 |
| noc20_cs03_assigment_3 | noc20_cs03_assigment_3 |
| noc20_cs03_assigment_4 | noc20_cs03_assigment_4 |
| noc20_cs03_assigment_5 | noc20_cs03_assigment_5 |
| noc20_cs03_assigment_6 | noc20_cs03_assigment_6 |
| noc20_cs03_assigment_7 | noc20_cs03_assigment_7 |
| noc20_cs03_assigment_8 | noc20_cs03_assigment_8 |
| noc20_cs03_assigment_9 | noc20_cs03_assigment_9 |
| Sl.No | Chapter Name | MP4 Download |
|---|---|---|
| 1 | Introduction | Download |
| 2 | Database Architecture | Download |
| 3 | RDBMS Architecture | Download |
| 4 | Introduction to ER Model | Download |
| 5 | Entities and Relationships | Download |
| 6 | Modelling Weak Entities and Design Choices | Download |
| 7 | Relational Data Model and Notion of Keys | Download |
| 8 | Introduction to Relational Algebra | Download |
| 9 | Operators in Relational Model | Download |
| 10 | Uses of Renaming, Join and Division in Relation Algebra | Download |
| 11 | Example Queries in Relation Model and Outer Join Operation | Download |
| 12 | Convert ER-Model to a Relational Model | Download |
| 13 | Introduction to tuple relational calculus | Download |
| 14 | Example TRC queries | Download |
| 15 | Data definition using SQL | Download |
| 16 | Basic SQL query block and subqueries | Download |
| 17 | Correlated subqueries | Download |
| 18 | Aggregate functions | Download |
| 19 | Views | Download |
| 20 | Programmatic access of SQL | Download |
| 21 | Normal forms - Introduction | Download |
| 22 | Deriving new functional dependencies | Download |
| 23 | Proving soundness and completeness of Armstrong's Axioms | Download |
| 24 | Normal forms - 2 NF, 3NF, BCNF | Download |
| 25 | Properties of decompositions | Download |
| 26 | Normal forms - 4NF, 5NF | Download |
| 27 | Introduction to file orgranization | Download |
| 28 | File orgranization methods | Download |
| 29 | Dynamic File orgranization using Hashing | Download |
| 30 | Index structures | Download |
| 31 | B+ trees on Disks | Download |
| 32 | Performance and Reliability of Multiple Disks | Download |
| 33 | Relational Query Evaluation | Download |
| 34 | Join operator processing algorithms | Download |
| 35 | Query optimization | Download |
| 36 | ACID properties and operations in transactions | Download |
| 37 | Schdeules | Download |
| 38 | Concurrency control using Locks | Download |
| 39 | Recovery using undo logging method | Download |
| 40 | Recovery using Redo and Undo-Redo logging methods | Download |
| 41 | Recoverable schdeules and transaction isolation levels | Download |
| Sl.No | Chapter Name | English |
|---|---|---|
| 1 | Introduction | Download To be verified |
| 2 | Database Architecture | Download To be verified |
| 3 | RDBMS Architecture | Download To be verified |
| 4 | Introduction to ER Model | Download To be verified |
| 5 | Entities and Relationships | Download To be verified |
| 6 | Modelling Weak Entities and Design Choices | Download To be verified |
| 7 | Relational Data Model and Notion of Keys | Download To be verified |
| 8 | Introduction to Relational Algebra | Download To be verified |
| 9 | Operators in Relational Model | Download To be verified |
| 10 | Uses of Renaming, Join and Division in Relation Algebra | Download To be verified |
| 11 | Example Queries in Relation Model and Outer Join Operation | Download To be verified |
| 12 | Convert ER-Model to a Relational Model | Download To be verified |
| 13 | Introduction to tuple relational calculus | Download To be verified |
| 14 | Example TRC queries | Download To be verified |
| 15 | Data definition using SQL | Download To be verified |
| 16 | Basic SQL query block and subqueries | Download To be verified |
| 17 | Correlated subqueries | Download To be verified |
| 18 | Aggregate functions | Download To be verified |
| 19 | Views | Download To be verified |
| 20 | Programmatic access of SQL | Download To be verified |
| 21 | Normal forms - Introduction | Download To be verified |
| 22 | Deriving new functional dependencies | Download To be verified |
| 23 | Proving soundness and completeness of Armstrong's Axioms | Download To be verified |
| 24 | Normal forms - 2 NF, 3NF, BCNF | Download To be verified |
| 25 | Properties of decompositions | Download To be verified |
| 26 | Normal forms - 4NF, 5NF | Download To be verified |
| 27 | Introduction to file orgranization | Download To be verified |
| 28 | File orgranization methods | Download To be verified |
| 29 | Dynamic File orgranization using Hashing | Download To be verified |
| 30 | Index structures | Download To be verified |
| 31 | B+ trees on Disks | Download To be verified |
| 32 | Performance and Reliability of Multiple Disks | Download To be verified |
| 33 | Relational Query Evaluation | Download To be verified |
| 34 | Join operator processing algorithms | Download To be verified |
| 35 | Query optimization | Download To be verified |
| 36 | ACID properties and operations in transactions | Download To be verified |
| 37 | Schdeules | Download To be verified |
| 38 | Concurrency control using Locks | Download To be verified |
| 39 | Recovery using undo logging method | Download To be verified |
| 40 | Recovery using Redo and Undo-Redo logging methods | Download To be verified |
| 41 | Recoverable schdeules and transaction isolation levels | Download To be verified |
| Sl.No | Language | Book link |
|---|---|---|
| 1 | English | Not Available |
| 2 | Bengali | Not Available |
| 3 | Gujarati | Not Available |
| 4 | Hindi | Not Available |
| 5 | Kannada | Not Available |
| 6 | Malayalam | Not Available |
| 7 | Marathi | Not Available |
| 8 | Tamil | Not Available |
| 9 | Telugu | Not Available |