Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 2: Given a Relational Database (designed to store data about students competing in the programming contests) that consists of the following relations Student (login
Problem 2: Given a Relational Database (designed to store data about students competing in the programming contests) that consists of the following relations Student (login varchar, sname: varchar, university: varchar, grad year int) Constest (cname: varchar year int, location: varchar) Participated (login, cname) Author (aid: int, aname: varchar, compensation: int) Problem (pid; int pname: varchar, max score: int, aid) Scored (pid login, score: real) Contest Problems (cname, pid) Do the following using Azue SQL a) Use SQL statements to create the relations b) Populate the relations with using SQL statements with the given data posted on the class website c) Implement the SQL queries for the following 6. Find the names of problems for which more than 2 students attempted (scored any points, zero included) List the names of contests and total compensation paid to the authors for the problems used in those contests List the names of contests along with the maximum total (sum) score received by the best student for attempting problems (not necessarily all of them) in that contest. 7. 8. 9. For the authors who designed at least one problem for which all students who attempted it on average scored between 50% to 75% of maximum score, raise their compensation by 10%. Display the updated author table. 10. Delete students graduating in 2018. Display the updated students table. You will need to create a SQL file to store your SQL statements. This SQL file must have sql as its extension. You nmst also use Azure Portal or SQL Operations Studio to collect cropped screenshots of your query outputs and compile them into a single PDF file
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