Grand Comics Database

Design and implementation of a database schema for comic book data, including parsing and loading the data into a DBMS, executing queries, and enhancing query efficiency through index structures and query plan analysis.

Grand Comics Database project

Project for the course CS-322: Introduction to database systems

Submitted on Tuesday, 31 May 2022, 20:54.

Everything is explained in Report.pdf but to recap:

Given a set of files collected by a real‐world entity with data about comic books (available in Part_1/GCD_2022) the goal was to design the database schema and implement the relational schema, parse and load the data into a DBMS, write queries, and finally evaluate and optimize queries with index structures/query plan analysis.

ER Diagram

er_diagram