DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING COURSE PLAN Course Code: CS0326 Course Title: Advanced Database Semester:VI Course Time:Jan-May 2010

Day

Section A,B Hour

B,C,D Timing

Hour

Timing

Monday

2,4

9.20-10.10 11.10-12.00

2,4

9.20-10.10 11.10-12.00

Tuesday

-

-

-

-

Wednesday

-

-

-

-

Thursday

-

-

-

-

Friday

5

1.30-2.20

5

1.30-2.20

Location:S.R.M.E.C-Tech Park Faculty Details:

Section A,B B,C,D

Name Mr.A. MURUGAN Mr.R. JEBAKUMAR

Office Office Hour Tech Monday to Friday Park Tech Monday to Friday Park

Mail id [email protected] [email protected]

TEXT BOOK 1. Database Systems – Thomas Connolly, Carolyn Begg. 3rd Edition – Pearson Education. REFERENCE BOOKS 1. Database System Concepts – Abraham Silberschatz, Henry F.Korth, Sudarshan. 4th Edition – McGraw-Hill. 2. M.Tamer Ozsu , Patrick Ualduriel, “Principles of Distributed Database Systems”, Second Edition, Pearson Education, 2003. 3. Ramez Elmasri & Shamkant B.Navathe, “Fundamentals of Database Systems”, Fourth Edition, Pearson Education , 2004.

4.

Peter Rob and Corlos Coronel, “Database Systems – Design, Implementation and Management”, Thompson Learning, Course Technology, 5th Edition, 2003.

Prerequisite

: •

CS304 Data Base Management Systems

Objectives 1. 2. 3.

Several Database concepts like Distributed Database, Spatial Database, Mobile Database, Temporal Database Applications of Databases Analysis of Database design and Methodology

Assessment Details Cycle Test – I Surprise Test – I Cycle Test – II Surprise Test – II Model Exam

: : : : :

10 Marks 7 Marks 10 Marks 8 Marks 15 Marks

Test Schedule S.No. 1 2 3

DATE 15.02.2009 22.03.2009 26.04.2009

TEST Cycle Test - I Cycle Test - II Model Exam

TOPICS Unit I & II Unit III & IV All 5 units

DURATION 2 periods 2 periods 3 Hrs

Outcomes Students who have successfully completed this course will have full understanding of the following concepts Course outcome To Learn Data base Environment – Relational Model To Learn Database Analysis & Design Techniques To Learn database Normalization To Learn various Methodology To Learn Object oriented Distributed database To Learn Current Trends in Database Systems

Program outcome The Students can , Able to design ER Model for any application Able to construct SQL queries for any requirement Able to Decompose any Schema by applying normal forms Able to Design Database for any application Able to give security and Transaction Processing for any application Able to design Object Oriented Distributed Data base Able to apply the current trends in the Database

Environments

Detailed Session Plan

INTRODUCTION Introduction to Database – Database Environment – Relational Model – Relational Algebra and Relational Calculus – Introduction to SQL – Commercial RDBMS – Ms Access 2000 Oracle 8i

Session No.

Topics to be covered

Time (min)

Ref

Teaching Method

Testing Method

Group discussion Quiz Group discussion Quiz

1

Introduction to Database

50

1

BB

2

Database Environment

50

1

BB

3

Relational Model

50

1

BB

Quiz

4

Relational Algebra

50

1

BB

Quiz

5

Relational Calculus

50

1

BB

6

Introduction to SQL

50

1

BB

Quiz Objective type test

7

Commercial RDBMS

50

1

BB

Quiz, Assignment

Ms Access 2000

50

1

BB

Oracle 8i

50

1

BB

8 9

Quiz

Group discussion Comparative study Group discussion Comparative study

DATABASE ANALYSIS & DESIGN TECHNIQUES Database Planning – Design & Administration – Fact finding techniques - E-R Modeling – EER Modeling – Normalization.

50

1

BB

Design & Administration

100

1

BB

Fact finding techniques

100

1

BB

10

Database Planning

11 12

Quiz Quiz Brain storming Quiz Surprise Test

13

E-R Modeling

50

1

BB

14

EER Modeling

50

1

BB

15

Normalization

100

1

BB

Group discussion Quiz Group discussion Quiz Group discussion Comparative study

METHODOLOGY 9 Logical Database Design for Relation Model – Physical Database Design for Relational Database – Security – Transaction Processing – Query Processing.

20

Logical Database Design for Relation Model

100

1

BB

21

Physical Database Design for Relational Database

100

1

BB

22

Security

100

1

BB

23

Transaction Processing

100

1

BB

24

Query Processing

50

1

BB

Group discussion Objective type test Quiz Group discussion Quiz, Comparative study Quiz Surprise Test Quiz Surprise Test

OBJECT ORIENTED AND DISTRIBUTED DATABASES Introduction to Object DBMS – Object DBMS Concepts and Design – Distributed Database Concepts and Design – Advanced Concepts of Distributed Database – Introduction to Parallel Database.

31

Introduction to Object DBMS

32

50

1

BB

Object DBMS Concepts and Design

100

1

BB

33

Distributed Database Concepts and Design

100

1

BB

34

Advanced Concepts of Distributed Database

100

1

BB

35

Introduction to Parallel Database

100

1

BB

CURRENT TRENDS

Group discussion Assignment Group discussion Objective type test Quiz Group discussion Quiz Brain storming Objective type test Quiz G di i

Mobile Database – Geographic Information Systems – Genome Data Management – Multimedia Database – Parallel Database – Spatial Databases –Temporal databases - Database administration – Data

44

Mobile Database

50

1

BB

Group discussion Objective type test

45

Geographic Information Systems

50

1

BB

46

Genome Data Management

50

1

BB

47

Multimedia Database

50

1

BB

48

Parallel Database

50

1

BB

49

Spatial Databases

50

1

BB

50

Temporal databases

50

1

BB

51

Database administration

50

1

BB

52

Data Warehousing

50

1

BB

Group discussion Comparative study Group discussion Comparative study Group discussion Objective type test Group discussion Objective type test Group discussion Objective type test Group discussion Objective type test Objective type test Quiz G di i Brain storming

53

Data Mining.

50

1

BB

Brain storming

•

BB – BLACK BOARD