Order ID |
53563633773 |
Type |
Essay |
Writer Level |
Masters |
Style |
APA |
Sources/References |
4 |
Perfect Number of Pages to Order |
5-10 Pages |
Description/Paper Instructions
Colonial Adventure Tours Assignment
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.
- 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 |
- (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 |
- (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 |
- (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.
- (8 pts) How many trips have the type Hiking?
- (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.
- (8 pts) Find the name of each trip containing the word Loop. Note: There are exactly two (2) trips.
- (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.
- (8 pts) How many reservations are for trips that occur during July 2016?
- (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.
- (8 pts) How many reservations have a trip price that is greater than $15.00 and less than $40.00?
- (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 ???? , ????
- (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.
- 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
- (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
- (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
- (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
- (8 pts) How many trips have the type Hiking?
- (8 pts) List the trip name of each trip that has Hal Rowan as a guide. Note: There are exactly five (5) trips.
RUBRIC
QUALITY OF RESPONSE |
NO RESPONSE |
POOR / UNSATISFACTORY |
SATISFACTORY |
GOOD |
EXCELLENT |
Content (worth a maximum of 50% of the total points) |
Zero points: Student failed to submit the final paper. |
20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. |
30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. |
40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. |
50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. |
Use of Sources (worth a maximum of 20% of the total points). |
Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. |
5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. |
10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. |
15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. |
20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. |
Grammar (worth maximum of 20% of total points) |
Zero points: Student failed to submit the final paper. |
5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors |
10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors |
15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. |
20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. |
Structure of the Paper (worth 10% of total points) |
Zero points: Student failed to submit the final paper. |
3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. |
5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper |
7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. |
10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. |
|
|
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
|
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!! |
|
|
PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!