Please answer 1 & 2

This assignment is a review of relational database management systems (RDMS). Each scenario is considered complete with a proper data to information to knowledge diagram, which is an explanation of the chosen data housing declaration: completed data models via screenshots: and data construct with submitted code (tabulation and queries). Your constructs must run even if the housing scheme is inaccurate. Organize, model, tabulate (code and run) and test (query) all of the following scenarios: A club has many members and a person can be a member of many clubs. Each club has a president and a treasurer. One person can be the president or treasurer of more than one club. Design a database to track actors who have won an Oscar by movie and year. Movies can win many Oscars, actors can win several Oscars, and there are many Oscars awarded (e.g., best leading female actor). For movies, you want to include the type of movie (romance, action, comedy, etc.), the movie's title, the year it was released, its rating, and the movie's length. You should record the actor's name, gender and date of birth. For an particular type of Oscar you need to record its purpose (e.g., best foreign film) and the first year it was awarded