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

21/11/2020 Client: papadok01 Deadline: 24 Hours

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:

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:

University Coursework Help
Quality Homework Helper
Best Coursework Help
Top Essay Tutor
Helping Hand
Homework Guru
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

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

$77 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

$77 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

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.

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

$80 Chat With Writer
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.

$75 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

$77 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

Average heart rate of daphnia magna - Data models and decisions exercise answers - How would you describe the organizational culture of your workplace - How to describe teaching experience - Salicylic acid and sodium hydroxide - Stewart fleming primary school - Chrome-extension //mhjfbmdgcfjbbpaeojofohoefgiehjai/index.html - Chap. 2 Q - Fundamental methods of mathematical economics 4th edition solutions pdf - Adam smith's concept of the invisible hand refers to - Mother any distance analysis - Long service leave act sa - Lisa harrison horse trainer - Discussion DQ3 - Po box 2848 melbourne 3001 - Sammy plant peas and corn dung a gully - Discussion - One example of neolithic myths are - Calculate the case mix index for this ms drg set - Ieee transactions template word - Free pragmatic language activities - Evaluate each function for the domain - Masters in social science ucc - Sarah ward radio presenter - Zara fast fashion harvard business school - Data mining - El calentamiento global no se va a parar hagamos algo. - Structural steel span tables answers - Unilever bangladesh distributor list - Louth county council planning - Fundamentals of organizational behaviour pdf download - Moreton bay regional council hall hire - Responsibilities of advanced practice nursing staff - Origin of the red cross emblem - Discussion - Access control Assignment 5 - Hell to the naw blues song - What shape is a parachute - Assignment Help - Theories and techniques of counseling corey - Edward's adoptive mother in twilight series crossword - 250 Cc Dirt Bike - Capital budgeting analysis is very important because it - Verizon Communications - What is an annotated outline - Old womanish anagram of liane - Eng 122 week 1 content quiz - Medical assistant code of ethics pdf - +91-8306951337 get your love back by vashikaran IN Maheshtala - Text response body paragraph example - Song c day lewis analysis - Www selectmysubject com au student - Childbirth positive feedback loop diagram - Health IT Benefits and Risks Reflection - Flood spa n deck distributors - Participant information sheet questionnaire - Foundation degree in person centred counselling - Advantages of core cutter method - Ankitar - Descriptive approach to problem solving - PLEASE FIRST READ THE QUESTIONS THEN BID, I NEED THIS QUESTIONS IN 15 HOURS, THIS MATHEMATICAL QUESTION BASE ON TELECOMMUNICATIONS - Direct shipper na tnt com - Computerized payroll accounting project answers - The practice of statistics 3rd edition chapter 2 answers - Cajas de carton chapter 4 summary - Toll ipec north geelong - Martinez company's relevant range of production - International juvenile justice observatory - British army lanyard colours - A smartart graphic consists of two parts: the smartart graphic itself and a(n) ____ pane. - Case Study 1 & 2 Lyme Disease and Peripheral Vascular Disease - The Institute of Medicine - Key performance indicators compliance function - Aquinas and augustine on the role of religion in government - What is the molar mass of the metal hydroxide - Vik muniz american flag - (1) Computer science C++ - A different species of cockroach has weights - Educ 200 quiz 1 - Construction project management essay - Tandberg 1700 mxp factory reset - Asic strike off action - Hum 100 project 1 artifact chart - Needed in 6 hours - Who is the tyrant 3000 miles away - Project management at arnold palmer hospital - Tina jones shadow health musculoskeletal - Eng 123 - Recent Supreme Court Rulings - The following are all methods of analyzing capital investments except - Mr christie chocolate wafers discontinued - Bortons model of reflection - Www enchantedlearning com explorers - How to write precis writing in english with examples - Decision Maerketing/Essential Business Communication - How to get cengage answers - An american roulette wheel has red slots - Requerimiento 1510 worksheet answers - British industrial revolution primary sources - Describe the management style at rondell data corporation