Essay Database
SQL For Business: Auto-Shop Database
Date Submitted: 09/10/2006 06:16:26
Category: / Business & Economy / Management
Length: 3 pages (810 words)
Category: / Business & Economy / Management
Length: 3 pages (810 words)
SQL For Business: Auto-Shop Database
<Tab/>Unquestionably, Nogales Auto-Shop Database (NASD) was intended to upgrade from a paper based system to a software management database. Essentially, the data captured for the five tables ranges from customer's personal information, vehicles unique characteristics, part/operation inventory, work order history, to work order item definition. Altogether, the data being capture will smooth the retrieving of information in the form of queries and reports.
&…
Is this Essay helpful? Join now to read this particular paper
and access over 800,000 just like this GET BETTER GRADES
and access over 800,000 just like this GET BETTER GRADES
…WorkOrderItem
Where Customers.CustID = WorkOrder.CustID
And WorkOrderItem.WOI = WorkOrder.WOI
And WorkOrderItem.PartsOperation = PartOperation.PartsOperation
And WorkOrderItem.Labor = WorkOrderItem.Labor
6) Group cars from older to newer
Select Model, Make, CarYear
From Vehicle
Group by CarYear, Make, Model;
All in all, the queries were tested and up this point the project was successful.
<Tab/>
References
Pratt, P. J. (2003). A guide to SQL. : . Retrieved July 29, 2006, from http://ecampus.phoenix.edu/eBookLibrary/content/
Need a custom written paper? Let our professional writers save your time.
Need an original paper?
