Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Convert the E-R diagram into a set of relations/tables. (NB: Do not attempt to normalize your tables at this time.) draw the diagram with

image text in transcribed

. Convert the E-R diagram into a set of relations/tables. (NB: Do not attempt to normalize your tables at this time.)

draw the diagram with appropriate symbols exmaple

image text in transcribed
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. You are free to add any additional information that you feel may be useful for this application. However, you must state why you choose to do so. Cardinality Entity Zero or One Weak Entity Many One Relationship One (and only one) Weak Relationship

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

Students also viewed these Databases questions

Question

Consider this article:...

Answered: 1 week ago