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,
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). 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. b). 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. c. A firms sells clothes on consignment. Each article of clothing is given a price, a date it was given to the consignment shop, the type of clothing and the season when it is worn. For pants you need to also have the waist and inseam measurement, for shirts you need the neck and sleeve measurement. For skirts and dresses you just need the size. d. A soccer club has asked you to design its database. A soccer player plays on one and only one team. Each team has a team name and color. im not sure how to do any of this so if this could be done in my sql that would be great
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started