Messages
Proposals
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
MSAccess - Assignment 2 – Chapter 4 Worksheet (86 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.
The Entity Relationship Diagram (ERD) for the Colonial Adventure Tours database is shown below. You need this diagram to know the table and attribute names.
1. (4 pts) List the guide number, last name, first name and hire date of each guide. Mod1218
Put your SQL command and your results here:
2. (4 pts) List the trip name of each trip that has the type Biking.
Put your SQL command and your results here:
3. (4 pts) List the last name and state of each guide that lives in Massachusetts (MA).
Put your SQL command and your results here:
4. (4 pts) List the last name and state of each guide that does NOT live in Massachusetts (MA).
Put your SQL command and your results here:
5. (4 pts) List the trip name and distance of each trip that has the type Hiking and that has a distance longer than 10 miles.
Put your SQL command and your results here:
6. (4 pts) You are interested in a biking trip in the early fall for more than 10 individuals. List all the columns for those trips that meet your requirements.
Put your SQL command and your results here:
7. (4 pts) List the reservation ID and trip price of those reservations that have a trip price that is greater than or equal to $40 but less than or equal to $60.
Put your SQL command and your results here:
8. (4 pts) List the customer number, customer last name, customer first name , city and state of each customer that lives in New Jersey (NJ), New York (NY) or Pennsylvania (PA). Use the IN operator in your command.
.
Put your SQL command and your results here:
9. (4 pts) Repeat the previous question and sort the records by state in ascending order and then by customer last name in descending order.
Put your SQL command and your results here:
10. (4 pts) How many trips are in the state of Massachusetts (MA)?
Put your SQL command and your results here:
11. (4 pts) How many trips originate in each state?
Put your SQL command and your results here:
12. (4 pts) Find the name of each trip containing the word “ Pond ”.
Put your SQL command and your results here:
13. (4 pts) Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result by the number of persons included in the reservation. List the reservation ID, trip ID, customer number, number of persons and total price for all reservations where the number of persons is greater than four. Use the column name TOTAL_PRICE for the calculated field.
Put your SQL command and your results here:
14. (4 pts) List the guide’s last name, first name and hire date for all guides that were hired before June 10, 2013. Order your results by the hire date.
Put your SQL command and your results here:
15. (4 pts) What is the minimum distance and maximum distance for each type of trip?
Put your SQL command and your results here:
16. (4 pts) Display the different seasons in which trips are offered. List each season only once.
Put your SQL command and your results here:
17. (4 pts) List the trip IDs for paddling trips.
Put your SQL command and your results here:
18. (4 pts) List the reservation IDs for reservations that are for a paddling trip. You must use a subquery.
Put your SQL command and your results here:
19. (4 pts) What is the total number of persons for all reservations.
Put your SQL command and your results here:
20. (10 pts) On this last question you will be writing your own question and generating the SQL command to answer that question. In addition to the typical SELECT clause and FROM clause you must also include a WHERE clause with an AND clause. Have fun with this one.
Put your question here:
Put your SQL command and your results here:
MSAccess
-
Assignment 2
–
Chapter 4
Worksheet
(86 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 runnin
g that command in your response to
each question.
Take advantage of the “
Hints
” that accompany each question.
The Entity Relationship Diagram (ERD) for the
Colonial Adventure Tours database is shown below.
You
need this
diagram to know the table and attribute names.
MSAccess - Assignment 2 – Chapter 4 Worksheet (86 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.
The Entity Relationship Diagram (ERD) for the Colonial Adventure Tours database is shown below. You
need this diagram to know the table and attribute names.
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
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! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
Custom Coursework ServiceHey, 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. |
$70 | Chat With Writer |
ONLINE |
Finance Homework HelpI 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! |
$70 | Chat With Writer |
ONLINE |
Instant AssignmentsHey, 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. |
$70 | Chat With Writer |
ONLINE |
Calculation GuruI 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. |
$70 | Chat With Writer |
ONLINE |
Financial HubHey, 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! |
$70 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.