CS315: Lecture Material

You may also refer to the very nice set of slides developed by Prof. Arnab Bhattacharya for his past offering of the course [2023 link]

SNo.	Title	Slide Link	Auxiliary Material	Comments
1	Introduction	[PPTX]	[XLSX] [CSV]	Hospital Data courtesy the Ministry of Health and Family Welfare Government of India [External Source]
2.	SQL		[IPYNB]	SQLite access via Python
3.	Indexing	[External PDF]
4.	The Relational Model	[External PDF] [External PDF]
5.	Query Processing	[External PDF]	[External PPTX] [External PDF]	The main slide deck is from the reference [ElNa]. The first auxiliary link is from the reference [SKS] which gives a more detailed treatment of materialized and pipelined processing. The second auxiliary link is to Prof. Bhattacharya's slides which give some good cost calculation examples.
6.	Query Optimization	[External PPTX]		There is a typographical error on slide 17
7.	ER Diagrams	[External PPTX]	[External Video Link]	The examples given on slides 27, 29, 30 are not realistic and merely show how various cardinality constraints are expressed in ER diagrams
8.	Normalization Theory	[External PDF]		[GMUW] Chapter 3 is a good resource for this topic
9.	Transaction Processing	[External PPTX] [External PPTX]