This assignment is a review of relational database management systems (RDMS). Ea

Question

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 1. 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 2. 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

Explanation / Answer

2. Design of tables

CREATE TABLE Movie (
Movie_Name VARCHAR(30),
year_Of_Release INT,
Type_Of_Movie VARCHAR(15),
Rating INT,
Length INT,
Actor_Name VARCHAR(30),
Gender VARCHAR(10),
Date_Of_Birth DATE,
PRIMARY KEY (Movie_Name,year_Of_Release)
);

CREATE TABLE Oscar
( Movie_Name VARCHAR(30),
Year INT,
Award_Type VARCHAR(30),
Winner_Name VARCHAR(30),
Purpose VARCHAR(30),
FOREIGN KEY (Movie_Name,Year)REFERENCES Movie(Movie_Name,Year_Of_Release)
);

This is the table design.then next what you need is pls comment. your question is not clear.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---