Make ER diagram for Movie website wants to store information about movies
Make ER diagram for
Movie website wants to store information about movies and
has chosen you to help them
Three steps:
Requirements Analysis: Discover what information needs to be stored,
how the stored information will be used, etc. Taught in course on system
analysis and design
Conceptual
(ER model)
Logical Database Design: Translation of ER diagram to a relational
database schema (description of tables)(Database Schema).
Physical Database Design: Done by the DB system.
Requirements
For actors and directors, we want to store their name, a unique
identification number, address and birthday (why not age?)
For actors, we also want to store a photograph
For films, we want to store the title, year of production and type
(thriller, comedy, etc.)
We want to know who directed and who acted in each film. Every film
has one director. We store the salary of each actor for each film
An actor can receive an award for his part in a film. We store
information about who got which award for which film, along with the
name of the award and year.
We also store the name and telephone number of the organization who
gave the award. Two different organizations can give an award with the
same name. A single organization does not give more than one award
with a particular name per year.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
