Database management Coursework

Undergraduate
Coursework
Miscellaneous
Pages 7 (1757 words)
Download 0
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');

Introduction


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
Not exactly what you need?

Related papers

Database Management System
The following assumptions are derived from the above diagram: 1. The pointer with arrow head shows the dependent variable and the pointer with no arrow head shows the determinant variable. 2. There are 3 functional dependencies as shown above in the diagram.
Database Information Systems Management
It is good practice during this phase of development to endure that the IS progressed to endure the desired benefits and it is bad practice to progress with the development if these desired benefits have not been realized.1 Fortunately in our project the benefits of the stakeholders had been define and benefits realized. These are important aspects of application development because they determine…
Database Management System
It is essential or the organization to develop an effective database system. Database is defines as a system, used to record and maintains data. The most important point to understand database is that database contains data and not necessarily information. The database is a collection of interrelated data, which can be used by one or more applications that it can be integrated and is stored in a…
DATABASE SYSTEMS COURSEWORK
This conceptual model depicts all the entities and their relations; it gives the overall picture and understanding of the system to a novice. This can also be called a logical model as it does not take into consideration any DBMS in mind and shows the logical association of the system.…
Database management Coursework
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);…
Database management
2B. The Relational model for the above ERD follows : CREATE TABLE players ( playerid number primary key, name varchar(30), bdate date, schoolid number references school(schoolid), yr_joined number, grad_school number references school(schoolid)
Database Management. MSSQL Server Database.
In this case the university requirements deal with a variety of services which requires their data to be stored in a database so that it can be successfully fetched and modified for performing a variety of functions. …