CS403 Course Calendar

Course Calendar
Topic	Lecture	Resource	Page
Introduction	1	Handouts	9-16
Advantages of DBMS and its User	2	Handouts	17-30
Database Architecture	3, 4	Handouts	31-49
Detailed Diagrams and Database Design	5	Handouts	50-62
Detailed DFD Diagrams	6	Handouts	63-69
Entity-Relationship Data Model	7	Handouts	70-79
Assignment # 01
Key and its different types	8	Handouts	80-84
Relationships	9	Handouts	85-90
Cardinality and Roles in Relationships	10	Handouts	91-99
Extended Entity Relationship Diagram	11	Handouts	100-109
Practice Session of ER Data Model	12	Handouts	110-117
E-R Diagram	13	Handouts	118-123
Logical Database Design	14	Handouts	124-131
Assignment # 02
Relations Keys	15	Handouts	132-139
Cardinality Constraints	16	Handouts	140-147
Relational Algebra	17	Handouts	148-156
Joins	18	Handouts	157-163
Functional Dependancy & Normalization	19	Handouts	164-168
Quiz # 01
Normalization	20	Handouts	169-175
Normalization Summary	21	Handouts	176-182
Data Volume and Usage Analysis	22	Handouts	183-186
Mid Term Exams
Physical Records and Denormalization	23	Handouts	187-190
Partitioning, Replication and Structured Query Language (SQL)	24	Handouts	191-195
Data Types and Rules of the Format	25	Handouts	196-200
Data Definition Language (DDL)	26	Handouts	201-205
Assignment # 03
Data Manipulation Language	27	Handouts	206-209
Insert and Select Statements	28	Handouts	210-214
Where Clause and Operators (Not, Between, IN, Like)	29	Handouts	215-219
Order By Clause, Having Clause, Functions	30	Handouts	220-225
Joins	31	Handouts	226-237
Application Programs	32, 33	Handouts	238-254
Assignment # 04
Data Storage Concepts	34	Handouts	255-259
File Organizations	35	Handouts	260-264
Hashing	36	Handouts	265-269
Indexes	37, 38	Handouts	270-279
Quiz # 02
Views	39, 40, 41	Handouts	280-292
Transaction	42	Handouts	293-301
GDB
Database Recovery	43	Handouts	302-309
Concurrency Control	44	Handouts	310-317
Locking	45	Handouts	318-324
Final Term Exams