SQL For Business: Auto-Shop Database
View Paper
ESSAY DETAILS
Words: 810
Pages: 3
(approximately 235 words/page)
Pages: 3
(approximately 235 words/page)
Essay Database > Business & Economy > Management
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
Sign up for EssayTask and enjoy a huge collection of student essays, term papers and research papers. Improve your grade with our unique database!
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/
…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/
