Advanced Database (CSC 461) is an Eighth Semester course in Tribhuvan University’s BSc CSIT program. It extends core database knowledge into the enhanced E-R and relational models, object and object-relational databases, query processing and optimization, distributed databases, NoSQL systems, big data with MapReduce and Hadoop, and advanced database models.
Start with the official Advanced Database syllabus (CSC 461), then study from the notes below:
What you’ll learn
- EER modeling and converting ER/EER models to relations
- File structures, hashing, indexing, and advanced SQL
- Object databases with ODMG, ODL, and OQL
- Query trees, heuristic optimization, and cost-based execution plans
- Distributed database design, the CAP theorem, and NoSQL data stores
- Big data with MapReduce and Hadoop, plus active, temporal, spatial, and deductive databases
Course snapshot
- Code: CSC 461
- Program: BSc CSIT, Eighth Semester
- Board: Tribhuvan University (IOST)
- Nature: Theory + Lab, 3 credit hours
- Marks: 60 (final) + 20 (internal) + 20 (lab)