CSE341_Database+_Systems

=CSE341: Database Systems= =Program:= BS(CS)

Semester:
Fall 2012

Instructor:
Imran Khan

**Course Lead:**
Imran Khan

**Credit Hours:**
4 (3 credit hours for theory + 1 credit hour for lab)

Prerequisite(s):
CSE246

Course Description:
This course covers the theoretical and applied aspects of database systems. It explains concept, modeling and implementation details of relational database management system. It includes extensive coverage of the relational model, relational algebra, and SQL. The course includes relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions management, authorization, integrity constraints, triggers. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT.

Course Objectives:
At the end of this course student will be able to: Work on semi-structure database such as XML.
 * 1) understand the terminology of the different database models.
 * 2) model conceptual, logical and physical database model.
 * 3) create, manipulate, delete and query database object as well as make it secure.
 * 4) make connection between mathematical relations and relations in the relational model.
 * 5) Identify different types of keys in database and their use.
 * 6) Identify various types of update anomalies (insertion, modification, deletion)
 * 7) do the normalization of database model
 * 8) understand the concept of Transaction management and concurrency control in database.

Books:
//A practical approach to Design, Implementation and Management// Thomas Connolly, Carolyn Begg, Anne Strachan //4th Edition//
 * Textbook **
 * // Database Systems //**

//Oracle Press//
 * // Introduction to SQL PL/SQL Oracle 9i/10g //**

2nd edition //2. A First Course in Database Systems// Jeffery D. Ullman, Jennifer Widom 3rd edition
 * Reference books **// 1. Database Management Systems // Ramakrishnan, Johannes Gehrke

3. Fundamentals of Database Systems Navathe, Somayajulu, Gupta

Web Resources:
Any web resources that may be used during the course.

Grading Policy:
The recommended grading policy, with weights attached to Quizzes, Homework assignements, Midterm exams, projects and Final Exams.

Uploaded Reference Course Outline:
You may also upload a course outline here.

Class Time Spent On (In Credit Hours):
Theory: 2.5 Problem Analysis: 0.5 Solution Design: 0.5 Social and Ethical Issues: 0.5


 * |||||||| ==**Topics Covered in the Course **== ||  ||   ||
 * **S.No** || **Date** || **Day** || **Topic of Lecture** || **Downloads** || **Assignments** || **Comments** ||
 * 1 || 03/Feb/2012 || Friday || Introduction to Database, What is Database? What is DBMS? History of Databasel, File Based Systems, Limitations of File Based Approach, Roles of Database Environement || [[file:Chapter01.pdf]] || Assg #1: SQL ||  ||
 * 2 || 07/Feb/2012 || Tuesday || Typical Functions of DBMS, Major components of DBMS environment, History of Development of DBMS ||  ||   ||   ||
 * 3 || 10/Feb/2012 || Friday || Database Model, Three Level Database Architecture, External, Conceptual, internal Levels. || [[file:Chapter02.pdf]] ||  ||   ||
 * 4 || 14/Feb/2012 || Tuesday || Logical & Physical Data Independance, Classification of Datbase Model, ||  ||   ||   ||
 * 5 ||  ||   ||   ||   ||   ||   ||
 * 6 ||  ||   ||   ||   ||   ||   ||
 * 7 ||  ||   ||   ||   ||   ||   ||
 * 8 ||  ||   ||   ||   ||   ||   ||
 * 9 ||  ||   ||   ||   ||   ||   ||
 * 10 ||  ||   ||   ||   ||   ||   ||
 * 11 ||  ||   ||   ||   ||   ||   ||
 * 12 ||  ||   ||   ||   ||   ||   ||
 * 13 ||  ||   ||   ||   ||   ||   ||
 * 14 ||  ||   ||   ||   ||   ||   ||
 * 15 ||  ||   ||   ||   ||   ||   ||
 * 16 ||  ||   ||   ||   ||   ||   ||
 * 17 ||  ||   ||   ||   ||   ||   ||
 * 18 ||  ||   ||   ||   ||   ||   ||
 * 19 ||  ||   ||   ||   ||   ||   ||
 * 20 ||  ||   ||   ||   ||   ||   ||
 * 21 ||  ||   ||   ||   ||   ||   ||
 * 22 ||  ||   ||   ||   ||   ||   ||
 * 23 ||  ||   ||   ||   ||   ||   ||
 * 24 ||  ||   ||   ||   ||   ||   ||
 * 25 ||  ||   ||   ||   ||   ||   ||
 * 26 ||  ||   ||   ||   ||   ||   ||
 * 27 ||  ||   ||   ||   ||   ||   ||
 * 28 ||  ||   ||   ||   ||   ||   ||


 * ==**Laboratory Projects/Experiments Covered in the Course (optional) **== ||
 * S.No || Date || Day || Topic ||
 * 1 ||  ||   ||   ||
 * 2 ||  ||   ||   ||
 * 3 ||  ||   ||   ||
 * 4 ||  ||   ||   ||
 * 5 ||  ||   ||   ||
 * 6 ||  ||   ||   ||
 * 7 ||  ||   ||   ||
 * 8 ||  ||   ||   ||
 * 9 ||  ||   ||   ||
 * 10 ||  ||   ||   ||
 * 11 ||  ||   ||   ||
 * 12 ||  ||   ||   ||
 * 13 ||  ||   ||   ||
 * 14 ||  ||   ||   ||