Web Database and Information Systems (CSC-409)

Tribhuvan University

Institute of Science and Information Technology

Bachelor of Science in Computer Science and Information Technology

7th Sem: Course Title: Web Database and Information Systems

Course no: CSC-409                                                                         Full Marks: 60+20+20

Credit hours: 3                                                                                  Pass Marks: 24+8+8

Nature of course: Theory (3 Hrs.) + Lab (3 Hrs.)

Course Synopsis: Advanced aspects of web database and data mining

Goals: To study advanced aspects of web database and data mining, encompassing the principles, research results and commercial application of the current technologies.

Course Contents:

Unit 1. Overview of Database Systems                                                        1 Hrs.

Unit 2. The Entity-Relationship Model                                                          2 Hrs.

Unit 3. The Relational Model                                                                        3 Hrs.

Unit 4. SQL                                                                                                  4 Hrs.

Unit 5. Other Relational Languages                                                             2 Hrs.

Unit 6. Integrity and Security                                                                       3 Hrs.

Unit 7. Relational Database Design                                                              2 Hrs.

Unit 8. Object-Oriented Databases                                                               4 Hrs.

Unit 9. Object-Relational Databases                                                              4 Hrs.

Unit 10. XML and Web Databases                                                                 6 Hrs.

Unit 11. Data Storage, File Structures and Indexing                                      6 Hrs.

Unit 12. Database System Architectures                                                       3 Hrs.

Unit 13. Application Development and Administration                                   3 Hrs.

Unit 14. Advanced Querying and Information Retrieval                                 5 Hrs.

Laboratory Projects:            Design and development of Web database using XML.

Text Books:

1. Database System Concepts (4th Edition), Silberschatz, Korth, and Sudarshan, 2002. 
2. Oracle 9i Programming: A Primer, Rajshekhar Sunderraman, 2003

Homework

Assignment:              Assignment should be given from the throughout the semester.

Computer Usage:      No specific

Prerequisite:             C, Database, Object Oriented Programming (C++ or Java)

Category Content:    Science Aspect:           25%

                                 Design Aspect:             75%