DBSLectures

(theory) || Typical Functions of DBMS, Major components of DBMS environment, History and Development of DBMS, Advantages & Disadvantage of DBMS. ||  || Assg#2: Google Big Table ||   || (theory) || Database Models, Conceptual Modeling, Three Level Database Architecture, External, Conceptual, internal Levels,DDL, DML, Function of DBMS, Components of DBMS, Multiuser DBMS Architecture || || Assg #3: Semantic Web ||   || (theory) || Schemas, Mapping and Instances, Data Independance, Logical & Physical Data Independance, Classification of Datbase Model, ||  ||   ||   || (theory) || Brief History of the Relational Model, Terminology (Relational Data Structure, Mathematical Relations, Database Relations, Properties of Relations, Relational Keys, Representing Relational Database Schemas), || ||   ||   || (theory) || Integrity Constraints (Nulls, Entity Integrity, Referential Integrity, General Constraints), Views ||  ||   ||   || (theory) || The Relational Algebra, Unary Operations, Select, Project, Product || ||   ||   || (Theory) || ERD and Normalization Practice excercise ||  ||   ||   || (Practical) || Project Discussion ||  ||   ||   || (Practical) || C# .Net connectivity with Oracle 11g, Oracle Data Provider installation and configuration. ||  ||   ||   || (Theory) || Transaction Management (cont.), concurrency problem scenarios, Two phase locking, deadlock, demo. || ||   ||   || (Practical) || Project ||   ||   ||   ||
 * **S.No** || **Date** || **Day** || **Topic of Lecture** || **Downloads** || **Assignments** || **Comments** ||
 * 1 || 03/Feb/2012 || Friday (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 etc. || [[file:Chapter01.pdf]] || Assg #1: SQL ||  ||
 * ||  || Friday (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. ||   ||   ||   ||
 * 2 || 07/Feb/2012 || Tuesday
 * ||  || Tuesday (Lab) || distinct, column alias, concatenation operator, expression writing in SQL, NVL function, dual (dummy table), difference b/w SQL and SQL plus environment. ||   || Practical Assg #1 SQL Queries ||   ||
 * 3 || 10/Feb/2012 || Friday
 * ||  || Friday(theory) || order by, ascending, descending, comparison operator (=,>,<,<>,!=), like, IN, Between, Is Null, Is Not Null, Logical operators (And, OR, Not) ||   || Practical Assg #1 SQL Queries ||   ||
 * 4 || 14/Feb/2012 || Tuesday
 * ||  || Tuesday (Lab) || Single Row Functions, lower, upper, initcap, trunc, round, length ||   ||   ||   ||
 * 5 || 17/Feb/2012 || Friday
 * ||  || Friday (Lab) || Working with dates, conversion function (to_char, to_number, to_date). ||   ||   ||   ||
 * 6 || 21/Feb/2012 || Tuesday
 * ||  || Tuesday (Lab) || Group funtions, AVG, Sum, Count, Group by cluase, nested functions ||   ||   ||   ||
 * 7 || 24/Feb/2012 || Friday
 * ||  || Friday (Lab) || Obtaining data from multiple tables, Cartesian Product, Types of Joins, Equi Join, Natural Join, Semi Join, Self Join ||   ||   ||   ||
 * 8 || 28/Feb/2012 || Tuesday(theory) || Set Operations, Join Operations, Aggregation and Grouping Operations, Expression Tree, Summary of the Relational Algebra Operations ||  ||   ||   ||
 * ||  || Tuesday (Lab) || Non-Equi Join, Outer Join, Right Outer Join, Left Outer Join, Inner Join || [[file:Assignment#3.pdf]] ||   ||   ||
 * 9 || 02/Mar/2012 || Friday (theory) || Relational algebra practice exercises, Division Operation, Rename. ||  ||   ||   ||
 * ||  || Friday (practical) || Sub Query, Correlated Sub query ||   ||   ||   ||
 * 10 || 06/Mar/2012 || Tuesday(theory) || Entityt Relationship Daigram, Entity type, Relationship type, Attributes, Semantic net, ||  ||   ||   ||
 * ||  || Tuesday (Lab) || in-line sub query with examples, join queries re-visited. ||   ||   ||   ||
 * 11 || 13/Mar/2012 || Tuesday || Midterm I ||  ||   ||   ||
 * 12 || 16/Mar/2012 || Friday (theory) || ERD, Degree of Relationship, unary, binary, ternary, role names, attribute domain, Entity types: strong & weak entity, association entity or composite entity, || [[file:Chapter11.pdf]] ||  ||   ||
 * ||  || Friday (practical) || Create table, Alter Table, Insert record, Update record. ||   ||   ||   ||
 * 13 || 27/Mar/2012 || Tuesday (Theory) || ERD, type of attributes, simple, composite, single valued attribute, multi-valued attribtue, Derived Attributes, types of keys. ||  ||   ||   ||
 * ||  || Tuesday (Lab) || DCL, create user, grant previliges. ||   ||   ||   ||
 * 14 || 30/Mar/2012 || Friday (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. || [[file:Ch#4ERDmodel.pdf]] ||  ||   ||
 * ||  || Friday (practical) || Join, sub queries, in line view queries. ||   ||   ||   ||
 * 15 || 03/Apr/2012 || Tuesday (Theory) || Practice excercise on ERD modeling, Normalization, Why Normalization? 1NF, 2NF, 3NF. || [[file:Nomlization(Lecture#1).pdf]] ||  ||   ||
 * ||  || Tuesday (Lab) || Project Proposal Submission ||   ||   ||   ||
 * 16 || 06/Apr/2012 || Friday (Theory) || Normalization Recap, BCNF, 4NF: Mulitvalued Dependancy, 5NF: PJNF (Project Join Normal Form), Loss less Join, DKNF (domain key normal form), 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. || [[file:AdvanceNF(4NF&5NF)Lecture#2.pdf]] ||  ||   ||
 * ||  || Friday (practical) || Project ERD group discussion ||   ||   ||   ||
 * 17 || 10/Apr/2012 || Tuesday (Theory) || Normalization Practice Exercise, Normalization Quiz ||  ||   ||   ||
 * ||  || Tuesday (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 || 15/Apr/2012 || Sunday
 * ||  || Sunday(Practical) || Project Discussion ||   ||   ||   ||
 * 19 || 17/Apr/2012 || Tuesday(Theory) || ERD and Normalization Practice excercise ||  ||   ||   ||
 * ||  || Tuesday
 * 20 || 24/Apr/2012 ||  || Midterm II ||   ||   ||   ||
 * 21 || 27/Apr/2012 || Friday(Theory) || Database Planning Design and Administration ||  ||   ||   ||
 * ||  || Friday(Practical) || Project Discussion ||   ||   ||   ||
 * 22 || 04/May/2012 || Friday(Theory) || Transaction Management, Concurrency Control || [[file:Ch09Concurrency Control.pdf]] ||  ||   ||
 * ||  || Friday
 * 23 || 08/May/2012 || Tuesday
 * ||  || Tuesday
 * 24 || 11/May/2012 || Friday ||  ||   ||   ||   ||
 * 26 || 15/May/2012 || Tuesday ||  ||   ||   ||   ||
 * 27 || 18/May/2012 || Friday ||  || [[file:PlSQLBookChapter.pdf]] ||   ||   ||
 * 28 || 22/May/2012 || Tuesday ||  || [[file:Triggers.pdf]] ||   ||   ||
 * 29 || 25/May/2012 || Friday ||  ||   ||   ||   ||
 * 28 || 22/May/2012 || Tuesday ||  || [[file:Triggers.pdf]] ||   ||   ||
 * 29 || 25/May/2012 || Friday ||  ||   ||   ||   ||
 * 29 || 25/May/2012 || Friday ||  ||   ||   ||   ||
 * 29 || 25/May/2012 || Friday ||  ||   ||   ||   ||