Verify the values inserted by using a query

Assignment Help Database Management System

Reference no: EM13803895

Part I-Hands-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:

- 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
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.

Reference no: EM13803895

Questions Cloud

Write essay on a motivational person such as michelle obama : Write an essay on a motivational person such as Michelle Obama.

What are advantages and disadvantages of political influence : How do you measure political influence. What are the advantages and disadvantages of political influence. Is the shaping of public opinion by external influences good or bad for effective financial policy implementation. Why or why not

Wirte essay on anna karenin as polemic and madame bovary : Wirte 3 pages essay for me based on Leo Tolstoy's novel Anna Karenin as Polemic with the novel of Gustave Falubert's Madame Bovary.

Examples of target populations : Review your list of local city and state agencies (or the two agencies you compared) and select a target population. Examples of target populations are the poor, unemployed, children, elderly, people with disabilities, persons with mental illness,..

Verify the values inserted by using a query : Write INSERT statements for adding the following data to the new table: Verify the values inserted by using a query. Display each distinct agency (each agency only once)

Operational efficiency : •You are to succinctly define in your own words the phrases "operational efficiency", "operational effectiveness", "operations strategy" and "operational sustainability"•Further, you are to address "Six Sigma," and comment on its applicability and va..

Write an anonymous block that places a substitution variable : Write an anonymous block that places a substitution variable (&) into a local variable of type varchar2. You will need to convert the types and round them to nearest tens unit

Local electronic store provides customers with walk-in : Q: A local electronic store provides customers with walk-in service to repair their flat screen TVs of various technologies (LCD, LED, Plasma, etc.). When an item arrives, store technicians perform basic tests at the test shop (station 1) and decide ..

Analyze the impact of international policy making : Analyze the impact of international policy making on the current year's budgets and possible impact on future budget line items. (Title this section Implications of Foreign Policy.

User Account

All Pages