Stage
Task
Done
(
?
)
Section 1 :
Searching for the most popular attractions
1
Op
en the database file called “Popularity Database”.
This will be supplied by your teacher.
2
Add the records shown in Appendix 1 to the database.
3
The
Roasted Boar, one of the Food H
alls, has not been built .
Delete this record.
4
Print out a li
st of all the Food Halls sorted according to their popularity
rating. 1 is t
he most popular whi
le 10 is the least popular.
Write down the name of the Food Hall with the best rating.
5
Add a new field called
“
Total Attraction Time
”
to the database.
A formula will be put into the field to calculate the Total Attraction
Time by adding the Queuing Time to the Time in Attraction.
Write down the formula.
Show this to your teacher and ask them to sign the sheet below.
Teacher signature
Now add t
he field to the database.
Scottish Qualifications Aut
hority
9
Coursework Task C207 10
Intermediate 1 Computing Studies
2010/2011
Stage
Task
Done
(
?
)
Section 1 : Searching for the most popular attractions (continued)
6
Use the database to find the Roller Coaster with the shortest Total
Attraction Time
.
Write the name of the Roller Coaster below.
7
Obtain a print
out
of your database.
You Want A Similar Paper Done? Don’t be stressed, Click Here To Order this essay!!!
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
