Scribd
Upload
16 views1 page

DMS Assignment Question Fall 2024

The assignment requires students to design a relational database for an Online Course Enrollment System, focusing on managing students, courses, instructors, and enrollments. Students must analyze stakeholder requirements, create an ER diagram, normalize the database to 3NF, and document their design choices. Evaluation criteria include the quality of the problem solution and the depth of analysis provided.

Uploaded by

manzoormurshedctg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views1 page

DMS Assignment Question Fall 2024

The assignment requires students to design a relational database for an Online Course Enrollment System, focusing on managing students, courses, instructors, and enrollments. Students must analyze stakeholder requirements, create an ER diagram, normalize the database to 3NF, and document their design choices. Evaluation criteria include the quality of the problem solution and the depth of analysis provided.

Uploaded by

manzoormurshedctg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Premier University, Department of CSE

Fall 2024, 4th Semester, Assignment


Course Title: Database Management Systems, Course Code: CSE 2221
Course Outcome: CO3, Total Marks: 10
A university offers multiple online courses for its students, and the administration wants to streamline the
course enrollment process. The system should manage students, courses, instructors, and enrollment
records efficiently.
Objectives:
• Analyze the requirements of different stakeholders and convert them into a comprehensive
database design.
• Understand and apply relational database concepts.
• Normalize a database design for efficiency and integrity.
Investigation:
Design a relational database for an Online Course Enrollment System. The system should include the
following entities and their relationships: Students, Courses, Instructors, Enrollments, etc.
Evaluation:
• Discuss the reasons behind utilizing a relational database for this scenario.
• Design an ER (Entity-Relationship) diagram showing the relationships between the entities.
• Normalize the database design up to the third normal form (3NF).
• Clear and structured documentation.
Design:
Propose a comprehensive database design for the Online Course Management System.
Deliverables:
A printed assignment reporting the following tasks:
(i) A perfect database design for the Course Management System addressing the objectives.
(ii) Explanation of design choices and normalization process.
(iii)Briefly address the complex problem-solving questions:
a. Does the solution need in-depth engineering knowledge?
b. Does the solution involve wide-ranging or conflicting technical, engineering, and other issues?
c. Is the solution well-known, or does it require abstract thinking and analysis to formulate?
d. Does the solution involve infrequently encountered issues?
e. Does the solution need adherence to standards and codes of practice?
f. Does the solution involve stakeholders with conflicting technical requirements?
g. Does the solution involve interdependence between sub-problems or parts?
Rubrics for Assignment marking:
Task Criteria Good (4-5) Moderate (2-3) Poor (1)
i. Problem Properly or near Appropriate solution Inappropriate or no
solution appropriately reasoned for some cases solution
solution
ii. Problem In-depth analysis Shallow analysis Incomplete analysis
analysis

You might also like