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 810 total…

…showed last 75 words of 810 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/