Question: Please answer the questions using relational algebra. Customer ( CID , firstname, lastname, street, city, state, zip) Product ( PID , Pname, category, description, unit-price)

Please answer the questions using relational algebra.

Customer (CID, firstname, lastname, street, city, state, zip)

Product (PID, Pname, category, description, unit-price)

ActiveOrders (OrderNo, CID, dollar-amount, order-date, ship-date)

OrderHistory (OrderNo, CID, dollar-amount, order-date, delivery-date)

OrderDetails (OrderNo, PID, quantity)

Primary keys are in bold

ActiveOrders= information about the company currently active orders that are either being processed or being shipped

OrderHistory= past orders that have been delivered

OrderDetails= details each active and past order

1. List the id and name of the products for which David Jones has currently placed order(s).

2. Find the id and name of the customers that currently do not have any orders.

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!

Q:

Please answer the questions below i have written the table and necessarry information. please do check 1. Show c_id, order date, ship date, and paid date from ORDERS table. The "c_id" is a column for...

Q:

This is a sub query write the code in subquery Please answer the questions below i have written the table and necessary information. please do check 1. Show c_id, order date, ship date, and paid date...

Q:

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

Q:

Delete any companies with missing data for AT, SALE, IB Using Your industry (from question title), please answer these questions using Fiscal year 2015 data, use Total Assets (AT) for average...

Q:

Population Source Level of Consolidation - Company Annual Descript Data Format STD STD STD ISO Currency Code USD USD USD CAD STD USD Global Company Key Data Date Data Year - Fisca Industry Forn 6821...

Q:

Please answer the questions using the first page !! Please answer all questions as an external advisor to the Board of Trustees based on the first page Problems in the University Scheduling and...

Q:

Describe three ways information systems could be used to address the coronavirus outbreak. Use your creativity and don't restrict yourself to the possibilities identified in the article. Final Exam...

Q:

Please answer the questions using the case described below. To answer the questions, use the cost data provided on pages 9 to 10. Congratulations on being hired as the new estimator for AIH Paving...

Q:

Industry 2082, Delete any companies with missing data for AT, SALE, IB Using Your industry (from question title), please answer these questions using Fiscal year 2015 data, use Total Assets (AT) for...

Q:

Chapter 5: The Binomial Randoni Variable Please answer all questions using the appropriate version of the Assignment dataset as assigned by your TA. Each graph must be labeled with a dataset as...

Q:

Reconsider Prob. 568. Using EES (or other) software, investigate the effect of the exit pressure of steam on the exit temperature after throttling. Let the exit pressure vary from 6 to 1 MPa. Plot...

Q:

Using the data provided in P8-15, calculate the overhead cost variances for each department using the three-variance method.

Q:

The income from a sole proprietorship is filed on which tax form? Group of answer choices Schedule K - 1 , Form 1 0 6 5 . Form 1 1 2 0 - S . Form 1 1 2 0 . Schedule C , Form 1 0 4 0 .

Q:

WRITE IN C#: Creating and catching Exceptions Homework In this homework, you will add code in your Car class definition to detect bad situations and throw exceptions when these occur. Do not put...