f12_DBS_Lecture

etc. || ||   ||   || (theory) || Major components of DBMS environment, Components of DBMS,Advantages & Disadvantage of DBMS. ||  ||   ||   || (Lab) || order by, ascending, descending, comparison operator (=,>,<,<>,!=), like, IN, Between, Is Null, Is Not Null, Logical operators (And, OR, Not) || Ass #2 ||  ||   || (theory) || Schemas, Mapping and Instances, Data Independance, Logical & Physical Data Independance, Classification of Datbase Model, ||  ||   ||   || (Lab) || Single Row Functions, lower, upper, initcap, trunc, round, length || ||   ||   || (Lab) || Working with dates, conversion function (to_char, to_number, to_date). || ||   ||   || (theory) || Integrity Constraints (Nulls, Entity Integrity, Referential Integrity, General Constraints), Views ||   ||   ||   || (Lab) || Group funtions, AVG, Sum, Count, Group by cluase, nested functions || ||   ||   || (Lab) || Non-Equi Join, Outer Join, Right Outer Join, Left Outer Join, Inner Join ||  ||   ||   || (theory) || Relational algebra practice exercises, Division Operation, Rename. ||  ||   ||   || (Lab) || join queries re-visited. ||  ||   ||   || (theory) || ERD, Degree of Relationship, unary, binary, ternary, role names, attribute domain, Entity types: strong & weak entity, association entity or composite entity, ||  ||   ||   || (Lab) || Correlated Sub query, in-line sub query with examples. ||  ||   ||   || (theory) || ERD, type of attributes, simple, composite, single valued attribute, multi-valued attribtue, Derived Attributes, types of keys. ||  ||   ||   || (Lab) || Join, sub queries, in line view queries. ||  ||   ||   || (theory) || Practice excercise on ERD modeling, Normalization, Why Normalization? 1NF, 2NF, 3NF. || ||   ||   || (Lab) || Project ERD group discussion ||   ||   ||   || (theory) || Normalization Practice Exercise, Normalization Quiz || ||   ||   || (theory) || Functional Dependancy (FD), Type of FDs: trivial FD, non-trivial FD, completely non-traival FD, Rules of FD: Splitting rule, comining rule, trivial dependancy rule, transitive rule and Normalization Practice excercise ||  ||   ||   || (theory) || Locking, Concurrency Control, Backup and Recovery, Granularity Levels || ||   ||   || (theory) || Transaction Management (cont.), concurrency problem scenarios, Two phase locking, deadlock, demo. ||  ||   ||   || (Lab) || C# .Net connectivity with Oracle 11g, Oracle Data Provider installation and configuration. || ||   ||   || (theory) || Midterm Revision ||   ||   ||   || ||  ||   || (theory) || Trigger Part II, Correlation identifiers (pseudo records) Restrictions on triggers Trigger usage, Enabling and disabling triggers, Data Dictionary || ||   ||   || (Lab) || Triggers with Exception Handling || use this url for PL/SQL reference [] ||  ||   || Quiz on Monday from Sentiment Analysis Lecture ||  ||   ||
 * **S.No** || **Date** || **Day** || **Topic of Lecture** || **Downloads** || **Assignments** || **Comments** ||
 * 1 || 03/Sept/2012 || Monday(theory) || Introduction to Database, What is Database? What is DBMS? History of Databasel, File Based Systems, Limitations of File Based Approach, Roles of Database Environement: (Database Designer, Database Administrator, Data Administrator),History and Development of DBMS,
 * ||  || Monday (Lab) || Introduction to SQL, SQL sub languages: DDL, DML, DCL, TCL, Select. Selecting all columns, selecting specific column, where clause, arithmatic expression, arithmatic operators, null values in arithmatic expressions. || [[file:Les01(SQL).pdf]] ||   ||   ||
 * 2 || 06/Sept/2012 || Thursday
 * ||  || Thursday (Lab) || distinct, column alias, concatenation operator, expression writing in SQL, NVL function, dual (dummy table), difference b/w SQL and SQL plus environment. || **Ass #1 (SQL)** ||   ||   ||
 * 3 || 10/Sept/2012 || Monday(theory) || Database Models, Conceptual Modeling, Three Level Database Architecture, External, Conceptual, internal Levels,DDL, DML, Function of DBMS, Components of DBMS, Multiuser DBMS Architecture || [[file:Lecture#2(DatabaseArchitecture).pdf]] ||  ||   ||
 * ||  || Monday
 * 4 || 13/Sept/2012 || Thursday
 * ||  || Thursday
 * 5 || 17/Sept/2012 || Monday(theory) || Brief History of the Relational Model, Terminology (Relational Data Structure, Mathematical Relations, Database Relations, Properties of Relations, Relational Keys, Representing Relational Database Schemas), || [[file:Lecture#3(RelationalModel).pdf]] ||  ||   ||
 * ||  || Monday
 * 6 || 20/Sept/2012 || Thursday
 * ||  || Thursday
 * 7 || 24/Sept/2012 || Monday(theory) || The Relational Algebra, Unary Operations, Select, Project, Product || [[file:Lecture#4(RelationalAlgebra).pdf]] ||  ||   ||
 * ||  || Thursday (Lab) || Obtaining data from multiple tables, Cartesian Product, Types of Joins, Equi Join, Natural Join, Semi Join, Self Join || [[file:Les06 (JoinTable).pdf]] ||   ||   ||
 * 8 || 27/Sept/2012 || Monday(theory) || Set Operations, Join Operations, Aggregation and Grouping Operations, Expression Tree, Summary of the Relational Algebra Operations ||  ||   ||   ||
 * ||  || Monday
 * 9 || 01/Oct/2012 || Thursday
 * ||  || Thursday (Lab) || Sub Query || [[file:Les07(SubQuery).pdf]] ||   ||   ||
 * 10 || 04/Oct/2012 || Monday(theory) || Entityt Relationship Daigram, Entity type, Relationship type, Attributes, Semantic net, ||  ||   ||   ||
 * ||  || Monday
 * 11 || 08/Oct/2012 || Monday || Midterm I ||  ||   ||   ||
 * 12 || 15/Oct/2012 || Monday
 * ||  || Monday
 * 13 || 18/Oct/2012 || Thursday
 * ||  || Thursday (Lab) || Sub Qeuries, IN, Any, All, Create table, Alter Table, Insert record, Update record, DCL, create user, grant previliges. ||   ||   ||   ||
 * 14 || 22/Oct/2012 || Monday(theory) || ERD Advance, structural constraints, multiplicity, business rules, one to one (1..1), one to many (1..*), many to many(*..*), structral constraints with semantic net examples, mulitplicity constraints: cardinality and participation, Problems with ER models: Fan Trap, Chasm Trap. ||  ||   ||   ||
 * ||  || Monday
 * 15 || 25/Oct/2012 || Thursday
 * ||  || Thursday (Lab) || Project Proposal Submission ||   ||   ||   ||
 * 16 || 29/Oct/2012 || Monday(theory) || Normalization Recap, BCNF, 4NF: Mulitvalued Dependancy, 5NF: PJNF (Project Join Normal Form), Loss less Join, DKNF (domain key normal form) ||  ||   ||   ||
 * ||  || Monday
 * 17 || 01/Nov/2012 || Thursday
 * ||  || Thursday (Lab) || Pratice ERD on ErWin ver 4, logical ERD, Physical ERD, resolving many to many relationship to Association Entity, Forward Engineering in Oracle 11g. ||   ||   ||   ||
 * 18 || 05/Nov/2012 || Monday(theory) || ERD and Normalization Practice excercise || [[file:Lecture#8(Normalization).pdf]][[file:Lecture#9(Normalization).pdf]] ||  ||   ||
 * ||  || Monday (Lab) || Project Discussion ||   ||   ||   ||
 * 19 || 08/Nov/2012 || Thursday
 * ||  || Thursday (Lab) || Project Discussion ||   ||   ||   ||
 * 20 || 12/Nov/2012 || Monday(theory) || Transaction Managment || [[file:Lecture#10(TransactionManagementI).pdf]] ||  ||   ||
 * ||  || Monday(Lab) || PLSQL Basic || [[file:PLSQLBasic.pdf]] ||   ||   ||
 * 21 || 15/Nov/2012 || Thursday
 * ||  || Thursday (Lab) || PLSQL Loops || [[file:PLSQLBasicII.pdf]] ||   ||   ||
 * 22 || 19/Nv/2012 || Monday
 * ||  || Monday
 * 23 || 22/Nov/2012 || Thursday
 * ||  || Thursday (Lab) || Project ||   ||   ||   ||
 * 24 || 26/Nov/2012 || Monday || Midterm II ||  ||   ||   ||
 * 25 || 03/Dec/2012 || Monday (theory) || Midterm Paper Solution Discussion ||  ||   ||   ||
 * ||  || Monday(Lab) || Assignment #4 || [[file:Assignment#4(SQL-PLSSQL).pdf]] ||   ||   ||
 * 26 || 06/Dec/2012 || Thursday || SQL Advance ||  ||   ||   ||
 * ||  || Thursday (Lab) || SQL Advance Practice ||   ||   ||   ||
 * 27 || 10/Dec/2012 || Monday || Exception Handling, no_data_found, too_many_rows, zero_divide etc. ||  ||   ||   ||
 * ||  || Monday(Lab) || Exception Handling practice, Export/Import database schema, User creation, previlege assignements ||   ||   ||   ||
 * 28 || 13/Dec/2012 || Thursday || Darabase Triggers, Kinds of triggers, Row level Triggers, Statement Level Triggers, Firing triggers, Characteristics of triggers, Order of firing triggers, Syntax, Trigger Predicates, Naming Convention, Example || []
 * 28 || 13/Dec/2012 || Thursday || Darabase Triggers, Kinds of triggers, Row level Triggers, Statement Level Triggers, Firing triggers, Characteristics of triggers, Order of firing triggers, Syntax, Trigger Predicates, Naming Convention, Example || []
 * ||  || Thursday (Lab) || DB Trigger Practice ||   ||   ||   ||
 * 29 || 16/Dec/2012 || Sunday
 * ||  || Sunday
 * 30 || 20/Dec/2012 || Monday (theory) || Text classification and Sentiment Analysis (Guest Lecture by Mr Muhammad Atif) || [[file:AssignmentVI.txt]][[file:TextClassificationAndSentimentAnalysis_DataScience_MuhammadAtifQureshi.pdf]]
 * ||  || Thursday (Lab) || Project Discussion ||   ||   ||   ||
 * 31 || 24/Dec/2012 || Monday (theory) || XML, DTD, XSD || [[file:XMLFiles.rar]][[file:XMLLectures.rar]] ||  ||   ||
 * ||  || Thursday (Lab) || Project Prototype Discussion ||   ||   ||   ||
 * 32 || 31/Dec/2012 || Monday (theory) || Course Project Viva and Presentation ||  ||   ||   ||
 * ||  || Thursday (Lab) || Course Project Viva and Presentation ||   ||   ||   ||
 * 33 || 03/Jan/2013 || Monday (theory) || Distributed Databases || [[file:Lecture#15(DDB).pdf]] ||  ||   ||
 * ||  || Thursday (Lab) || Distributed Databases ||   ||   ||   ||