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

River riding math worksheet answer

06/12/2021 Client: muhammad11 Deadline: 2 Day

Assignment 1 – Worksheet (120 pts)

Instructions: This Worksheet consists of 13 questions. You may answer each of the first 11 questions using the Colonial Adventure Tours data shown in Figures 1-4 through 1-8 in your eBook. You will find it easier to use the “Colonial Adventure Tours Table.xlsx” Excel file which contains the contents of all five tables. You can copy and paste your answers from the Excel file into this Worksheet. Note: When you paste a value from the Excel file to this Worksheet use the “A” option as shown below:

No computer work is required. The answer to question #1 has been completed for you.

1. List the first and last name of each guide that lives in Maine (ME). Note: There is only one (1) guide.

FIRST_NAME

LAST_NAME

Hal

Rowan

2. (8 pts) List the trip name of each trip that has a maximum group size of greater than 16. Note: There is only one (1) trip. Mod1218

TRIP_NAME

Sawyer River Ride

3. (8 pts) List the trip name and distance of each trip that has the type Hiking and that has a distance longer than 10 miles. Note: There is only one (1) trip.

TRIP_NAME

TRIP_DISTANCE

Sawyer River Ride

16

4. (8 pts) List the trip ID and trip name of each trip that has the type Biking and that has the season Early Fall. Note: There are exactly four (4) trips .

TRIP_ID

TRIP_NAME

5. (8 pts) How many trips have the type Hiking?

6. (8 pts) List the trip name of each trip that has Hal Rowan as a guide. Note: There are exactly five (5) trips .

Hint: Consider starting with the GUIDE table and locate Hal Rowan’s GUIDE_NUM data value. Using that GUIDE_NUM data value look at the TRIP_GUIDES table and locate those records that contain that GUIDE_NUM. You will find five (5) records. The TRIP_ID values of those five (5) records can be used to identify the TRIP_NAMEs in the TRIP table.

TRIP_NAME

7. (8 pts) Find the name of each trip containing the word Loop. Note: There are exactly two (2) trips .

TRIP_NAME

8. (8 pts) List the first and last name of each guide who lives in Maine (ME), Vermont (VT), or Connecticut (CT). Note: There are exactly three (3) guides .

FIRST_NAME

LAST_NAME

9. (8 pts) How many reservations are for trips that occur during July 2016?

10. (8 pts) List the last name of each customer that has a reservation for a trip in Massachusetts (MA). Note: There are exactly two (2) customers. It turns out that one of the customers happens to have reservations for two separate trips. Just list that customer’s last name once.

Hint: Consider starting with the TRIP table to locate those trips in Massachusetts (MA). Then use the RESERVATION table to locate the reservations for those Massachusetts trips. Make note of the customer numbers assocated with the reservations. Finally use the CUSTOMER table to identify the last name of the two customers.

LAST_NAME

11. (8 pts) How many reservations have a trip price that is greater than $15.00 and less than $40.00?

12. (20 pts) You are designing a database that is meant to contain information about books and their authors. Your initial design produced a single table, BOOK, that contains 7 attributes. Shown below is the un-normalized BOOK table with 7 attributes.

BOOK (BOOK_ID, TITLE, IS_HARDCOVER, PRICE, AUTHOR_ID,

FIRST_NAME, LAST_NAME)

After spending more time on the design of the BOOK database you recognize that your un-normalized BOOK table contains both Book information as well as Author information. You need to break up the un-normalized BOOK table (with its 7 attributes) into two separate tables, BOOK and AUTHOR, in order to make your design consistent with 3rd normal form.

Your task is to complete the design of your database in 3rd normal form (using shorthand notation) by replacing each ???? with the appropriate attribute name. Note: Remember in shorthand notation, primary keys are underlined.

BOOK ( ???? , ???? , ???? , ???? )

AUTHOR ( ???? , ???? , ???? )

Complete the functional dependencies of these two tables by replacing each ???? with the appropriate attribute name :

BOOK_ID ???? , ???? , ????

AUTHOR_ID ???? , ????

13. (20 pts) The Colonial Adventure Tours ERD (Entitiy Relationship Diagram with its five (5) tables and list of attributes is shown below. Notice that the CUSTOMER table is missing its list of attribute names.

Your task is to replace the eight ????s in the CUSTOMER table shown below with eight attribute names. These attribute names can be obtained from Figure 1-6 of your eBook or the Excel spreadsheet you used to complete the first 11 questions of this Assignment.

CUSTOMER

????

????

????

????

????

????

????

????

Assignment 1

Worksheet

(120 pts)

Instructions

:

This Worksheet consists of 13 questions

.

You may a

nswer each of the first 11

questions using

the Colonial Adventure Tours data shown in Figures 1

-

4 through 1

-

8 in your eBook.

You will find it easier

to use

the “Colonial Adventure Tours Table.xlsx” Excel file which contains the contents of all five tables.

Y

ou can copy and paste your answers from the Excel file into this Worksheet.

Note:

When you paste a

value

from the Excel file to this Worksheet use the “A” option as shown below:

No computer work is required.

The answer to question #1 has been completed for you.

1.

List the first and last name of each guide that lives in Maine (ME).

Note

: There is only one (1)

guide.

FIRST_NAME

LAST_NAME

Hal

Rowan

2.

(8 pts)

List the trip name of each trip that has a maximum group size of greater than 16.

Note

: There is

only one (1)

trip

.

Mod1218

TRIP_NAME

Sawyer River Ride

3.

(8 pts)

List the

trip name

and distance

of each

trip that has the type Hiking and that has a distance longer

than 10 miles

.

Note

: There is only one (1)

trip

.

TRIP_NAME

TRIP_DISTANCE

Sawyer River Ride

16

4.

(8 pts)

List the trip ID and trip name of each trip that has the type Biking and that has

the season Early Fall

.

Note

: There are exactly four (4

)

trips

.

TRIP_ID

TRIP_NAME

5.

(8 pts)

How many trips have the type Hiking?

6.

(8 pts)

List the trip name of each trip that has Hal Rowan as a guide.

Note

: There are exactly

five (5

)

trips

.

Assignment 1 – Worksheet (120 pts)

Instructions: This Worksheet consists of 13 questions. You may answer each of the first 11 questions using

the Colonial Adventure Tours data shown in Figures 1-4 through 1-8 in your eBook. You will find it easier

to use the “Colonial Adventure Tours Table.xlsx” Excel file which contains the contents of all five tables.

You can copy and paste your answers from the Excel file into this Worksheet. Note: When you paste a value

from the Excel file to this Worksheet use the “A” option as shown below:

No computer work is required. The answer to question #1 has been completed for you.

1. List the first and last name of each guide that lives in Maine (ME). Note: There is only one (1) guide.

FIRST_NAME LAST_NAME

Hal Rowan

2. (8 pts) List the trip name of each trip that has a maximum group size of greater than 16. Note: There is

only one (1) trip. Mod1218

TRIP_NAME

Sawyer River Ride

3. (8 pts) List the trip name and distance of each trip that has the type Hiking and that has a distance longer

than 10 miles. Note: There is only one (1) trip.

TRIP_NAME TRIP_DISTANCE

Sawyer River Ride 16

4. (8 pts) List the trip ID and trip name of each trip that has the type Biking and that has the season Early Fall.

Note: There are exactly four (4) trips.

TRIP_ID TRIP_NAME

5. (8 pts) How many trips have the type Hiking?

6. (8 pts) List the trip name of each trip that has Hal Rowan as a guide. Note: There are exactly five (5) trips.

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:

Solution Provider
Top Rated Expert
Homework Tutor
Instant Assignment Writer
Engineering Exam Guru
Helping Hand
Writer Writer Name Offer Chat
Solution Provider

ONLINE

Solution Provider

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$34 Chat With Writer
Top Rated Expert

ONLINE

Top Rated Expert

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$29 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$24 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$45 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$43 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

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

Charges and fields phet lab answers - Nomenclature lab - Mcguire research text amazon gift card - Havant borough council garden waste - Car allowance rebate system cars - St martin's guide to writing 11th edition pdf download - Kno3 dissolved in water - Compared to the purely competitive firm a pure monopoly - Econ 214 problem set 5 - Let the part play you pdf - Writing Assignment: Media Analysis - A disorder caused by hyposecretion from the thyroid gland is - I need a discussion following this instruction - Emotional uplifting orchestral osu - Homework on third degree price discrimination - Different types of text - Qbcc passive fire licence - What is a key element to mapping out an organizational structure? - Yum or yuck worksheet answers - Iliad book 6 greek - How would you describe mcdonald's business strategy - What is the net electric potential at point p - What makes a good investigator - The lady of shalott explanation - Week 6 Discussion 1 Physiology and Pathophysiology - Dmu academic calendar 2018 19 - W6PsychT - Weak acid weak base conductivity curve - Http mpsweb intranet mps - The boarded window by ambrose bierce - Readings in the western humanities 7th edition - Pan recipe john agard poem analysis - Stimulus discrimination consumer behavior - Statistics in business qnt 275 - A firm sells its product in a perfectly competitive - Ohio scientific computer for sale - Multifactor leadership questionnaire rater form mlq rater form - How much does a gallon of milk weigh in kilograms - Practical connection paper -Analyzing & Visualizing Data - What happens to co2 in the calvin cycle - What is strategy porter 1996 - Types of strategic fit - Laureate online education amsterdam - Tcc portsmouth admissions office - Strategic Analysis - Failing Company - Smooth criminal riff tab - Computer science - Myhealth va gov sign in - Css225 final project - Schedule ca 540 line 37 column b instructions - 350 words min - Please attach the plagiarism report - Fully developed flow equation - Can you recycle batiste dry shampoo - Through the arc of the rainforest sparknotes - Health behavior theory third edition - Why does uv intensity change with latitude - Business model and competitive strategy of ikea in india pdf - How do you name a binary acid - City of yarra kindergarten - Nail client consultation form - How to write an exegesis philosophy - Shakespeare true or false - Persuasive speech on yoga outline - What is relation between cp and cv - Quick analysis totals gallery in excel - Raf pay scales 20 21 - 619 cal young road hallsville tx - A single price monopolist - Charles sturt university timetable - Graphing tangent functions worksheet - Miller and levine biology 7.2 answers - Bridgewater bay to sorrento walk - Animal habitat poster project - Franchise Valuation - Mens kilts for sale - Goulburn ovens institute of tafe - Criminology - Contemporary issues in society - Visio 2013 crow's foot database notation - Work order numbering system - Extensive property and intensive property difference - Algebraic fractions corbett maths - Baxter video products sales are expected - List of informative speech topics - Blue wave sd card - Emergency department process flow chart - Discussion - Volcanoes and Climate Article - What is pontchartrain food - Eng Writing Assgn 3 - Project management simulation scope resources and schedule solution - How to install simulink - Jack wills interview questions - Daffodils poem by william wordsworth - A company's resources and capabilities represent - Capital rationing may be imposed because of all of the following except - Intercultural Management - Organizational Structure of the United Nations Human Rights Council - 0.457 as a fraction - Management information system book by james o brien - U.S. Health Care Systems for Small Populations, Part 1