Horrors

Horrors

Prepare a diagram of a database that collects information about horror stories.

The database will hold information about creations in the horror genre (books and movies). We want to know their title, length (in minutes or pages), year of release and author (in the case of movies, the director). Keep in mind that there may be many authors of one work. If the film was based on a book, this information should also be included.

One work may be part of a larger series. Save the name of the series, and which number in order a given film or book is in the given series.

For each work we should record the characters that appear in it. Each character has a name and an occupation. Some of the characters have a given age. During the story of a book or movie, a character can be dead, alive or be revived, which should be recorded in the database. In case we don't know what the status of a character is, they should be added to the "characters missing in action" group, whose fate is unknown.

Additionally, information about monsters appearing in the work should be kept in the database. Each monster has its own name, level of scariness, size and preferred lifestyle. We distinguish ghosts and demons, among other monsters. There should be information in the database on which characters have been possessed by a demon. It should be noted that different demons can possess different people many times. In addition, it is possible to have a case when an ordinary ghost was transformed into a demon. In this case, the database should contain information about what kind of ghost it was.