Loading...

Messages

Proposals

Get Custom homework writing help and achieve A+ grades!

Custom writing help for your homework, Academic Paper and Assignments from Academic writers all over the world at Tutorsonspot round the clock.

Our promises:

  • Custom homework writing help
  • Plagiarism Free Solutions Guaranteed!
  • A+ Grade Guaranteed!
  • Privacy guaranteed!
  • Best prices guaranteed!
  • Timely delivery guaranteed!
  • Hundreds of Qualified Writers 24/7

write and execute the query that the dbms actually executes

Open Homework Posted by: papadok01 Posted on: 21/11/2020 Deadline: 24 Hours

18 writers want to do this homework:

George J.
Omar B.
Homework Mentor
Top Essay Writer
Helping Hand
Homework Guru
One Stop Tutor
Olivia H.
Ideas & Innovations
Finance Homework Help
Exam Solver
Smart Accountants
A Grade Exams
Accounting Homework Help
Peter O.
Instant Assignments
Calculation Guru
Financial Hub
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:

Open Homework

Project ID 755330
Category Mathematics & Physics
Subject Physics
Level PhD
Deadline 24 Hours
Budget $60-100 (2-5 Pages/ Short Assignment) Approx.
Required Skills Assignment Writing
Type Open For Bidding

How it Works (Full Video)

How to Hire an Academic Writer

How to Post Homework Question

Order Your Homework Today!

We have over 1500 academic writers ready and waiting to help you achieve academic success

Private and Confidential

Yours all information is private and confidential; it is not shared with any other party. So, no one will know that you have taken help for your Academic paper from us.

18 writers want to do this homework:


George J.

ONLINE

George J.

United States of America

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

Offer: $77

Omar B.

ONLINE

Omar B.

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

Offer: $77

Homework Mentor

ONLINE

Homework Mentor

Pakistan

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.

Offer: $75

Top Essay Writer

ONLINE

Top Essay Writer

United States of America

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.

Offer: $80

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.

Offer: $75

Homework Guru

ONLINE

Homework Guru

India

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

Offer: $77

One Stop Tutor

ONLINE

One Stop Tutor

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

Offer: $77

Olivia H.

ONLINE

Olivia H.

United Kingdom

Greetings! I’m very much interested to work on this project. I have read the details properly. I am a Professional Writer with over 5 years of experience, therefore, I can easily do this job. I will also provide you with TURNITIN PLAGIARISM REPORT. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks!

Offer: $70

Ideas & Innovations

ONLINE

Ideas & Innovations

Hi, Hope you are doing well. I can do this easily because I have several experiences to write articles on different web sites, creative content for several blogs & also SEO writing. Even I have written many kindle ebooks, Being a creative writer, I think I am the most eligible person for your Ghostwriting project. So lets make no longer delay & start chatting immediately.

Offer: $75

Finance Homework Help

ONLINE

Finance Homework Help

Australia

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

Offer: $70

Exam Solver

ONLINE

Exam Solver

United Kingdom

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

Offer: $70

Smart Accountants

ONLINE

Smart Accountants

India

I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in this industry since 2014 and I have served more than 1200 clients with a full amount of satisfaction.

Offer: $70

A Grade Exams

ONLINE

A Grade Exams

India

Hi, I have read the instructions carefully and I clearly understand what is required of the project. I always make sure I proofread and edit papers well to ensure they are free of typos, plagiarism, and grammar mistakes. Hire me for a timely delivery of a quality content.

Offer: $70

Accounting Homework Help

ONLINE

Accounting Homework Help

Bangladesh

I can help you with your homework & assignments to get A grade. I have helped several students multiple fields such as marketing, SWOT, PESTEL, Finance, Law, Sociology and Psychology. I know how to structure and format content with different writing styles such as MLA, APA, & Harvard. Please try me once at least. You will be satisfied.

Offer: $70

Peter O.

ONLINE

Peter O.

Australia

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

Offer: $70

Instant Assignments

ONLINE

Instant Assignments

Pakistan

Hey, I can write about your given topic according to the provided requirements. I have a few more questions to ask as if there is any specific instructions or deadline issue. I have already completed more than 250 academic papers, articles, and technical articles. I can provide you samples. I believe my capabilities would be perfect for your project. I can finish this job within the necessary interval. I have four years of experience in this field. If you want to give me the project I had be very happy to discuss this further and get started for you as soon as possible.

Offer: $70

Calculation Guru

ONLINE

Calculation Guru

India

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

Offer: $70

Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

Offer: $70

Ready To Place An Order? Its Free!

Homework Questions in Mathematics & Physics


sam kant appellate brief


mat 240 snhu


if x is binomial with n = 5 and p = 0.05, the chance that x is at least 1 is 0.6240


clp 1006


how many pounds of raw material are needed to make one unit of alpha and one unit of beta?


university of phoenix college algebra


qnt 561 week 3


Calculus


Hello, I wanted to know if you could help me with an assignment


stemplosion


mat 240 snhu


university of phoenix placement test


if x is binomial with n = 5 and p = 0.05, the chance that x is at least 1 is 0.6240


university of phoenix college algebra


qnt 561 week 3


unlike peru's coast ecuador's coastland consists of


helium at room temperature


heavenly chocolates website transactions


which fact is not used to prove that pqr is similar to str?


________ is the ratio of benefits to costs.


math 114 liberty university


explain why a linear function may not be adequate for describing the supply and demand functions.


HELLO how are you


NSCI 100- CALCULATIONS


a population of n = 6 scores has σx = 12 and σx2 = 54. what is the value of ss for this population?


which of the following is a valid objective function for a linear programming problem?


the probability distribution for the daily sales at michael's co. is given below.


what value is a discontinuity of x squared plus 5 x plus 2, all over x squared plus 2 x minus 35?


rainfall statistics visual basic


a researcher wishes to estimate with 95 confidence


calculate the arithmetic average returns for large-company stocks and t-bills over this period.


marshall rosenberg nonviolent communication pdf


mangoroot


math guru


which of the following represents the zeros of f(x) = 5x3 − 6x2 − 59x + 12?


which of the following is a valid objective function for a linear programming problem?


tangent galvanometer lab report


theory of bureaucratic caring


qnt 351 final exam


1.09 macbeth plot analysis quiz


scientific method essay


a barge floating in fresh water is shaped like a hollow rectangular prism


gcu code of conduct


evaluate the double integral. 7xy2 da, d is enclosed by x = 0 and x = 4 − y2 d


a fundamental distinction between trend projection and linear regression is that:


math 114 liberty university


linux zoo


Discussion Week 4


motion in two dimensions tutorial homework


the local supermarket buys lettuce each day