Lectures

=CSE341 - Database Systems=
 * Spring'2010, Faculty of Computer Science, IBA - Karachi**

||  || || Project Discussion || 7/5/10 ||   ||   || Project Demo and Discussion || 11/5/10 ||  ||  ||
 * **Unit #** || **Topic** || **Date** || **Lecture** || **Reading Material** ||
 * 1,2 || Introduction & History of Database Systems || 2/2/10 || [[file:DatabaseSystems01-Fundamentals.pdf]] || Connolly, Chapter -1 ||
 * 3,4 || DBMS Functions, Environment, Data Abstraction || 9/2/10 || [[file:DatabaseSystems02-DBMSEnvironment-DataAbstraction.pdf]] || Connolly, Chapter -1 & 2 ||
 * 5 || Data Modeling (Entities & Attributes) || 12/2/10 || [[file:DatabaseSystems03-DataModeling.pdf]] || Connolly, Chapter 3 ||
 * 6 || Data Modeling (Keys, Relationships, Degree, Cardinality) || 16/2/10 || [[file:DatabaseSystems04and05-DataModeling_Relationships.pdf]] || Connolly, Chapter 3 ||
 * 7 || Cardinality of relationship, Recursive relationships, participation constraints, attributes of relationship || 19/2/10 ||  || Connolly, Chapter 3 & 11 ||
 * 8 || Resolving M-M relationships,Cricket Tournament scenario || 23/2/10 || [[file:DatabaseSystems06and07-ER_to_Relational_IntegrityConstraints.pdf]] || Connolly, Chapter 3 & 11 ||
 * 9.10 || Mapping from conceptual to relational model || 28/2/10 ||  || Connolly, Chapter 3 & 11 ||
 * 11 || Normalization(1NF - 3NF) || 2/3/10 || [[file:DatabaseSystems08-11 Normalization.rar]] ||  ||
 * 12 || Normalization(1NF - 3NF) || 5/3/10 ||  ||   ||
 * 13 || Normalization (BCNF, 4NF) || 9/3/10 ||  ||   ||
 * 14,15 || Relational Algebra || 19/3/10 || [[file:DatabaseSystems-RelationalAlgebra.pdf]]
 * 16 || Relational Algebra || 26/3/10 ||  ||   ||
 * 17 || SQL (Simple SELECT and JOIN) || 30/3/10 || [[file:SQL-SimpleSelectandJoinGroupBy.txt]] || [[file:Select Queries - Solution.pdf]] ||
 * 18 || SQL (Aggregate, Group BY, Having) || 2/4/10 ||  ||   ||
 * 19 || SQL (Sub-queries, Co-related queries, Derived tables) || 6/4/10 || [[file:SQL-SubqueriesDatetimeInsertUpdateDelete.txt]] ||  ||
 * 20 || SQL (Exists/Not Exists, Datetime functions, Case, Union) || 9/4/10 ||  ||   ||
 * 21,22 || SQL ( INSERT, UPDATE, DELETE) || 13/4/10 ||  ||   ||
 * 23 || Views and Stored Procedures || 16/4/10 || [[file:SQL-ViewsStoredProcandTriggers.txt]] || [[file:Queries Solution.pdf]] ||
 * 24 || Triggers || 20/4/10 || [[file:SQL-Triggers.txt]] ||  ||
 * 25 || Indexing || 30/4/10 ||  || [[file:Database Indexing.pdf]]
 * 26 || Indexing || 4/5/10 ||  ||   ||
 * 27,28 || Transaction
 * 29,30 || Transactions & Concurrency
 * 31 || Isolation Levels || 14/5/10 ||  ||   ||
 * 32 || Database Security || 18/5/10 ||  || [[file:Database Security.doc]] ||
 * 33,34 || Database Backup/Recovery || 21/5/10 ||  || [[file:Database-BackupRestore.doc]] ||
 * 35 || Database Partitioning || 25/5/10 ||  || [[file:Partitioning.ppt]] ||
 * 36 || Database - Future directions (OLTP vs OLAP, Mining) || 28/5/10 ||  ||   ||
 * 37 || Closing Session || 1/6/10 ||  ||   ||