Consider a database application which provides a web-based platform where students can practice on tasks assigned by the instructors. In terms of design, following are some major requirements: Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation and name. Instructors will create courses and add students to each course. Relevant details for courses are: course code, term and year. Relevant details for students are: email and student ID. Furthermore, the system generates a system wide unique course-id for each course created. ⚫ In Courses, Instructors will create one or more assignment and an assignment will consist of one or more tasks. System generates a system wide unique assignment-id for each assignment created. Assignments are always specific to a course, has a due date and a lateness penalty. In this system tasks are considered independent items and instructors may create tasks which are not part of any assignment or course. Such tasks will be added to the instructor's question pool. Each task has a system wide unique identifier. • Instructors can also create tasks when they are adding tasks to the assignments, after creating an assignment. The system automatically adds these tasks to the instructor's question pool. When creating assignments, instructors can also pick existing tasks from the question pool. • A task when associated with an assignment, whether added from pool or created as new, is assigned a max_grade, a positive number. The students when attempt that task will get the score in the range [0-max_grade]. Students will work on assignment(s) and consequently task(s) in that/those assignment(s). Student submission(s) will be awarded a score; the total score of all the tasks in an assignment will be the score of the student in that assignment. Students not working on an assignment or task will be awarded 0. For each task submitted, the system also stores the time when student submitted that task. There is no separate submission time for the assignments. Design an ER/EER schema diagram for this application

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Consider a database application which provides a web-based platform where students can practice on tasks
assigned by the instructors. In terms of design, following are some major requirements:
• Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation
and name.
• Instructors will create courses and add students to each course. Relevant details for courses are:
course code, term and year. Relevant details for students are: email and student ID. Furthermore,
the system generates a system wide unique course-id for each course created.
• In Courses, Instructors will create one or more assignment and an assignment will consist of one
or more tasks. System generates a system wide unique assignment-id for each assignment created.
Assignments are always specific to a course, has a due date and a lateness penalty.
• In this system tasks are considered independent items and instructors may create tasks which are
not part of any assignment or course. Such tasks will be added to the instructor’s question pool.
Each task has a system wide unique identifier.
• Instructors can also create tasks when they are adding tasks to the assignments, after creating an
assignment. The system automatically adds these tasks to the instructor’s question pool.
• When creating assignments, instructors can also pick existing tasks from the question pool.
• A task when associated with an assignment, whether added from pool or created as new, is assigned
a max_grade, a positive number. The students when attempt that task will get the score in the range
[0-max_grade].
• Students will work on assignment(s) and consequently task(s) in that/those assignment(s). Student
submission(s) will be awarded a score; the total score of all the tasks in an assignment will be the
score of the student in that assignment. Students not working on an assignment or task will be
awarded 0. For each task submitted, the system also stores the time when student submitted that
task. There is no separate submission time for the assignments.
Design an ER/EER schema diagram for this application,  Discuss any assumptions you make, and then justify your EER design choices

Consider a database application which provides a web-based platform where students can practice on tasks
assigned by the instructors. In terms of design, following are some major requirements:
Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation
and name.
Instructors will create courses and add students to each course. Relevant details for courses are:
course code, term and year. Relevant details for students are: email and student ID. Furthermore,
the system generates a system wide unique course-id for each course created.
⚫ In Courses, Instructors will create one or more assignment and an assignment will consist of one
or more tasks. System generates a system wide unique assignment-id for each assignment created.
Assignments are always specific to a course, has a due date and a lateness penalty.
In this system tasks are considered independent items and instructors may create tasks which are
not part of any assignment or course. Such tasks will be added to the instructor's question pool.
Each task has a system wide unique identifier.
• Instructors can also create tasks when they are adding tasks to the assignments, after creating an
assignment. The system automatically adds these tasks to the instructor's question pool.
When creating assignments, instructors can also pick existing tasks from the question pool.
•
A task when associated with an assignment, whether added from pool or created as new, is assigned
a max_grade, a positive number. The students when attempt that task will get the score in the range
[0-max_grade].
Students will work on assignment(s) and consequently task(s) in that/those assignment(s). Student
submission(s) will be awarded a score; the total score of all the tasks in an assignment will be the
score of the student in that assignment. Students not working on an assignment or task will be
awarded 0. For each task submitted, the system also stores the time when student submitted that
task. There is no separate submission time for the assignments.
Design an ER/EER schema diagram for this application
Transcribed Image Text:Consider a database application which provides a web-based platform where students can practice on tasks assigned by the instructors. In terms of design, following are some major requirements: Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation and name. Instructors will create courses and add students to each course. Relevant details for courses are: course code, term and year. Relevant details for students are: email and student ID. Furthermore, the system generates a system wide unique course-id for each course created. ⚫ In Courses, Instructors will create one or more assignment and an assignment will consist of one or more tasks. System generates a system wide unique assignment-id for each assignment created. Assignments are always specific to a course, has a due date and a lateness penalty. In this system tasks are considered independent items and instructors may create tasks which are not part of any assignment or course. Such tasks will be added to the instructor's question pool. Each task has a system wide unique identifier. • Instructors can also create tasks when they are adding tasks to the assignments, after creating an assignment. The system automatically adds these tasks to the instructor's question pool. When creating assignments, instructors can also pick existing tasks from the question pool. • A task when associated with an assignment, whether added from pool or created as new, is assigned a max_grade, a positive number. The students when attempt that task will get the score in the range [0-max_grade]. Students will work on assignment(s) and consequently task(s) in that/those assignment(s). Student submission(s) will be awarded a score; the total score of all the tasks in an assignment will be the score of the student in that assignment. Students not working on an assignment or task will be awarded 0. For each task submitted, the system also stores the time when student submitted that task. There is no separate submission time for the assignments. Design an ER/EER schema diagram for this application
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education