Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please assist with a ER Diagram Entities: User Attributes: UserID, Username, Email, Password Learner ( Child ) Attributes: LearnerID, Name, Age, ParentUserID Task Attributes: TaskID,

Please assist with a ER Diagram
Entities:
User
Attributes: UserID, Username, Email, Password
Learner (Child)
Attributes: LearnerID, Name, Age, ParentUserID
Task
Attributes: TaskID, Description, Deadline, CompletionStatus, LearnerID
Message
Attributes: MessageID, Content, Timestamp, SenderUserID, ReceiverLearnerID
Information
Attributes: InformationID, Title, Description, AccessLevel, CreatorUserID
Relationships:
User to Learner: One User can have Zero or Many Children (1:N)
Learner to Task: One Child can have Zero or Many Tasks (1:N)
Task to Learner: One Task belongs to One Child (N:1)
Message to User: One Message is sent by One User (N:1)
Message to Learner: One Message is received by One Child (N:1)
User to Information: One User can access Zero or Many Pieces of Information (1:N)
Constraints:
User.UserID and Learner.LearnerID are unique identifiers.
Task.TaskID and Message.MessageID are unique identifiers.
User.UserID in Learner table is a foreign key representing the parent of the child.
Task.LearnerID is a foreign key referencing Learner.LearnerID.
Message.SenderUserID is a foreign key referencing User.UserID.
Message.ReceiverLearnerID is a foreign key referencing Learner.LearnerID.
Information.CreatorUserID is a foreign key referencing User.UserID.

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part 3 Lnai 8726

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448440, 978-3662448441

More Books

Students also viewed these Databases questions

Question

4. Describe the factors that influence self-disclosure

Answered: 1 week ago

Question

1. Explain key aspects of interpersonal relationships

Answered: 1 week ago