(Solved) : Health Connect Relational Model Users Nickname Firstname Surname Birthyear City Suburb Job Q31507501 . . . .

Health Connect relational model

Users (nickname, firstName, surname, birthYear, city, suburb,job, TV, videoID, mentorNickname)

Posts (postID, datetime, content) PostAuthors (nickname,postID)

PostComments (nickname, postID, datetime, content) Video(videoID, title, description, duration, filetype)

HealthPractitioners (healthPracID, firstName, surname,streetNumber, street, suburb, city, postcode, type)

PhoneNumber (phoneNumber, healthPracID) Illness (illnessID,name, description)

TreatmentRecords (nickname, healthPracID, illnessID,dateStarted, degree)

FOREIGN KEYS

 PostAuthors (nickname) is dependent on Users (nickname)

 PostComments (nickname) is dependent on Users (nickname)

 PostAuthors (postID) is dependent on Posts (postID)

 PostComments (postID) is dependent on Posts (postID)

 Users (videoID) is dependent on Video (videoID)

 TreatmentRecords (healthPracID) is dependent onHealthPractitioners (healthPracID)

 PhoneNumber (healthPracID) is dependent on HealthPractitioners(healthPracID)

 TreatmentRecords (illnessID) is dependent on Illness(illnessID)

OTHER CONSTRAINTS

 Video