Build an ERD for a grading database. Start with the following domain entities.
Courses have a name, department, course ID, hours, description and potentially many sections. Courses may be cross-listed in different departments.
Students enroll for a set of courses and get a grade for each course that they complete. Students have an ID, name, sex, gender and age.
Convert the ERD model from the previous exercise into a relational schema.
Add features to your ERD for the following.
Students complete course assignments and receive numeric scores for their work. Assignments have numbers (e.g., lab #1) and max scores (e.g., 10 points).
Assignments have types that can be weighted (e.g., lab, homework, …).
Add these new model elements to the relational schema.
Compare and contrast the database design process with and without a preliminary design step based on ERD (cf. Figure 3.1)
