Comic books database
This project could be something like a personal collection database, for people that collect comic books, or any other kind of books. This is a simple database, but can be a fun project for a student to make, and even maybe build an application on top of it.
The data in this database will be around the entity Comic and its details.
The properties can include the following:
- Comic name, year, category, character Id, date of purchase, gifted by (if the comic was a gift)
- And we can have separate tables for main characters and the categories (genres) so we can connect them to the 'Comic' table.
Query examples:
Find all the Superman comics released in 1998.
Find all the Batman comics gifted by Anne.
The data should be structured like in the following example ER diagram:
