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

Remember the maine worksheet answers

18/10/2021 Client: muhammad11 Deadline: 2 Day

Assignment

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?

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:

Top Grade Essay
Instant Assignment Writer
Assignment Hut
Ideas & Innovations
Finance Homework Help
Top Grade Tutor
Writer Writer Name Offer Chat
Top Grade Essay

ONLINE

Top Grade Essay

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

$39 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$31 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$32 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$44 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

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.

$16 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

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

Primary objective of financial accounting - Purpose of the assessment (with ULO Mapping) - Sinners in the hands of an angry god cliff notes - Ocr guidelines for the cms 1500 claim form state - Order dulux powder coat samples - Discussion Post - Dr seuss anapestic tetrameter - Magnetic field inside a solenoid carrying current - Invitrogen zero blunt pcr cloning kit - Bourne again shell meaning - Elearn pstcc - Mixing two primary colors produces a ________ color - Distribution channel adopted by avon - Ot dmx rgb dim - Peas for automated taxi driver - Cost of the merchandise sold schedule first-in, first-out method portable dvd players - Behavioral theory of leadership - Hcr-20 v3 scoring sheet - Ftp swfwmd state fl us - Mullineaux corporation has a target capital structure - Draw the structure of dimethylethyl cyclopentane - 7 attributes of a symptom mnemonic - Reading the american past documents answers - Best buy income statement and balance sheet - This supernatural soliciting cannot be ill - Business intelligence-report 3 - Fran cubberley - Accounting generally has the responsibility for - Sales discount is what type of account - What color does potassium iodide burn - Slu banner self service - Wk3/dis/reply/wm - Battle of milvian bridge primary source - Pre commencement site inspection checklist for building - Acrostic poem for teamwork - Difference between academic text and non academic text - Chemical equilibrium and le chatelier's principle lab report answers - Power point - How information technology impacts family eldercare and parenting issues - What are the four main branches of earth science - Mla possessive names ending in s - Parable of the lost sheep meaning - Reverse tick on ecg - Main idea of me talk pretty one day - Sodium hydroxide + hydrochloric acid word equation - Aws direct connect mtu - Liv watts on hard quiz - Microarray analysis allows researchers to examine which of the following - How to start investing at 16 - Ats time clock manual - Topical reference list - Masters in social science ucc - The basic practice of statistics 8th edition slader - Breaking night quotes with page numbers - Another one bites the dust superbowl commercial - HR business case essay- 5 Pages in length. Follow directions or I will DISPUTE for REFUND - Distance Learning Facilitator Training Response - Vnxe3200 latest firmware version - Define the following terms answer - Literature for composition 11th edition pdf - Average formal charge on oxygen in po - Ted talks anatomy and physiology - Examples of emotive language - Infinite automation systems aircrete - Why is the narrator in billy collins marginalia so tickled - Calculate the heat of vaporization of water - Why are mathematicians like airlines answer key 164 - After watching the video clip, answer the following questions: - Graphic studio gallery dublin - Body wisdom light touch for optimal health - Case study search engines in global business - Ole miss management information systems - HCA320 Assignment Mod 3: - Urica test - Ariba punchout implementation guide - Casey nelson is a divisional manager - Common themes in luke and acts - Earth continuity extension lead - Unnatural balance accounting - Sociology observation assignment - Sharp essay examples - Bsbmgt608 manage innovation and continuous improvement assessment task 2 project - Angus young gibson les paul - 8 PAGES DUE BY 48 HOURS - Dior meaning in swahili - Lyrics circle of life - 7.2 3.7 lab troubleshooting advanced eigrp - Colour of sodium bicarbonate on ph paper - Environmental science reading assignment climate refugees answers - Brisbane city council footpath permit - Comptia security+ guide to network security fundamentals edition 6 - Ambridge institute - Bachelor of multimedia design uq - Helpyourmath sign in - Kill command rotten tomatoes - Foreigners dancing on tunak tunak - Ib math ia structure - Business and Economic Forecasting - Discussion Response(A24) - Benefits as well as the challenges associated with Big Data Analytics for Manufacturing Internet of Things.