Description

Write your roll number and name on the piece of paper where you have drawn the ER diagram and the database schema. Note, the ER Diagram and the database schema must be drawn on paper and NOT using any tool.
List of Queries:
1. List the players for each IIT sorted by IIT Name (IIT Name, Event Name, Player Id, Player Name).
2. List the players who have participated in at most two events (IIT Name, Player Id, Player Name).
3. List the players who have participated in one or more individual events but not in any team event sorted according to descending order of the number of individual events participated by him or her (Player Id, Player Name, IIT Name, Team Event Name).
4. List the players along with their total individual event points and total team event points in ascending order of their team event points and within that in descending order of their individual event points (Player Id, Player Name, Total Team Event Points, Total Individual Event Points).
5. List the teams that have scored more total team event points than total individual event points (IIT Name, Total Individual Event Points, Total Team Event Points).
Submit (a) A scanned copy of the piece of paper(s) where you have drawn the ER diagram and the database schema (b) A text file containing your Create & Select SQL statements (Name them as
Lab3_<Roll_no>_<serial_number> with appropriate extensions) through Moodle for Lab Day 3.