Advanced Database Management System – Syllabus | Seventh Semester | BSc.CSIT (TU)

Download our Android App from Google Play Store and start reading Reference Notes Offline.

advanced database management system syllabusCourse Syllabus | BSc.CSIT
Advanced Database Management System
Seventh Semester | Fourth Year
Tribhuvan University (TU)

Course Title: Advanced Database Management System
Course No: CSC-401
Credit Hours: 3
Full Marks: 60 + 20 + 20 | Pass Marks: 24 + 8 + 8
Natureof Course: Theory (3Hrs.) + Lab (3Hrs.)
Synopsis: To study the concept of advanced database techniques
Goals: To study the further advanced database techniques beyond the fundamental database techniques which were covered in the sophomore year (fourth semester) BCScIT course, and thus to acquaint the students with some relatively advanced issues. At the end of the course students should be able to: critically assess new developments in database technology, Interpret and explain the impact of emerging database standards, evaluate the contribution of database theory to practical implementations of database management systems.

Course Contents:

Unit 1: The Relational Model of Data and RDBMS Implementation Techniques [5 Hrs.]
Theoretical concepts, Relational model conformity and Integrity, Advanced SQL programming, Query optimization, Concurrency control and Transaction management, Database performance tuning, Distributed relational systems and Data Replication, Security considerations

Unit 2: The Extended Entity Relationship Model and Object Model: [6 Hrs.]
The ER model revisited, Motivation for complex data types, User defined abstract data types and structured types, Subclasses, Super classes, Inheritance, Specialization and Generalization, Constraints and characteristics of specialization and Generalization, Relationship types of degree
higher than two.

Unit 3: Emerging Database Management System Technologies [18 Hrs.]
Object Oriented database concepts; Object Relational database concepts; Active database concepts;
Temporal database concepts; Spatial database concepts and architecture; Deductive databases and
Query processing; Mobile Databases; Geographic Information Systems.

Unit 4: New database applications and environments [8 Hrs.]
Data Warehousing and Data Mining, Multimedia; Mobility; Multidatabases; Native XML databases
(NXD), Internet

Unit 5: Database Related Standards [8 Hrs.]
SQL standards, SQL 1999, SQL: 2003, Object Data Management Group (ODMG) version 3.0 standard, Standards for interoperability and integration e.g. Web Services, SOAP, XML related specifications, e.g. XQuery, XPath.

Laboratory Projects: The course involves a mini project using any one of the popular Commercial Object-Oriented DBMS software such as Oracle, MS SQL Server etc, along with any MVC software development framework.

Reference Books:
1. Elmasri and Navathe, Fundamentals of Database Systems, Pearson Education
2. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, McGraw-Hill
3. Korth, Silberchatz, Sudarshan , Database System Concepts, McGraw-Hill.
4. Peter Rob and Coronel, Database Systems, Design, Implementation and Management, Thomson Learning.
5. C. J. Date & Longman, Introduction to Database Systems, Pearson Education

Prerequisite: Be familiar with at least one OO programming language such as .Net or C++ or Java, Fundamentals of DBMS, SQL
Homework: Homework assignments can be given according to the course Assignments: covered throughout the semester.
Computer Usage: Windows or Linux based PC or workstation, Commercial OODBMS software package and MVC software development framework installed at the server.
Category Content: Science Aspects: 60%, Design Aspects: 40%

(Visited 390 times, 1 visits today)

Posted By : Digvijay | Comment RSS | Category : Seventh Semester, Syllabus
Tag :

Post a Comment

Your email is never published nor shared. Required fields are marked *


Wordpress DMCA
Community | Toolbar | Android App | Founder/Developer : Hari Prasad Chaudhary | CSIT Portal Manager : Digvijay Chaudhary