SQL statements and SQL script 1

    0

    This assignment has two parts:
    Part IHands-on Lab
    For the hands-on lab you will submit a Microsoft Access database and a Microsoft Word document with SQL statements for the following:
    Agency
    Size
    Make
    Model
    Daily_Cost
    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
    Part IICourse Project
    Course Project Part 4Creating a Database
    Continuing with the project you worked on for Weeks 1 2 and 3 this week complete the following tasks:
    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.
    Submission Details
    Name your document SU_ITS3102_W4_A2_LastName_FirstInitial.doc.
    Name the Travel database SU_ITS3102_W4_A2_LastName_FirstInitial_Travel.accdb.
    Assignment 2 Grading Criteria
    Maximum Points
    Created a database named Travel and added a table named Car_Rental. Also added a column named Car_Rental_ID to the Car_Rental table and set its field type to AutoNumber.
    5
    Completed the INSERT statements for adding the given data to the Car_Rental table and verified the values inserted.
    5
    Wrote accurate SQL statements to:
    15

                                                                                                                                      Order Now