You are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements given here.
You are asked to design a
departments. Each department in that university offers one or more courses to the students. All the
students are part of a certain department and they take courses in that department. A department has
a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a
credit point value, and the year it commenced. A course cannot be identified uniquely with the
course number, but the course number is unique for each department. Students have given names,
surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course
the year and the semester he or she took that particular course is recorded. When he finishes the
course , the grade and total marks are recorded. A student can take multiple courses but they are also
allowed to drop a semester in that university by taking no courses. Construct an ER diagram using
the requirements given here. (10)
Step by step
Solved in 2 steps with 2 images