Multi-part question:
Part 1:
Use MySQL Workbench to create an EER model for a database...
![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 02.12.2020 07:20 lilque3448
Multi-part question:
Part 1:
Use MySQL Workbench to create an EER model for a database that stores information about the downloads that users make. (When you create the EER model, it will be given a default name of mydb. For this exercise, it’s not necessary to change this name.) Define the tables that are necessary to implement this data structure:
Each user must have an email address, first name, and last name.
Each user can have one or more downloads.
Each download must have a filename and download date/time.
Each product can be related to one or more downloads.
Each product must have a name.
When you’re done defining the tables, create a diagram for the database. Then, use the diagram to define the required relationships. When you do that, be sure to use the relationship button that uses existing columns.
Part 2:
Create a view named order_item_products that returns columns from the Orders, Order_Items, and Products tables.
This view should return these columns from the Orders table: order_id, order_date, tax_amount, and ship_date.
This view should return the product_name column from the Products table.
This view should return these columns from the Order_Items table: item_price, discount_amount, final_price (the discount amount subtracted from the item price), quantity, and item_total (the calculated total for the item).
Part 3:
Write a SELECT statement that uses the view that you created in part 2 to get total sales for the five best selling products. Sort the result set by the order_total column in descending sequence.
![ansver](/tpl/images/cats/User.png)
Answers: 3
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 00:30
Advantages and disadvantages of binary system
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 03:30
Hashtags serve to identify the topic of a given tweet true false
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 14:00
Technician a says that with self-adjusting clutch systems, the release bearing constantly rotates. technician b says that the ball bearing portion of the release bearing should be lubricated with high-temperature grease during routine maintenance. which technician is correct?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 11:30
Why is body language an important factor in a business meeting
Answers: 1
You know the right answer?
Questions
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 17.02.2021 18:00
![question](/tpl/images/cats/istoriya.png)
History, 17.02.2021 18:00
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/en.png)
English, 17.02.2021 18:00
![question](/tpl/images/cats/mat.png)
Mathematics, 17.02.2021 18:00
![question](/tpl/images/cats/ap.png)
Advanced Placement (AP), 17.02.2021 18:00
![question](/tpl/images/cats/en.png)
English, 17.02.2021 18:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 17.02.2021 18:00
![question](/tpl/images/cats/pravo.png)
Law, 17.02.2021 18:00
![question](/tpl/images/cats/mat.png)
Mathematics, 17.02.2021 18:00
![question](/tpl/images/cats/mat.png)
Mathematics, 17.02.2021 18:00
![question](/tpl/images/cats/istoriya.png)
History, 17.02.2021 18:00