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

Stockholders may prefer dividends to reinvestment by the firm - Leadership theory application & skill development 5th ed - 2013 medicare levy surcharge threshold - Enterprise key management plan example - Hypothesis for projectile motion - Is wd 40 liquid flammable - Ilure lashes groupon - The great victorian desert - Ansi asq z1 4 2013 - Dimplex xt c asbestos - Calculate bmi in spss - Under what type of marketing does kliptech operate - Information paper - Majoring in psychology helms pdf - St augustine's primary school coffs harbour - Indicator lab answers - Uxbridge registry office parking - Tax return project solutions - Psychotherapy With Individuals - Mansell homes newton mearns - Reflective Journal 3 - Legal and Ethical Issues - Film segmentation example - Topic 5 DQ1 and DQ 2 - Aramark refreshment services locations - If you traveled west in a covered wagon - Alfred hitchcock magazine submissions - Soc 120 week 4 discussion 2 - Strain gauge factor derivation pdf - Is euglena a plant or an animal - Ceramic capacitor code 103 - By high accessibility requirements the internalist means - University of phoenix math 220 final exam - Keats king's college london - What are the three financial statements - Southwest airlines professional communications certification review answers - Proofreading - Business Administration - Hyponatremic hypochloremic metabolic acidosis - Organ Leader & Decision Making - Android malware detection on machine learning - Bioceuticals womens essentials chemist warehouse - Veeam one limited scope - Woolworths car insurance offer - Amanda todd summary - Captured lives australia's wartime internment camps - This is a Collaborative Learning Community (CLC) assignment. - Say it with symbols investigation 1.4 ace answers - Define the five promotion mix tools for communicating customer value - Balanced chemical formula for photosynthesis - Biflex ultra lo odour - Mcdonalds philippines case study - Gcse maths trigonometry revision - Purdue owl alphanumeric outline - Tommy hilfiger marketing mix - Concepts in enterprise resource planning 3rd edition - Summary of the tempest by william shakespeare - 58 blackadder road swan view - 47.5 as a fraction - Three forms of equity in reward strategy - Merv irvine nursing home - Swagelok ms htb 8 - The fool king lear quotes - Arms and cups checklist - Ford pats flash codes - Burger king application questionnaire answers - Business law and environment important questions - Things to be grateful for - O - Bjt dc analysis solved problems - W6 WORK - Hunger games symbolism worksheet - Advantages and disadvantages of margin of safety - University of the cumberlands blackboard - Airflow sunshine model 6600a - E coli on cled agar - Team diagnostic survey development of an instrument - Module_3 - How to write recommendation for report - Anatomy and physiology lesson plans - Cloud Computing - Cadillac desert mulholland's dream answers - Santa fe grill mexican restaurant case study - Computer science heriot watt - West indies island state crossword clue - Simple past tense stay - Cushenberry corporation had the following transactions. - Kingdom phylum class order family genus species - Bill nye electromagnetic spectrum worksheet - MUSIC PAPER - How ben franklin structured his day - A round character is one who - Production planning with sap apo - What is cb response sensor - Painful testimony assassin's creed odyssey - What is an integration paper - First fast food in malaysia - Questions about acids and bases - MK 405 Choose a popular video marketing campaign. Using the 'best practices for video marketing' discussion in your text as a guide, explain why you think the campaign was successful. Remember share a link for your example. - Discussion: Policy Proposals-WK6