Question: Problem: You have been tasked with designing a database for a university registration system. The system allows students to enroll in courses offered by the
Problem: You have been tasked with designing a database for a university registration system. The system allows students to enroll in courses offered by the university. Each course consists of multiple sections, and students can enroll in multiple courses. Additionally, students can enroll in multiple sections of the same course. The university needs to track various information about students, courses, and their enrollment.
Requirements: The following business rules apply:
- A student can enroll in multiple courses.
- Each course has a unique course ID and a title.
- A course is offered through multiple sections, each identified by a unique combination of course code and section number.
- Students enroll in sections of courses. A student can enroll in multiple sections.
- For each section, the university needs to track the student's final grade.
- The university wants to maintain records of each student's full name, full address, email address(es), and final grades.
Assignment: Design a database in third-normal form (3NF), which is worth 25 points of your midterm. Requirements:
- The submission must be done in a database design tool such as Lucidchart or Visio. Handwritten submissions, or those created in a general tool such as PowerPoint, will not be accepted.
- Model must have a clear, unambiguous, and accurate business definition of each entity.
- Model must identify all foreign and primary keys
please use a tool such Visio or Lucid Chart provide a screenshot thatand provide explanation
Rubric:
- Entities are correct and have high-quality definitions
- Model correctly identifies the primary keys in the model as submitted
- Model correctly identifies the foreign keys in the model as submitted
- Cardinality is consistent with the business rules
- Model conforms to third-normal form
- All attributes are atomic (indivisible).
- There are no transitive dependencies.
- Each non-prime attribute is fully functionally dependent on the primary key.
please use a tool such Visio or Lucid Chart provide a screenshot thatand provide explanation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
