Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions

Question

Find the exact value of expression. tan 7/12

Answered: 1 week ago

Question

What is the most important part of any HCM Project Map and why?

Answered: 1 week ago