Course Outline: Database Systems

 

 

Resource: Mr. Sheraz Pervaiz

Credit Hrs:  4 (  Lec  3 )                                                        

Semester:  Spring 2008

Email      : sherazpervaiz@gcu.edu.pk

 

Course Objective:

 

The course aims to introduce basic database concepts, different data models, data storage and retrieval techniques and database design techniques. The course primarily focuses on relational data model and DBMS concepts.

 

             Text  Books:

 

Database Systems: A Practical Approach to Design, Implementation and Management, R.Connolly and P.Begg, Addison-Wesley Pub. Co (2003).

 

 

Database System by Catherine Richardo.

 

             Reference Books:

 

· Database Systems, C.J.Date, Addison Wesley Pub. Co. (2004).

Fundamentals of Database Systems, 3/E, Elmasri and Navathe, Addison-

Wesley, ISBN: 0-201-74153-9.

 

Electronic Lists

 

Class mailing list: An email list has been setup to include the email addresses of all the enrolled students. We will use it to send out announcements.

 

Online Reference:

 

· http://www.ics.uci.edu/~ics215/readings.html

· http://databases.about.com/

· http://www.w3schools.com/sql/default.asp

http://www-ccs.cs.umass.edu/db/databasesites.html

 

 

 

 

 

Software Required:

 

1. Oracle 8 or Oracle 8i or above

2. Developer 2000

3. ERWin 4.1

4. Toad Data Modeler: http://www.quest.com/Toad_Data_Modeler/

 

Break Down of Grade

 

 

Quiz / Assignment                               : 20

 

Mid-Term                                  : 30

 

Final Project                                               : 20

 

Final Exam                                 : 30

 

Total                                                         : 100

 

 

· All marks are in %age.

 

Week Mon-Sat

 

 

 

Topics

Activity

 

Wk-1

 

Basic Database Concepts, What is integrated environment and DB,  What is Database Administrator, Role of Database Administrator, Data and Information, Traditions Vs Scientific Approaches,

 

 

 

Wk-2

 

What are Tiers, N-Tier, 3-Tier Architecture, Different File structures, what are data models, what is meta data, Different data models, Database Design life cycle

 

 

Case studies will be discussed

 

Assignment # 1

 

 

 

 

Wk-3 & 4 & 5

 

Requirement Gathering Techniques, Introduction to Entity-Relationship Model, Different notations to represent ERD, Cardinalities, Referential Integrity Constraints,

Extended ERD

 

 

 

Case studies will be discussed

 

Quiz # 1

 

 

Wk-6 & 7

 

Database Normalization, 1NF, 2NF, 3NF, BCNF and 4NF.

 

 

 

Assignment # 2

 

 

Wk- 6 & 7

 

De-normalization, 8-Techniques of De-normalization.

Data consistency and Integrity issues

 

 

 

 

 

 

Wk-8 & 9

 

What is Transaction Processing, introduction to DDL, DML AND DCL in Oracle

 

Lab Session

 

Quiz # 2

 

 

 

Wk-10 & 11 & 12

 

Introduction to SQL with Implementation in Oracle

 

Sample Problems will be discussed to motivate the students.

 

 

Wk-13

 

Introduction to PL/SQL, Structure of PL/SQL, What is SQL*Plus, Report generation in SQL*PLUS, What are environment Variables

 

· Lab Session

 

Wk-14

 

Accessing Environment Variables in PL/SQL, Loops in PL/SQL, DML and DCL embedded in PL/SQL

 

Assignment # 3

 

 

Wk-15

 

PL/SQL Tables in Oracle, Record Type in PL./SQL

 

· Quiz # 3

 

Wk-16

 

Introduction to Relation Algebra

Assignment # 3

 

Research Papers will be discussed to motivate students toward research