Link to Main Page
Syllabus
Data models: entity-relationship, relational model. Query languages: relational algebra, relational calculus, SQL.
Theory of database design: functional dependencies;
normal forms: 1NF, 2NF, 3NF,
Boyce-Codd NF; decompositions; normalization;
Transaction management, Concurrency control; error recovery;
Need for Data Mining Techniques, Data Preprocessing, Mining Frequent Patterns, Classification, Prediction, Clustering, etc
Data Mining: Knowledge Representation Using Rules, Association and Classification Rules.
Reference Books:
- Abraham Silberschatz, Henry Korth, and S. Sudarshan, Database System Concepts, McGraw -Hill.
Database System Concepts – 7th edition (db-book.com) - Raghu Ramakrishnan, Database Management Systems, WCB/McGraw -Hill.
- Jiawei Han, Micheline Kamber and Jian Pei, Data Mining Concepts and Techniques, Morgan Kaufmann
Classes
(You may need to login into IITP LMS for some classes. Better to login in one tab and then access these resources)
| Lecture # | Link to class | Topic Covered | Remarks |
|---|---|---|---|
| 1 | Class 1: 3 Aug 2023 | ||
| 2 | Class 2: 4 Aug 2023 | ||
| 3 | Class 3: 8 Aug 2023 | ||
| 4 | Class 4: 10 Aug 2023 | ||
| 5 | Class 5: 17 Aug 2023 | ||
| 6 | Class 6: 22 Aug 2023 | ||
| 7 | Class 7: 24 Aug 2023 | ||
| 8 | Class 8: 25 Aug 2023 | ||
| 9 | Class 9: 29 Aug 2023 | ||
| 10 | Class 10: 31 Aug 2023 |
Topic wise Learning Material:
| Topic | Link | Remarks |
|---|---|---|
Link to Main Page
The links mentioned on this page does not belong to us. These are property of the owner of those links. If you have any objection, then please send us a message.