Your technology certification is waiting. Enroll in Cloud Class ®
There are 3 types of User (Parent,Teacher,Student) Parent can see their Students, and their Student's teachers.
student can see their Parent, and their teachers. Teacher can see all their students, along with their parents. All users have the same atributes (User table).
Each User has one or zero photo (profile pic). A Photo can have many users ??? (that does not sound right)
Activities will have one photo. Same photo can be used for many activities. (Category does not have a photo. that is wrong in the category table.)
Each Activity can have only one Category. A Category can be in one or many Activities.
A Comment can have only one Category. A Category can have many Comments.
A Comment can have only one Activity. An Activity can have many Comments.
A Comment can have only one Risk. A Risk can have many Comments.
An Activity can have Many Alerts. An Alert can have many Activities.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.