ITS3102 South University Savannah SQL statements Report

  • Create a new Microsoft Access database named Travel. Note that Microsoft Access does not support the use of SQL scripts to create databases. In Microsoft Word, type the SQL script that you would have used to create the database.
  • Now, add a table named Car_Rental to the Travel database. Make sure that you include the Car_Rental_ID field whose datatype is AutoNumber. In Microsoft Word, type the SQL script that you would have used to create the table. Include the following fields:
    • Car_Rental_ID (AutoNumber, primary key, required)
    • Agency (Text(25), required)
    • Size (Text(25), required)
    • Make (Text(12), required)
    • Model (Text(25))
    • Daily_Cost (Currency)
  • Write INSERT statements for adding the following data to the new table:






Avis Mid Ford 89.95
Avis Full Ford Taurus 112.95
Hertz Comp Chev Cavalier 69.95
Hertz Mid Chev Malibu 84.99
Hertz Full Chev Impala 114.99
National Mid Chrys Stratus 77.95
National Full Chrys Intrepid 109.95
  • Verify the values inserted by using a query.
  • Display each distinct agency (each agency only once).
  • Display the average cost of a Chrysler rental.
  • Display the total count of cars available.
  • Display the highest-priced vehicle.
  • Display each unique agency with the average car price for that agency.
You can leave a response, or trackback from your own site.


11 Responses to “ITS3102 South University Savannah SQL statements Report”

  1. This really answered my problem, thank you!

  2. 873626 984353Most beneficial gentleman speeches and toasts are made to enliven supply accolade up to the wedding couple. Newbie audio system the attention of loud crowds really should always consider typically the excellent norm off presentation, which is their private. greatest man speaches 164856

  3. 872201 68189baby strollers with high traction rollers really should be significantly safer to use compared to those with plastic wheels- 751962

  4. 202096 428580Extremely clean web site , thanks for this post. 160337

  5. 643559 74301Hello there! I could have sworn Ive been to this blog before but right after checking by way of some of the post I realized its new to me. Anyhow, Im surely glad I identified it and Ill be bookmarking and checking back often! 892536

  6. 414724 4185The truth is and see if the Hcg diet protocol and as a consequence HCG Drops undoubtedly are a in fact quick way to be able to shed pounds; although the healthy diet has a strong will most likely moreover sizable focus to undertake positive. hcg diet drops 232668

  7. 788059 515907Yay google is my king aided me to discover this outstanding website! . 53587

  8. 935834 691332I got what you intend, saved to bookmarks , extremely decent web website . 209750

  9. 129372 960537Youve actually written a really very good quality post here. Thank you extremely a lot 636668

  10. relx says:

    388031 41329Great paintings! This really is the kind of information that really should be shared around the internet. Disgrace on Google for now not positioning this publish upper! Come on over and talk more than with my site . Thanks =) 250891

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes