Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Relational Algebra / Calculus Given the following database scheme: CUSTOMER ( Cust# , Cust _ Name, Cust _ City ) ORDER ( Order# , Ord
Relational Algebra Calculus
Given the following database scheme:
CUSTOMER Cust# CustName, CustCity
ORDER Order# OrdDate, Cust# OrdAmt
ORDERITEM Order# Item# Qty
ITEM Item# ItemName, UnitPrice
SHIPMENT Order# Warehouse# ShipDate
WAREHOUSE Warehouse# WarehouseCity
WAREHOUSEITEM Item# Warehouse# Qty
Write down relational expressions either relational algebra or relational calculus for the following queries.
a List the Order# and ShipDate for all orders shipped from Warehouse#
b List Order# OrdDate and ShipDate for orders which have not been shipped Hint: items are not shipped if
shipdate is null
c Produce a list of Item# that is not found in any warehouse in Melbourne.
d List Item# and ItemName that are stored in all warehouses in Sydney.
e List the Cname and City of the customers who have ordered the most in terms of money
give me the answer in a proffesional manner by adding all the steps not just writing the answer and no plagarism please every question need clear explanation thankyou
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started