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

Database management - Coursework Example

Only on StudentShare
Undergraduate
Author : bonitabogan
Coursework
Miscellaneous
Pages 7 (1757 words)

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');

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

Related Essays

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 actions of business and IT management.…
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. 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)
Database Management
As technology grows, data is generated and collected at a much faster rate. However, its management has always been an arduous process and has never kept up the pace. Therefore, new methods of searching, sorting, and storing huge raw data in a more meaningful way are needed. Storage is cheap but its chances of repeated utilization make it more valuable than the rest of the saved information. Businesses and companies are more worried about storing the ‘Bad Data’ and thus allocating more money to ensure data quality and its consistency in the long term.…
2 pages (502 words)