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

Hot shot engine heater - SUBJECT: Request for Reconsideration - The open window saki pdf - Bt lifetime super employer plan usi - Frs 102 transition date - Worlds of music 3rd edition - 8 steps decision making process example management - Hrp substrate western blot - Me talk pretty one day claim - Satanic verses study guide - Industry Analysis - Schedule of cost of goods sold template - Most reactive nonmetals on the periodic table - Consider a cylindrical specimen of some hypothetical metal alloy - 2 truths and a lie instructions - Where did the hand jive originate - An Organization's External Environment - Determining the pka of a weak acid titration - Discussion: Using the AD-AS Model to Explain Macroeconomic Fluctuations - Beowulf battle with grendel mother text - Geraldo no last name short story pdf - Conveyor belt project part 3 - Why did the math teacher open a window company - 650 word memo soc 350 - Siemens vibration monitoring system - White Collar Crime - Construct the indicated confidence interval for the population mean - How the hr function varies between organisations in different sectors - How to make activity relationship diagram - Asc 845 pwc - Chapter 8 web server hardware and software - Final Paper - Theory - Foreign body granuloma eye - Family theories foundations and applications pdf - Reliance r12 security system - The count of monte cristo lowell bair sparknotes - Maxim street family medical practice - A mineral consisting of a poisonous gas ionically bonded to an extremely reactive metal. - Preparation of a primary standard solution of potassium hydrogen phthalate - Ritz carlton target market - Emma jane austen sparknotes - Human resource management mcgraw hill test bank - Find acceleration due to gravity from slope of graph - What is a voluntary statement - Aluminium 6061 t6 properties pdf - Zen Buddhism - Assignment: Strategies, Review, Implementation - DOC690 MOD 1 - Explain the title - If your about biology than only reply please - Business Intelligence - Impulse energy drink nutrition facts - Empty nest syndrome scholarly articles - Artist gallery consignment agreement - Cultural Diversity (Case study) - 3 types of lever with examples - Theory of inventive problem solving - How to find ductility from stress strain curve - Globalization and public administration ppt - Act form 1874fpre answer explanations - Where to buy ultra thin keto - Case Study - Shaping and chaining reinforcement schedules and one trial learning - Password perfect match choices - Weston master v zero corrector - Abstract algebra dan saracino pdf - Peanut Butter Memo Revision - At the border 1979 poem analysis - Dfd diagram for online food ordering system - Kaplan's three stage model - Crisis case study each role 1 page - Modernity and social changes in europe - 26741 crestwood dr franklin mi 48025 - Mydb deutsche bank - Parallel programming projects with source code - Their eyes were watching god chapter 6 - Accounting II assignments - Analysis on the Threats Defense Argument - 2 page reflection paper - WEEK7-DISCUSSION-Enterprise Risk Management - Examples of miscommunication in movies - CELL PHONE USE WHILE DRIVING - George wyndham bin 999 merlot - What are business rules in database - Intro to Ethics Powerpoint Presentation - Missouri Can Company (MCC) case - Health Communication - SUBTITLES AND BULLET POINTS for JRN Media - Nursing diagnosis for gestational diabetes mellitus care plan - Deviated nasal septum nursing care plan - Types of sickle scalers - Wbs for restaurant project - Coca cola vs pepsi financial analysis 2013 - How does beowulf kill the dragon - Coaching delegating directing supporting - Responding - 6039 collins ave apt 635 - Conway game of life glider - Module 3 practice test