GlenSki offers one-to-one skiing lessons at a number of ski resorts in Scotland - Scottish Highers Computing Science - Question 14 - 2018
Question 14
GlenSki offers one-to-one skiing lessons at a number of ski resorts in Scotland.
Instructors are based at a resort, and customers can book several lessons on one day... show full transcript
Worked Solution & Example Answer:GlenSki offers one-to-one skiing lessons at a number of ski resorts in Scotland - Scottish Highers Computing Science - Question 14 - 2018
Step 1
Draw an entity relationship diagram to show the relationships that exist in this database.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To represent the relationships in the GlenSki database, create an entity relationship diagram (ERD) with the following entities and relationships:
Customer (CustomerID*)
Lesson (LessonID*) connecting to Customer (CustomerID) and Instructor (InstructorID)
Instructor (InstructorID*) connecting to Resort (ResortID)
Resort (ResortID*)
The relationships are:
A Customer can book multiple Lessons (1 to many).
Each Lesson is conducted by one Instructor (many to 1).
Each Instructor can be associated with multiple Resorts (1 to many).
Step 2
State the primary key used to uniquely identify the Lesson table.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The primary key used to uniquely identify the Lesson table is the LessonID.
Step 3
State the tables and fields needed to output the above report.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To output the report displayed, the following tables and fields are needed:
Lesson table:
Lesson.StartTime
Lesson.Date
Lesson.InstructorID
Instructor table:
Instructor.FirstName
Customer table:
Customer.FirstName
Customer.Surname
Step 4
State the criteria used to select the data shown in the report.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The criteria to select data shown in the report are:
[Lesson.Date]=17/12/18
(AND)
[Lesson.InstructorID]=14
Step 5
State the report feature that has been used to display the ‘Number of lessons’ shown as part of this report.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The feature used to display the ‘Number of lessons’ in the report is the Summary Field.
Step 6
Describe one potential business cost of scaling their information systems.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One potential business cost associated with scaling their information systems could be the cost of additional servers or cloud storage needed to accommodate increased data volume and user activity.
Step 7
Describe one benefit to customers of joining an online community.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One benefit for customers joining an online community is the opportunity to connect with others interested in skiing, allowing them to share experiences, tips, and potentially organize group lessons or outings.
Join the Scottish Highers students using SimpleStudy...
