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 ...Show more

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
Database management Coursework essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the coursework on your topic
"Database management Coursework"
with a personal 20% discount.
Grab the best paper

Related Essays

Performance Management Coursework
A healthcare company named Bromley Healthcare is considered in this paper as a case and a critical review of its human resource management has been made. The performance management system with specific emphasis on 360 degree appraisal method has been aligned to the work culture of the said company.
16 pages (4000 words) Coursework
Management Change Coursework
This is because it involves sensitive implementation of well thought out strategies, consultation and involvement of majority of employees. Moreover, the process is costly and involves a great deal of risk taking. This change is brought forth by various aspects that pull down the capabilities of an organisation as well as its performance (McCarthy, 2003).
4 pages (1000 words) Coursework
Coursework on Change Management
Hence change is subjective. The Phenomena of change are equally applicable to the field of enterprises and management organizations. Though at times the change cannot be reverted, in such situations the best solution is to adopt a strategy that meets the requirements in mitigating the effect of change.
3 pages (750 words) Coursework
Database
To enhance the security of the database, several key concepts have to be looked at and properly set. This enhances maximum operation and security of the database. First, the issue of access control should take center stage while discussing the security concepts.
5 pages (1250 words) Coursework
Supply Chain Management Coursework
Based on the supply chain framework the necessity of examining and evaluating the competencies of the supply chain partners and forming a strategic alliance with them for attaining a sustainable competitive advantage is explained in the paper. The necessity for change in the organisational culture for bringing out the effectiveness of the supply chain management is also discussed.
22 pages (5500 words) Coursework
Hotel Management Coursework
This towering hotel offers a wonderful view of this elegant part of the city with excellent service providers that are ready to provide the best of the service round the clock. Cutting an impressive landmark out of the native sandstone of the area, Hotel City Park offers travelers a new level of luxury with the distinctive personalizedtouchand impeccable hospitality of International standard.
14 pages (3500 words) Coursework
International Marketing Management Coursework
As a result, economic interdependence and interaction between countries are becoming ever stronger. In this massive tide of economic globalisation, no country can develop and prosper in isolation. China has learnt from her long history that isolation leads to backwardness.
30 pages (7500 words) Coursework
Strategic Management Coursework
(European Contact Center Blog, October 2007). Performance is a matter of keeping up an organisation's image - this is the basis of understanding the nature and causes of attrition within Lloyds TSB. In this regard, the literature I have made use of is exhaustive.
36 pages (9000 words) Coursework
Project management coursework
So, total cost of the project was £14.7 billion over a 13 year period. The first three years utilised £2.3 billion with x% of the work completed. For the revised project, we eliminate x% of the work to get another complete
6 pages (1500 words) Coursework
Coursework Management (Discussion Questions)
The author states that Mexican-American history spans more than 400 years and varies from region to region within the United States. Approximately ten percent of the current Mexican-American population are descended from the early colonial settlers; their families claim hundreds of years' residency in the country.
3 pages (750 words) Coursework
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT