Photo AI

Cara runs a private tutoring company for Computing Science students - Scottish Highers Computing Science - Question 9 - 2022

Question icon

Question 9

Cara-runs-a-private-tutoring-company-for-Computing-Science-students-Scottish Highers Computing Science-Question 9-2022.png

Cara runs a private tutoring company for Computing Science students. Cara requires a relational database to: - store data on students, tutors and sessions - displa... show full transcript

Worked Solution & Example Answer:Cara runs a private tutoring company for Computing Science students - Scottish Highers Computing Science - Question 9 - 2022

Step 1

State one functional requirement of the relational database.

96%

114 rated

Answer

Create a query to calculate the total fees that each tutor has been paid.

Step 2

Draw an entity-relationship diagram to show the relationships that exist in this database.

99%

104 rated

Answer

The entity-relationship diagram will include three entities: Student, Tutor, and Session. The relationships are as follows:

  • Student to Session: One-to-Many (One student can have multiple sessions)
  • Tutor to Session: One-to-Many (One tutor can conduct multiple sessions)

The diagram should reflect these relationships without including attributes.

Join the Scottish Highers students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;