StudentShare solutions
Got a tricky question? Receive an answer from students like you! Try us!

Coursework example - Database management

Only on StudentShare
Undergraduate
Coursework
Miscellaneous
Pages 7 (1757 words)
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');

Extract of sample


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.
2 pages (502 words)
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…
10 pages (2510 words)
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.…
6 pages (1506 words)
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)
1 pages (251 words)
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. …
3 pages (753 words)