|
SQL For Business: Auto-Shop Database
Title: SQL For Business: Auto-Shop Database
Category: Business & Economy / Management
Details: Words: 839 | Pages: 3.6 (approximately 235 words/page)
SQL For Business: Auto-Shop Database
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.
&…showed first 75 words of 839 total…
You are viewing only a small portion of the paper.
Please login or register to access the full copy.
|
|
…showed last 75 words of 839 total…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?
|
|
