Reference for Question 4

Sales Database:

Customer(custId, lastName, firstName, address, phone, creditLimit)

Order(orderNumber, date, total, custId)

LineItem(orderNumber, itemNumber, qtyOrdered)

Item(itemNumber, itemName, price)

For the Sales Database in the reference, write the relational algebra expression for the query

Find the names and addresses of all customers who have ever ordered item 12345.