A dog walking company uses a relational database to store details about the dogs that they take on walks - Scottish Highers Computing Science - Question 12 - 2023
Question 12
A dog walking company uses a relational database to store details about the dogs that they take on walks.
Customer
custID
dogID
forename
name
surname
br... show full transcript
Worked Solution & Example Answer:A dog walking company uses a relational database to store details about the dogs that they take on walks - Scottish Highers Computing Science - Question 12 - 2023
Step 1
Customer - Dog (1:M)
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
Each customer can have multiple dogs, but each dog belongs to one specific customer. This relationship is represented through a one-to-many (1:M) connection between Customer and Dog.
Step 2
Staff - Walk (1:M)
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
Each staff member can manage multiple walks, while each walk is conducted by one specific staff member. This creates a one-to-many (1:M) relationship from Staff to Walk.
Step 3
Dog - Walk (1:M)
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
Each dog can participate in multiple walks, but each walk involves one specific dog. Thus, this relationship is also represented as one-to-many (1:M) from Dog to Walk.
Join the Scottish Highers students using SimpleStudy...
