Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Write and execute the query that the dbms actually executes

18/12/2020 Client: saad24vbs Deadline: 14 Days

MSAccess - Assignment 4 – Chapter 7 (90 pts)


Instructions : Add your SQL command and results (using copy/paste and screen capture) to each question. Do NOT remove any existing content or images from this file. You MUST include both your SQL Command and Results from running that command in your response to each question.


Take advantage of the “Hints” that accompany each question.


1. Create a query named MAINE_TRIPS. It consists of the trip ID, trip name, start location,


distance, maximum group size, type, and season for every trip located in Maine (ME). Mod1218


a. (4 pts) Write and execute the query that lists the trip ID, trip name, start location,distance, maximum group size, type, and season for every trip located in Maine (ME). This is a simple SELECT statement using one table. After your SELECT statement returns correct results save your query as MAINE_TRIPS.




Put your SQL command and results here:


b. (5 pts) Using the MAINE_TRIPS query write and execute the command to retrieve the trip ID, trip name, and distance for every Biking trip.




Put your SQL command and results here:


c. (5 pts) Write and execute the query that the MSAccess DBMS actually executes.




Put your SQL command and results here:


2. Create a query named RESERVATION_CUSTOMER that consists of the reservation ID, trip ID, trip date, customer number, customer last name, customer first name, and phone number.


a. (4 pts) Write and execute the SELECT command to create the RESERVATION_CUSTOMER query. This is a multiple table query involving the RESERVATION table and the CUSTOMER table. After your SELECT statement returns correct results save your query as RESERVATION_CUSTOMER.




Put your SQL command and results here:


b. (5 pts) Using the RESERVATION_CUSTOMER query write and execute the command to retrieve the reservation ID, trip ID, trip date, and customer last name for every with a trip date of September 11, 2016.




Put your SQL command and results here:


c. (5 pts) Write and execute the query that the MSAccess DBMS actually executes.




Put your SQL command and results here:


3. COMPLETE, but do not execute, the commands to grant the following privileges. The section “Security” in your eBook (Chapter 7, page 204) contains a number of related examples on the GRANT command.


a. (4 pts) User Rodriquez must be able to retrieve data from the TRIP table. Complete the following SQL command:


GRANT SELECT ON ???? TO ????;


b. (4 pts) Users Gomez and Liston must be able to add new reservations and customers to the database. Complete the following two SQL commands:


GRANT INSERT ON ???? TO ????, ????;


GRANT INSERT ON ???? TO ????, ????;


c. (4 pts) Users Andrews and Zimmer must be able to change the price of any trip. Complete the following SQL command:


GRANT UPDATE (????) ON ???? TO ????, ????;


d. (4 pts) All users must be able to retrieve the trip name, start location, distance and type for every trip. Complete the following SQL command:


GRANT SELECT (????, ????, ????, ????) ON ????


TO ????;


e. (4 pts) User Golden must be able to add and delete guides. Complete the following two SQL commands:


GRANT INSERT ON ???? TO ????;


GRANT DELETE ON ???? TO ????;


f. (4 pts) User Andrews must be able to create an index for the TRIP table. Complete the following SQL command:


GRANT INDEX ON ???? TO ????;


g. (4 pts) Users Andrews and Golden must be able to change the structure of the CUSTOMER table. Complete the following SQL command:


GRANT ALTER ON ???? TO ????, ????;


h. (4 pts) User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDES tables. Complete the following three SQL commands:


GRANT ALL ON ???? TO ????;


GRANT ALL ON ???? TO ????;


GRANT ALL ON ???? TO ????;


4. (3 pts) COMPLETE, but do not execute, the command to revoke all privileges from user Andrews. Complete the following SQL command:


REVOKE ALL PRIVILEGES FROM ????;


5. COMPLETE, but do not execute, the commands to create the following indexes. The section “Security” in your eBook (Chapter 7, page 209) contains a number of related examples on the INDEX command.


a. (3 pts) Create an index named TRIP_INDEX1 on the TRIP_NAME column in the TRIP


table. Complete the following SQL command:


CREATE INDEX ???? ON TRIP(????);


b. (3 pts) Create an index named TRIP_INDEX2 on the TYPE column in the TRIP table. Complete the following SQL command:


CREATE INDEX ???? ON TRIP(????);


c. (3 pts) Create an index named TRIP_INDEX3 on the LAST_NAME and FIRST_NAME


columns in the CUSTOMER table. Complete the following SQL command:


CREATE INDEX ???? ON ????(????, ????);


6. (3 pts) COMPLETE, but do not execute, the commands to delete the index named BOOK_INDEX3. Complete the following SQL command:


DROP INDEX ????;


7. COMPLETE, but do not execute, the commands to obtain the following information from the system catalog. The section “System Catalog” in your eBook (Chapter 7, page 212) contains a number of related examples on the SQL commands that obtain information from the system catalog. Please note that all SQL examples in the this section of the eBook obtain information from “DBA” tables. In all of the following questions “DBA” has been changed to “ALL” in order to allow your SQL commands to execute properly.


a. (3 pts) List every column (i.e., COLUMN_NAME) in the GUIDE table and its associated data type (i.e., DATA_TYPE)


.


Put your SQL command here: Do NOT run this SQL command.


b. (3 pts) List every table (i.e. TABLE_NAME) that contains a column (i.e., COLUMN_NAME) that is named TRIP_ID.




Put your SQL command here: Do NOT run this SQL command.


c. (3 pts) List the table name, column name, and data type for the columns named TRIP_ID and TRIP_NAME. Order the results by table name within column name. (That is, column name is the major sort key and table name is the minor sort key.)




Put your SQL command here: Do NOT run this SQL command.


8. (3 pts) COMPLETE, but do not execute, the following ALTER command that adds the CUSTOMER_NUM column as a foreign key in the RESERVATION table. Complete the following SQL command:


ALTER TABLE RESERVATION


ADD FOREIGN KEY (CUSTOMER_NUM) REFERENCES CUSTOMER(????????_???);


9. (3 pts) COMPLETE, but do not execute, the following ALTER command that ensures that the TYPE column in the TRIP table can accept only values of Biking, Hiking or Paddling. Complete the following SQL command:


ALTER TABLE ????


ADD CHECK (TYPE IN ('??????', '??????', '????????'));


MSAccess


-


Assignment 4




Chapter 7


(90 pts)


Instructions


:


Add your SQL


command


and results (


using copy/paste and screen capture


) to each


question.


Do NOT


remove


any existing content or images from this file.


You


MUST


include both your


SQL


C


ommand


and


Results


from running that command in your response to each question.


Take advantage of the “


Hints


” that accompany each question.


1.


Create a


query


named MAINE_TRIPS. It consists of the trip ID, trip name, start location,


distance, maximum group size,


type, and season for every trip located in Maine (ME)


.


Mod1218


a.


(


4


pts)


Write and execute the


query


that lists the trip ID,


trip name, start


location,distance, maximum group size, type, and season for every trip located in Maine


(ME).


This is a simple


SELECT statement using one table.


After


your SELECT statement


returns correct results


save


your query as


MAINE_TRIPS


.


Put your SQL command and results here:


b.


(


5


pts)


Using the MAINE_TRIPS query w


rite and execute the command to retrieve the


trip


ID, trip name, and distance for


every Biking trip


.


Put your SQL command and results here:


MSAccess - Assignment 4 – Chapter 7 (90 pts)


Instructions: Add your SQL command and results (using copy/paste and screen capture) to each


question. Do NOT remove any existing content or images from this file. You MUST include both your SQL


Command and Results from running that command in your response to each question.


Take advantage of the “Hints” that accompany each question.


1. Create a query named MAINE_TRIPS. It consists of the trip ID, trip name, start location,


distance, maximum group size, type, and season for every trip located in Maine (ME). Mod1218


a. (4 pts) Write and execute the query that lists the trip ID, trip name, start


location,distance, maximum group size, type, and season for every trip located in Maine


(ME). This is a simple SELECT statement using one table. After your SELECT statement


returns correct results save your query as MAINE_TRIPS.


Put your SQL command and results here:


b. (5 pts) Using the MAINE_TRIPS query write and execute the command to retrieve the


trip ID, trip name, and distance for every Biking trip.


Put your SQL command and results here:


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
University Coursework Help
Top Essay Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$230 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$232 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$235 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

American english file 2 answer key pdf - The times complete history of the world 9th edition pdf - Titanic boiler room flooding - The test scores of 32 students are listed below - Biointeractive csi wildlife answer key - Lee v lee's air farming ltd - Vnx5600 hardware information guide - Boy at the window poem analysis - Chegg discrete mathematics with applications 5th edition - Rias gifted test sample questions - Structural steel quality control checklist - A barge floating in fresh water is shaped like a hollow rectangular prism - I need 2000 words content written in website - 7 kestrel court invermay park - The power of the zoot chapter summary - Discussion - One acre fund case study - John young biography book - The five major environmental forces in a marketing decision are - 250 words homework (within 24 hours): Budgeting Concepts and Process - Stan cherelstein - How does hipaa affect medical assistants - Baines avenue maternity list - Acc 291 week 2 wileyplus answers - Lab Assignment - Chapter 26 the great west and the agricultural revolution answers - 2 price controls in the florida orange market - Draw the structure of 3 3 dimethylpentane - Which of the following best represents psychology's basic goals - Was jesus born in south africa - Cube root of 16 - Group properties in organizational behaviour - Both rdp and tq share the idea that - Experiment 1 effects of ph on radish seed germination - The baltimore waltz play pdf - The purpose of the pledge of allegiance - Trichomonas - Week 15 Discussion - Research project - The mean value of land and buildings per acre - Molar extinction coefficient symbol - Agree to time frames for carrying out workplace instructions - ___________ is primarily a performer's art form - 510 Week 7 Board Discussion and Bill Paper - Boyle's law lab report answers - Ring size 56 in letters - Cybersecurity Awareness Campaign - Dr aydin huq hospitalized - Discuss how science plays a crucial role in many courtrooms? - Rostan line dancing canberra - Nursing Leadership and Management - Sumanasinc cellular respiration - Liberty university transcript evaluation - How to make your own totem pole - Mature age student deakin - Essay - Pico question examples stroke - Phat katz tattoo colonial heights - Topic sentence - Coastal medical center case study - 18 steen crescent pooraka sa 5095 - Oct 31,2020 - French role play script - Consider porter's value chain and the holistic marketing orientation model - ET Act1 - Class in america gregory mantsios analysis - Compare Displaced Persons (Plagiarism Checked) Submit Assignment - From bottom to top how one provider retooled its collections - West campus apartments ferris state - Merv irvine nursing home - One dollar equals how many swiss francs - Using samples of 200 credit card statements - Arts and Culture - Why didn t dexter want a pocket calculator - Hiii - The espresso lane to global markets cage analysis - Particle theory of matter grade 7 - Retrospect powerpoint theme download - They say i say 4 edition - Spat test of articulation - CHRISTIAN SERVANT LEADERS - Walmart vision center whittlesey columbus ga - His 100 multimedia presentation - How to write emotive language - Chem 101 core concepts in chemistry textbook - Product development - Post its notes on a marriage summary - Critique on nutrition and pregnancy - Cough focused assessment - Chew & chiu chartered accountants - University of greenwich extenuating circumstances - Macro political risk events examples - Http phet colorado edu en simulation circuit construction kit dc - Nuestra raza gang - Algebraic number theory solutions - Apriori algorithm example in r - Jacob kounin theory - Mcgraw hill action potential - Principles of Macroeconomics - International Foods Case Study