Design a database for the Oscars based on the following business rules

Design a database for the Oscars based on the following business rules

1. Each Oscar is given to one movie
2. Each movie can win many Oscars
3. Each Oscar is given in one category (best actor, best actress, best costumes, etc.)
4. Each category can have many winners (e.g. there can be several movies that win in the category “best director” through several years).

use an ERD drawn using smart draw or any diagramming tool.