Case Study

Instructions: Download the ER Diagram from Draw.io as PDF$$s$,$ and submit it as one file with the group details. Mention the data types and the string length in case of VARCHAR.

Design the ER Diagram for the following case study:

Our platform is a comprehensive online learning system that offers a variety of courses and resources for students. Each course has a unique course id $(10$ characters long$),$ can be categorized into one or more subjects $($the subjects are Math, Science, Humanities, and Arts$),$ has a status $($Active or Inactive$),$ and has a syllabus $($text of at most $500$ characters$).$ Some courses may be part of a curriculum and we keep track of the sequence. Each course is created and managed by a single instructor $($who is our registered user$),$ and uploaded to our platform in one or more sessions.

Our users are identified by name $($at most $30$ characters$),$ email $($at most $30$ characters$),$ and a unique user id $(10$ characters long$).$ They can be either guest users or registered users. The registered users have passwords $($at most $10$ characters$)$ and we keep the date of the registration. They need the password to access our platform to post questions, upload assignments, or update their profiles. A user can enroll in any course, the number of enrollments per user per course is recorded. The registered users can post questions for any course. Every question has an id $($a positive integer$)$ and a description $($text of at most $500$ characters$).$ The question id$$s must be unique for all questions concerning the same course. The date of posting of a question is recorded. Each question is related to a single course and is posted by a single registered user.

Some of our registered users are instructors. They create the courses and also updates for their own courses. Each update for a course has an id $(10$ characters long$),$ a name $($at most $30$ characters$),$ a status $($Published or Unpublished$),$ a description $($text of at most $500$ characters$),$ and is assigned a particular level $($the levels are Beginner, Intermediate, and Advanced$).$ Each update for a course is created by a single instructor, the one who originally created the course. Each update is uploaded to our platform in a session.

Each session has an id $(8$ characters long$)$ and a date when it took place. The session id$$s must be unique for all sessions concerning the same course. Additionally, our platform also hosts a variety of resources such as textbooks, research papers, and articles. Each resource has a unique id $(12$ characters long$),$ a title $($at most $50$ characters$),$ a type $($Textbook$,$ Research Paper, Article$),$ and a brief description $($text of at most $500$ characters$).$ Resources can be linked to one or more courses and are uploaded by our registered users. The number of downloads per user per resource is recorded. The registered users can also write reviews for any resource. Every review has an id $($a positive integer$)$ and a description $($text of at most $500$ characters$).$ The review id$$s must be unique for all reviews concerning the same resource. The date of writing of a review is recorded. Each review deals with a single resource and is made by a single registered user.

Please explain to me that how to draw this diagram in a better way in draw.io because i couldn't understand the diagramatic representation last time.