SUBJECT: DATABASE DESIGN CREATE A ERD RELATIONSHIP Draw an Entity Relationship d

Question

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).

Explanation / Answer

Hi,

Please find below lucidchart shareable link for the erd

https://www.lucidchart.com/invitations/accept/56c1406e-8abc-4245-8ff9-c060076ecb51

Below are ERD table and entity details:

Movie_Type : This will store all the diffent types of movies ( cartoon, or documentary)

Movie: this will have all the common movie details for all movies.

Cartoon: This will be linked to the caracter table which will have the list of characters

Documentaries: This will be having the type of documentary and the additional info(location, period etc)

All the tables are linked to each other using Foreign keys.

Also below is the image link from Google drive:

https://drive.google.com/open?id=13qrABPWttQ0rl6GHgyKblOOLKsbgUWby

Please let me know in case of any difficulty in understanding. Thanks.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.