67%(3)2 out of 3 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
For this assignment, you will need to use the documentation for the BaseBall database found at the Baseball Database Documentationlink shown below. This document will tell you the tables and columns required for the following problems.Please submit the relational algebra answers to the following questions in a Word document, PDF or JPEG format. You should use the JPEG format if you are hand writing the answers. Please DO NOT submit the answer in SQL, only submit answers using the correct relational algebra symbols will be accepted. Any SQL submitted will be marked as incorrect. Questions1.Select yearid, lgid, teamid, playerid and the number of home runs (HR) from the BATTING table.2.Modify the query in #1 so it also shows the number of hits that were for “extra bases” and the batting average (H/AB). The Extra Bases column must be calculated by adding the following columns together (2B, 3B and HR). Rename the derived column Extra Base Hits.3.