SQL project 1lvlupnow
Consider the multi-table third normal form (3NF) database specified in the file “Project 1 DDL.txt” attached. The database is used by an e-commerce website that sells a variety of products. Customers go to the web site, select products based on product categories and sets of product features, and fill a shopping cart with products that they want to buy. Later on, they place an order for one or more products that exist in the shopping cart. Once an order is placed, all the items that were bought are removed from the shopping cart and added to the ordered items table. The shopping cart has also the ability to hold products as part of a wish list, which the customer is interested in but hasn’t decided yet to buy.
Use the file “Project 1 DDL.txt” to study and understand the structure of this database. Use it also to create and populate the database on your personal Oracle account. Then generate SQL code to answer the following questions:
The second file attached (“Project 1 Results.txt”) contains the expected results for each of the queries. Try to make your queries match the content provided in this second file.
Use your Oracle account to run these SQL statements and verify correctness.
Submit the SQL statements as a text file following the document naming convention FirstLastP1.txt.
Grading: This project is awarded 100 points, as follows: 9 points each of the SQL queries between #1 and #10, and 10 points for SQL query #11.
- 6 years ago
- Batch 3 Remaining Work
- ECONOMICS Assignment
- ACC 205 Week 3 Exercise Assignment
- Halliday, Fundamentals of Physics, 10e 226s1s hwk#7
- FIN 515 Week 4 The Cost of Capital DQ 2
- EED 415 Week 3 DQ 1 and DQ 2
- Need help with Discussion Question Regarding Internal Validity
- D squared minus 196 over D+14
- Which of these does not fit with the others?
Create a PL/SQL program that handles the order placement for the application described in Project 1. When customer Newton decides to buy, all the items in his shopping cart that are …6 years ago