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

How much does an racv car inspection cost - 5.8 quadratic regression pumpkin tossing - Best practices in healthcare facilities capital planning - Eavan boland poems night feed - ETCM-RESEARCH-DISCUSS-7 - Research Paper: Server Virtualization and Cloud Computing - How much is 18 nickels - Regression analysis - Attention getter for alcoholism speech - How to calculate a theoretical yield - Similarities between scm crm and erp - Swot beer - Vocabulary - Discussion part 6 - Fluid mechanics course outline - Discussion on student loan please include 2 sources - Helios gene gun system - Www gcflearnfree org excel 2010 - Discussion paper - Douglas water treatment plant townsville - Which statement is incorrect about exception handling in blue prism - What criteria concerning moral judgments should we agree with - Peripheral route to persuasion advertising - Denton company manufactures and sells a single product - The timberlake jackson wardrobe co has 7 percent coupon bonds - Butcher yield test form - Horus and jesus parallels - Leadership Development Plan - Oral presentation marking rubric - Overstepped cafe lot 88 menu - English answer question - Abnormal psychology by susan nolen hoeksema pdf - 2400 word paper on Organizational Change in a Fortune 1,000 company - Warnerwoods company uses a perpetual inventory system. it entered into the following purchases - Techniques used in interpersonal psychotherapy - Who is the famous entrepreneur - Profissional Applied Project - Apa ethical guidelines animal research - Create a journal - Tsotsi chapter 5 summary - Five students took a math test - Assignment 1 bottling company case study - Kinetic study of an iodine clock reaction - Does gatsby die in chapter 8 - Grade a stamford ct weekly circular - Engineering test plan example - What is environmental scanning in management - Data mining : False discovery rate (FDR ) and relation ship between Type I and Type II errors - Covidien cherrywood business park - Three point charges are located on a circular arc - MANGAERIAL ECONOMICS - 3.55 km in miles - Primary consumers in the everglades - Double indemnity discussion questions - Magic quadrant for data center infrastructure management tools - The acronym tulip expresses what theological system - Types of beef production systems - Blanchard situational leadership model - Triangulation in ethnographic research - Ethical and religious directives for catholic health care services 2016 - 3-4 pages APA form - Searching for Evidence to Improve Nursing Outcomes - Legislative Matrix - 560 paper - Under armour goals and objectives - Woolworths demerger tax implications - Fe2 so3 3 name - Cruising show jumping stallion - Millivolt drop test formula - Events that make a conflict more difficult are called - What is the primary criterion for the preparation of managerial accounting reports? - Similarities and differences of motivating operations and discriminative stimuli - Disneyland informative speech - The logic of stupid poor people - Rob is responsible for estimating a work package - Burial at sea guide - Vip x1 xf e - How do fraction strips help - Onet online job descriptions - Fisherman's blues ukulele chords - Management Principles, Two Papers Each 2 And Half Min Pages Of Full Text - Fundamental principles of servant leadership in nursing - Operation management report on kfc - Jim brush key lime pie - Literature Review on Diabetes and high amount of sedentary lifestyle and lack of physical exercise can significantly increase the risk of diabetes. - Different types of text - Fire safing at slab edge - A single cash flow is also known as a - Mbti vs big 5 - The ecuadorian rose industry case study answers - Admission essay writing service - Rock paper scissors diagram - Discussion - Leadership styles - Wk 1 Individual Assignment - Create a Project Proposal [due Mon] - Sae oil viscosity temperature chart - Dr bonaminio oak lawn il - Tina jones comprehensive assessment pdf - Customer centered innovation map pdf - If the ka of a monoprotic weak acid is - Child support dodgers should go to jail