Question: QUESTION 4 Answer (a), (b) and (c) Consider the following relational schema for a company: CUSTOMER (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode) ORDER (OrderID, OrderDate,

QUESTION 4 Answer (a), (b) and (c) Consider the following relational schema for a company: CUSTOMER (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode) ORDER (OrderID, OrderDate, CustomerID) ORDER-LINE (OrderID, ProductID, OrderedQuantity) PRODUCT (ProductID, ProductDescription, ProductFinish, ProductStandardPrice) The key attributes for the relations shown above are underlined, and other important attributes are included in each relation. The primary key for ORDER-LINE is a composite key consisting of the attributes OrderID and ProductID. Also, CustomerID is a foreign key in the ORDER relation. ORDER-LINE has two foreign keys: OrderID and ProductID. Write SQL queries to answer the following: (a) Write statements to create all the tables from relational schema described above. Select appropriate data types for each attribute. Remember to set the primary and foreign keys. (16 marks) (b) Write a query to list all orders (order id and its date) submitted by a customer with id cus0019 since 1st of December 2016. (4 marks) (c) List the total ordered quantity of all orders by each customer while considering only the customers who ordered more than 65.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A Hi, I wrote mySQL and it is not working, could you send me the queries to see where I am wrong.? Thanks QUESTION 4 Answer (a), (b) and (c) Consider the following relational schema for a company:...

DROP TABLE OrderLine_T CASCADE CONSTRAINTS ; DROP TABLE Product_T CASCADE CONSTRAINTS ; DROP TABLE Order_T CASCADE CONSTRAINTS ; DROP TABLE Customer_T CASCADE CONSTRAINTS ; CREATE TABLE Customer_T...

here is the table structure DROP TABLE Order_line_t CASCADE CONSTRAINTS ; DROP TABLE PRODUCT_t CASCADE CONSTRAINTS ; DROP TABLE ORDER_t CASCADE CONSTRAINTS ; DROP TABLE CUSTOMER_t CASCADE CONSTRAINTS...

Need help with this project. Deliverable 1. Simple SQL Statements Use the Pine Valley database to answer each of the questions. Each question within deliverable 2 must begin on a new page and be sure...

Use the db_pvfc12_big database in Teradata SQL Assistant. Create a .SQL file that provides queries to the following Problems in the textbook: 10) 5-69. For every product that has been ordered,...

Need help with this project. Deliverable 1. Simple SQL Statements Book Pine Valley Furniture Company (PVFC) Datasets Customer_T CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState,...

Use the db_pvfc12_big database in Teradata SQL Assistant. Create a .SQL file that provides queries to the following Problems in the textbook: 15) 5-74. For each payment made on or after March 10,...

Entity Relationship Diagram S_Customer_T PK Customer_ID Customer_Name Customer_Address Customer_City Customer_State Postal Code S_Order_T OPK Order_ID Order_Date FK Customer_ID S_Product_T PK...

Write a query that selects for every customer, the number of orders he has places and the number of items he has bought, including zeros for customers with no orders. Using the query above populate...

I Need questions 1-5. Thank you! -- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database --...

A stock currently trades at a price of $100. The stock price can go up 10 percent or down 15 percent. The risk-free rate is 6.5 percent for the period.?Use a one-period binomial model to calculate...

This is not this is not this is not

Using Excel, create a template that provides information about various financial ratios. In your template, please include at least two (2) ratios within each type/category of ratios . Include the...

Forecasting lost sales case study

Your firm will soon be replacing the desktop telephones used by its 47 employees.The unit thats being considered accommodates three features in addition to voice mail and call forwarding.The plan is...

Teamwork. As directed by your instructor, complete one or more of the following activities: a. Form teams to develop a questionnaire that could be used to survey student opinions on the availability...

Review the online or print copy of a corporations annual report. Prepare an outline of the report using its major headings and subheadings as your guide. Submit your outline to your instructor....