Database management - Coursework Example

Only on StudentShare

Extract of sample
Database management

select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between '01-Feb-2007' and '28-Feb-2007);
select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between #02/01/2007# and #02/28/2007#);
select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and month(OrderTbl.OrdDate)=2 and year(OrderTbl.OrdDate)=2007;
select distinct Product.ProdNo, Product.ProdName, Product.ProdPrice from Product, OrdLine, OrderTbl where Product.ProdNo = OrdLine.ProdNo and OrdLine.OrdNo = OrderTbl.OrdNo and OrderTbl.CustNo = 'C0954327' and (OrderTbl.OrdDate between '01-Jan-2007' and '31-Jan-2007');
select distinct Product.ProdNo, Product.ProdName, Product.ProdPrice from Product, OrdLine, OrderTbl where Product ...
Download paper

Summary

select Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustCity, Customer.CustBal from Customer where (Customer.CustCity = 'Denver' AND Customer.CustBal > 150) OR (Customer.CustCity = 'Seattle' AND Customer.CustBal > 300);
select Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer where Customer.CustNo in (select OrderTbl.CustNo from OrderTbl where OrderTbl.OrdDate between '01-Feb-2007' and '28-Feb-2007');
Author : bonitabogan

Related Essays

Database Management System
2 pages (502 words) Essay
Database Information Systems Management
10 pages (2510 words) Essay
DATABASE SYSTEMS COURSEWORK
6 pages (1506 words) Essay
Database Management. MSSQL Server Database.
3 pages (753 words) Essay
Database Management
2 pages (502 words) Research Paper
Got a tricky question? Receive an answer from students like you! Try us!