SUBJECT: DATABASE DESIGN

CREATE A ERD RELATIONSHIP

Draw an Entity Relationship diagram using Lucidchart

An elementary school library keeps the information about all the movies stored in the library. All the movies have their IMDB unique id, title, year released, and a brief summary of the movie plot. For the movies of two types, cartoons and documentaries, the library stores additional information. For every cartoon, the library has a list of characters from the cartoon; for the geography-related documentaries, the library stores the information about the location where the documentary was shot; for the historyrelated documentaries, the library stores the information about the historic period described in the documentary; for the rest of the documentaries, the library stores a list of topics discussed in the documentary. There are no cartoons that are documentaries. Some of the documentary movies can be on several topics (e.g., a movie about Renaissance in Italy is both geography- and history-related).