Database Consider a database for an online store with the following tables. (You can find the ER-Model on Canvas.) - Pri

[answerhappygod]

Database Consider A Database For An Online Store With The Following Tables You Can Find The Er Model On Canvas Pri 1 (57.06 KiB) Viewed 81 times

Database Consider a database for an online store with the following tables. (You can find the ER-Model on Canvas.) - Price (prodID, from, price) - Product (prodID, name, quantity) - PO (prodID, orderID, amount) - Order (orderID, date, address, status, trackingNum- ber, custID, shipID) - Shipping (shipID, company, time, price) - Customer (custID, name) - Address (addrID, custID, address) Problems Implement the following queries in SQL. a) Determine the IDs and names of all products that were ordered with 2-day shipping or faster. b) The IDs of all products never ordered. c) The IDs of all products ordered by customers with the name John only using 1-day shipping (i.e., no customer John has ever used other shipping for these products). Submission Write your implementation in a single .sql-file and upload it to Canvas. This is an individual assignment. Therefore, a submission is required from each student.