Question
Creating Tables:a.For the Sales Invoice, Purchase Order,and Service Invoice, review the business document and determine which attributes are stored in the Sale Invoice table, which
Creating Tables:a.For the Sales Invoice, Purchase Order,and Service Invoice, review the business document and determine which attributes are stored in the Sale Invoice table, which ones are derived (and only show up in views) and which come from other tables. b.Car Sellers attributes: company name,contact name, street, city, state, zip, phone, fax.Create 5 car sellers.2.Quality Control Check List:a.Include reasonable CHECK, NOT NULL constraints.b.Reference integrity as appropriate RUNNING THE BUSINESS...USING DML statements, do the following steps for each businesstransaction:Comments: Vary who the salesagent is. Have one customer buy more than one vehicle. 3.Steps in buying a new vehicle ... add at least fivenew purchases(ideally each personin your team would conduct 2 or 3 transactionsfor this and each of the following business events).a.Add new vehicle to Sales Tableb.Add new POc.Update PO with the manager who approves the purchase (note, this means that the manager approval FK is not required when the new PO is created, so modify your CREATE TABLE statement to allow NULLs.)4.Steps in selling a car ...sell 5 cars,3 with trade-ins, 2 without a trade-in.a.Add Customer to Customer table as needed.b.If customer is bringing in a trade in, add this vehicle to the Sales Vehicle table.Set status as TRADEIN.c.If creating a PO for trade-ins:i.Using an INSERT/SELECT subquery statement (see example in SQL book chapter on DML), copy customer data to the Car Seller table.ii.Add new PO.d.Add new Sales Invoice.e.Update Sales Invoice for approval by Larry (or by sales manager). f.Update status of vehicle sold to go from FORSALE to SOLD.g.Update status of vehicle traded in from TRADEIN to FORSALE.5.Steps in servicing a car ...service at least 6 cars, three whichwere ones we sold and three which havenot been sold by us.Have oneof the service invoices beforonly one service, saya tire rotation. Have one of the service invoices be foronly one part, saya quart of oil. Have one of the service invoices be foronlyone part and only one service. Have the other three services include multipleservices and parts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started