Database Systems & Data Mining (CS 501)

Link to Main Page


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:

  1. Abraham Silberschatz, Henry Korth, and S. Sudarshan, Database System Concepts, McGraw -Hill.
    Database System Concepts – 7th edition (
  2. Raghu Ramakrishnan, Database Management Systems, WCB/McGraw -Hill.
  3. Jiawei Han, Micheline Kamber and Jian Pei, Data Mining Concepts and Techniques, Morgan Kaufmann


(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 classTopic CoveredRemarks
1Class 1: 3 Aug 2023
2Class 2: 4 Aug 2023
3Class 3: 8 Aug 2023
4Class 4: 10 Aug 2023
5Class 5: 17 Aug 2023
6Class 6: 22 Aug 2023
7Class 7: 24 Aug 2023
8Class 8: 25 Aug 2023
9Class 9: 29 Aug 2023
10Class 10: 31 Aug 2023

Topic wise Learning Material:


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.