where CustomerID not in ( select CustomerID from Customer_T)
select Order_T.OrderID, Order_T.CustomerID, Order_T.OrderDate,
Product_T.ProductID, Product_T.ProductDescription, OrderLine_T.OrderedQuantity
select CustomerName, CustomerID
where CustomerID not in
(Select CustomerID from Order_T)
select O.OrderID, CustomerID, OrderDate, ProductDescription
from OrderLine_T OL, Order_T O, Product_T P
where O.OrderID = OL.OrderID
select CustomerName, CustomerPostalCode
where CustomerState = "CA" or CustomerState = "WA"
order by CustomerPostalCode desc
select ProductID, sum(OrderQuantity) as "TotalOrdered"
group by ProductID
order by sum(Ord
Tutorial for Use with Fundamentals 12/e and Concise 6/e
This tutorial was developed for use with Brigham and Houstons Fundamentals of
Financial Management, 12/e and Concise, 6/e, especially Chapter 5, the Time Value of
Money. The cal
Yes they are balanced as it clearly shows the system boundaries and the internal processes. It
also shows the path in which the data flows as well as where they are stored within the system.