DRAW E-R Diagram You are required to create a course content management software for an educational institution. Below are the main features of the system: ● Admins should be able to create accounts for new users. ● Users should be able to login. ● Accounts can be of type Lecturer/Course Maintainer, Student, Admin ● Admins should be able to create a Course. ● A student can be assigned to courses
DRAW E-R Diagram
You are required to create a course content management software for an educational institution.
Below are the main features of the system:
● Admins should be able to create accounts for new users.
● Users should be able to login.
● Accounts can be of type Lecturer/Course Maintainer, Student, Admin
● Admins should be able to create a Course.
● A student can be assigned to courses.
● A Course should consist of Members(Students. Lecturer/Course Maintainer)
● A Course should consist of several Discussion Forums.
● A Discussion Forum should consist of several discussion threads.
● Students and Course Maintainers should be able to create or reply to discussion
threads.
● Students should be able to reply to replies thereby creating another thread
● A Course should have Calendar Events e.g Assignment Due Date.
● The Course Maintainer should have the ability to create, remove and update calendar
events.
● The content of a course should consist of sections/topics.
● Each section should consist of several section items e.g links, lecture slides.
● Students should be able to submit assignments.
● Course Maintainers should be able to add, update or remove section items or
create new sections.
Draw an E-R diagram for the above application. Make sure that you state any assumptions that you
made and any information that could not be captured in the diagram. Convert the E-R diagram into a
set of relations/tables. Do not normalize your tables.
Step by step
Solved in 2 steps with 1 images