Image Long Description This image is an entity-relationship…
Questions
Imаge Lоng Descriptiоn This imаge is аn entity-relatiоnship diagram (ERD) for a movie review system, visually displaying five database tables—director, movie, rating, reviewer, and genre—and how they interrelate through their attributes and foreign keys. Director Primary Key id Attributes dir_firstName dir_last Relationships One-to-many relationship with movie Movie Primary Key id Attributes mov_title mov_year mov_time mov_lang mov_dt_rel mov_rel_country Foreign Keys gen_id dir_id Relationships Many-to-one relationship with director One-to-many relationship with rating Many-to-one relationship with genre Genre Primary Key id Attributes gen_title Relationships One-to-many relationship with movie Rating (Junction Table) Primary Key (Composite) rev_id (foreign key) mov_id (foreign key) Attributes rev_rating Relationships Many-to-one relationship with movie Many-to-one relationship with reviewer Reviewer Primary Key id Attributes rev_name Relationships One-to-many relationship with rating