Columbia Pictures Inc. is a film production house. It has the following rules: An actor is identified by a first name, l

[answerhappygod]

Columbia Pictures Inc. is a film productionhouse. It has the following rules:
An actor is identified by a first name, lastname, gender, (add a new attribute)
A film is identified by a title, a language, acategory and has a duration, (add a new attribute)
A producer is identified by a first name, and alast name (add a new attribute)
For each film, anactor is assigned arole.
This list of attributes is not exhaustive. You need to addone attribute for each entity.
Designing the logical data model of the system:ERD
Design the entity-relation diagram (ERD) and specify all thecardinalitie
Respecting the third normal form, design the physicaldata model (RDM)
1. Identify (from the logical data model) the
2. Design the relational data model showing all thecharacteristics and identifying primary and foreign keys, and thenmap the relationships with their cardinalities