Question: Consider the same entity relationship model which is given the second video on A Relational View of Data and assume that you are given a
Consider the same entity relationship model which is given the second video on A Relational View of Data and assume that you are given a consumer review dataset below. (a) Determine which of the dataset: transaction, customer, order, or work center, should include customer reviews and explain why, Or, if you think that customer reviews should have its own dataset explain why, again. (1 point) (b) Based on your answer in (a), draw the entity relationship model ( 2 points) Question 2 In Foundations of Structured Quecy Language, some of the existing questions that we can address them by queries are covered, such as: - Who are the most profitable customers? - Where usually do most profitable customers locate in terms of region? - Do most profitable customers face any delay? - How many customers face delay in East region? - What are the overtime records (in hours) at shipping date when orders are delayed? - When orders are delayed what is the average delay cost? In one paragraph describe the use of SQL in your company (or a company of your choice) and give two questions that can be easily solved with SQL commands. (3 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
