(Please include your webuser name and password in the submission)
In this assignment, you are required to create tables in your PostgreSQL database using the sample data from Figure 2.22 (pp. 56). The schema information can be found in Exercise 2.3.2 (pp. 37).
Notice that there are some “dangling tuples” in this dataset, e.g., ships mentioned in Outcomes that are not mentioned in Ships. You cannot assume that every ship has a class.
(NOTE: Your SQL queries must pass the compiler check or 0 point will be awarded.
Avoid
using ‘distinct’ unless it is absolutely necessary!)
1. Textbook: pp. 279, Exercise 6.3.2 (b) and (e) (24 pts).
(You need to provide two significantly different SQL queries for each subquestion and each query should include a subquery.)
2. Textbook: pp. 290, Exercise 6.4.7. (60pts)
Submit the queries in text form and the results in screenshot form
(Please include your webuser name and password in the submission) In this assignment, you are required to create tables in your PostgreSQL database using the sample data from Figure 2.22 (pp. 56). The schema information can be found in Exercise 2.3.2 (pp. 37). Notice that there are some “dangling tuples” in this dataset, e.g., ships mentioned in Outcomes that are not mentioned in Ships. You cannot assume that every ship has a class. (NOTE: Your SQL queries must pass the compiler check or 0 point will be awarded. Avoid using ‘distinct’ unless it is absolutely necessary!) 1. Textbook: pp. 279, Exercise 6.3.2 (b) and (e) (24 pts). (You need to provide two significantly different SQL queries for each subquestion and each query should include a subquery.) 2. Textbook: pp. 290, Exercise 6.4.7. (60pts) Submit the queries in text form and the results in screenshot form.