This is my final project for the CS50’s course Introduction to Databases with SQL. It's about a SQLite database of a company that manages the hiring of superheroes and supervillains worldwide: the SuperAgency!.
- Title: "SuperAgency!"
- Type: SQLite database
- Submited to CS50 on: 2024-12-14
- Authors:
This is a list of the files I consider most relevant or think are better to comment on.
- diagram.png: the entity relationship diagram.
- schema.sql: the full schema.
- DESIGN.md: database’s purpose, scope, entities, relationships, optimizations, and limitations.
- queries.sql: an annotated set of SQL statements that users would commonly be expected to run.
- superagency.db: the database.
- dump_full.sql: the full schema plus all the INSERT statements.
- inserts_only.sql: all the INSERT statements.
- log.md: Unfinished chronological account of the process. We abandoned it when we saw that it was too long and took up too much of my time. There are many things missing there.
- missing_superentities.txt: A disorganized compendium of super-entities that are not yet in the database.
- command_log.sql: A chaotic log of many of the commands we used in the process.
- superagency_before_submit.zip: the files that we submitted as they were just before we submitted them.
- superagency_extra_files.zip: the rest of the files (those that we used but we didn't submitted) as they were just before my submission.
As we explain in log.md, after we almost finished our first version of the SuperAgency! database, we found in the web a Superhero Database with hundreds of super-entities. It is centered exclusively on super-entities and has nothing related to an agency that hires them, but we adapt some of its tables for our project.
So this special credits and thanks go to:
-
@bbrumm, who appears to be the one who created virtually that entire database.
-
@miqueldespuig and @KateKatze, who I see had each made one commit at the time we used that database.