Syllabus

BSc CSIT · Semester VIII

Advanced Database syllabus

Official TU syllabus for Advanced Database (CSC475): 5 units, 36 topics, 3 credit hours. Every unit links to its notes and solved questions.

1

Enhanced Entity Relationship Model and Relational Model

8h · 8 Q
  • Entity Relationship Model Revised
  • Subclasses, Superclasses and Inheritance
  • Specialization and Generalization
  • Constraints and characteristics of specialization and Generalization
  • Union Types
  • Aggregation
  • Relational Model Revised
  • Converting ER and EER Model to Relational Model
  • SQL and Advanced Features
  • Concepts of File Structures, Hashing, and Indexing
Unit notes →Solved questions →
2

Object and Object Relational Databases

10h · 6 Q
  • Object Database Concepts
  • Object Database Extensions to SQL
  • The ODMG Object Model and the Object Definition Language ODL
  • Object Database Conceptual Design
  • Object Query Language OQL
  • Language Binding in the ODMG Standard
Unit notes →Solved questions →
3

Query Processing and Optimization

7h · 6 Q
  • Concept of Query Processing
  • Query Trees and Heuristics for Query Optimization
  • Choice of Query Execution Plans
  • Cost-Based Optimization
Unit notes →Solved questions →
4

Distributed Databases, NOSQL Systems, and BigData

12h · 12 Q
  • Distributed Database Concepts and Advantages
  • Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design
  • Types of Distributed Database Systems
  • Distributed Database Architectures
  • Introduction to NOSQL Systems
  • The CAP Theorem
  • Document-based, Key-value Stores, Column-based, and Graph-based Systems
  • BigData
  • MapReduce
  • Hadoop
Unit notes →Solved questions →
5

Advanced Database Models, Systems, and Applications

8h · 4 Q
  • Active Database Concepts and Triggers
  • Temporal Database Concepts
  • Spatial Database Concepts
  • Multimedia Database Concepts
  • Deductive Database Concepts
  • Introduction to Information Retrieval and Web Search
Unit notes →Solved questions →

Textbooks and references

  • Elmasri and Navathe, Fundamentals of Database Systems, Pearson Education.
  • Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, McGraw-Hill
  • Korth, Silberchatz, Sudarshan, Database System Concepts, McGraw-Hill.
  • Peter Rob and Coronel, Database Systems, Design, Implementation and Management, Thomson Learning.
  • C. J. Date & Longman, Introduction to Database Systems, Pearson Education
  • Tiwari, Shashank and Safari, professional Nosql, O'Reilly Media Company.
  • Gunarathne, Thilina Hadoop MapReduce v2 Cookbook: Explore the Hadoop MapReduce v2.
  • Ecosystem to Gain Insights from very Large Datasets, 2nd Edition, PACKT Publishing.

Study CSC475 the smart way

Solved questions, flashcards & practice

Keep studying

Study CSC475

All chapters, flashcards and practice.

Important questions

See what is most likely to appear.

Past papers

Solved past questions by year.

Browse subjects

All programs and subjects.

NoteTok feed

Short explainer videos.