Super database

Try me

Open In ColabBinder ## Problem definition You are building a database for a ‘fandom’ website. The objective is to store in a database the information about superheroes in different comics across different comics. You want to store basic details about the following entities:

  • Comic editorial: name, and head-quarters (e.g. Marvel, New York),

  • Authors: Full name, role (either writer or artist),

  • Comic: Name, issue, publication date (e.g. Avengers, 1, 1963-09-20),

  • Super-Hero: Real name, fictional name (e.g. Peter Parker, Spiderman)

  • Super-hero squad: Name (e.g. Avengers)

  • Super powers: Name, description (e.g. super-strength, ability to kick ass bad time)

You also want to implement in your model, meaningful relationships to connect the different entities, for instance, which editorial publishes each comic, which are the authors of the comic, in which issues does every super hero appear, or what super-powers do they have.

Draw the model of your database design to discuss implementation details with your team mates. Include in the diagram field names and types and relationships.