Contains a new field called Profit which is calculated at run time. This field will subtract the purchase price from the sale price

computer science

Description

Produce a new extract from all the data in the stationary table that: 

 Contains a new field called Profit which is calculated at run time. This field will subtract the purchase price from the sale price 

 Contains a new field called Percent to calculate the percentage profit for each car at run time. This field will divide the profit by the sale price 

 Contains a new field called UnitProfit. This field will divide the profit by the quantity. 

For each calculated field show how you performed the calculation and the results of the calculation Save the database using your last name_first name_CT6 and take a screen shot to show performed task.


Related Questions in computer science category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.