Database mangment using the RelaX relational algebra calculator.

dbis-uibk.github.io/relax/calc.htm

Writing Relational Algebra expressions Tools you will use: The RelaXrelational algebra calculator at the link The database named Database Systems The Complete Book- Exercise 2.4.3 from the site above Description Introduction To complete this exercise, you will use RelaX, the relational algebra algebra calculator at the following web site: [link is here]. For all the questions, you will use the database named Database Systems The Complete Book - Exercise 2.4.3. For each of the questions below, you will provide an answer by entering the corresponding relational algebra into RelaX and excuting it. You will take a screenshot, and name the screenshot according to the instructions in each question below. Save al of your screenshots into a directory called homework1. For these questions, you will not use any aggregate functions, order by, group by, division, left outer join, right outer join, full outer join, theta join, or left or right semi- join. If you use any of these operators, you will either lose points or obtain zero points for the question. Also, answer each question as if you had no knowledge of what data is stored in the tables, although you can use the knowledge obtained by investigating the database's structure Problems The total number of points available on this assignment is 31. The final grade will be on a 100 point scale according to the formula (points earned 100)/(total points) For this problem, you will write two relational algebra queries that each show all information in the ships table. For the first query, use the projection operator. For the other query, do not use the projection operator. Include a Screenshot for each query. You may use any the following operators, but not necessarily all, in 1. Writing Relational Algebra expressions Tools you will use: The RelaXrelational algebra calculator at the link The database named Database Systems The Complete Book- Exercise 2.4.3 from the site above Description Introduction To complete this exercise, you will use RelaX, the relational algebra algebra calculator at the following web site: [link is here]. For all the questions, you will use the database named Database Systems The Complete Book - Exercise 2.4.3. For each of the questions below, you will provide an answer by entering the corresponding relational algebra into RelaX and excuting it. You will take a screenshot, and name the screenshot according to the instructions in each question below. Save al of your screenshots into a directory called homework1. For these questions, you will not use any aggregate functions, order by, group by, division, left outer join, right outer join, full outer join, theta join, or left or right semi- join. If you use any of these operators, you will either lose points or obtain zero points for the question. Also, answer each question as if you had no knowledge of what data is stored in the tables, although you can use the knowledge obtained by investigating the database's structure Problems The total number of points available on this assignment is 31. The final grade will be on a 100 point scale according to the formula (points earned 100)/(total points) For this problem, you will write two relational algebra queries that each show all information in the ships table. For the first query, use the projection operator. For the other query, do not use the projection operator. Include a Screenshot for each query. You may use any the following operators, but not necessarily all, in 1