Question

Help in database: User view requirement1: • For each student, store studentID, firstName, lastName, sex, majorDept, class, GPA. Assuming you will need to access students based on their names. User view requirement2: • For each department, store deptId, deptName, college. In addition, store the studentId, firstName, lastName of students major in each department. Suppose a student belongs to one department only. A department will have more than one students. Assuming you will need to access departments based on their names. User view requirement3: • For each course, store courseID, courseName. In addition, store the studentId, firstName, lastName of students who take the course. Suppose a student can enroll many courses and a course is enrolled by many students. Assuming you will need to access courses based on their names.

With the given information Draw the E-R diagram of your information level design

Please help ASAP!!!

Answer 1

The er diagram for the above requirement is in the image attached below

Explanation for the above er-diagram:

As per the given requirement we require 3 entities namely student, department and a course. Many students belong to one department and many students can enroll in many courses. There exists an many to one relationship between student and department indicating that many students can belong to one department. The relationship between students and courses is many students can enroll in many courses and many courses can be enrolled by many students.

The prime attribute in student entity is both student first name and last name.It can be a composite key which is a combination of first name and last name. The prime attribute of course entity is courseName. The prime attribute of department entity is Department Name. All the prime attributes are underlined in the diagram itself. Since no information is provided about the participation of entities I haven't mentioned about the total or partial participations in the above er-diagram. It is up to you regarding participation of entities. They are all your assumptions.

If you have any doubts feel free to post them via comments. If my work is appreciable please support me with a like.