Please help with this assignment.

Aug 3rd, 2015
KateS
Category:
Computer Science
Price: $40 USD

Question description

For the hands-on lab, you will submit a Microsoft Access database and a Microsoft Word document with SQL statements for the following:

  • 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:


  • Agency

    Size

    Make

    Model

    Daily_Cost

    AvisMidFord89.95
    AvisFullFordTaurus112.95
    HertzCompChevCavalier69.95
    HertzMidChevMalibu84.99
    HertzFullChevImpala114.99
    NationalMidChrysStratus77.95
    NationalFullChrysIntrepid109.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.

Part II—Course Project

Course Project Part 4—Creating a Database

Continuing with the project you worked on for Weeks 1, 2 and 3, this week, complete the following tasks:

  • In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables.
  • Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.

Assignment Deliverable

After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document. Include the SQL scripts in the Microsoft Word document. Include the Travel database as a separate attachment.

SU_ITS3102_W3_A2_Whitley_B.docx SU_ITS3102_W3_A2_Whitley_B.mht 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Duke University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
Five Star Tutor
Dec 3rd, 2016
" Outstanding Job!!!! "
SjSurvivor143
Nov 18th, 2016
" Thanks for the help. "
Joemoe
Nov 4th, 2016
" <3 it, thanks for saving me time. "
tinytim47
Oct 26th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
pmallory
Oct 22nd, 2016
" Totally impressed with results!! :-) "
mixedballz
Oct 13th, 2016
" excellent work as always thanks for the help "
kiln82
Sep 29th, 2016
" awesome work thanks "
darnay
Sep 20th, 2016
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors