Jeisen515
commented
1 year ago Changes done to the database:
- Removed the student-tutor-course ID since it was redundant.
- Added a session_ID that is a foreign key from the tutoring_course.schedule_ID.
- Added a notifications table with the following columns (notification_id, sender_id, receiver_id, notification_type, body, and created_at)
- Created rows for the tables for future testing purposes
Image of the current database schema for approval and better understanding of the changes made:
OrdepA17
In this task, you will take all the feedback from teams regarding the data that wants to be worked on and habilitate the requests if the data is not already stored. This includes creating the tables and queries to display this new data as well as documenting these changes so that the other members working on the APIs can take these new queries and work on the creation of those new connections.
This task will be marked as completed when there are at least 4 new relationships within the database, this can be either new tables or modifications to existing ones. Bonus points for additional relationships.
To work on this task, you must communicate effectively with the teams or managers and identify each new change. Since these changes can not be directly shown in GitHub, documentation of the new changes must be provided.
Task worth: 48pts (6pts High Priority * 8 pts Advanced difficulty)