![]() ![]() Here, HOD refers to the head of the department. One department has multiple instructors and one instructor belongs to one and only one department, hence the relationship is one to many.Įach department has one “HOD” and one instructor is “HOD” for only one department, hence the relationship is one to one. One course is enrolled by multiple students and one student for multiple courses. The department offers multiple courses and each course belongs to only one department, hence cardinality between department and course if one to many. Step 4 − Identifying the relationship between entity sets StudentNo is the key attribute for Student entities. Instructor Name is the key attribute for the Instructor entity. Student − The relevant attributes are Student No, Student Name, and date of birth.ĭepartment Name is the key attribute for Department.ĬourseNo is the key attribute for Course entity. ![]() Instructor − The relevant attributes are Instructor Name, Room No, and telephone number. Step 2 − Identifying the attributes for the given entitiesĭepartment − the relevant attributes are department Name and location.Ĭourse − The relevant attributes are courseNo, course Name, Duration, and prerequisite. It is a relationship between the instructor and department entities. Head of the Department (HOD) is not an entity set. The entity set has multiple instances in a given business scenario.Īs per the given constraints the entity sets are as follows − Here the HOD refers to the head of department.Īn instructor belongs to only one department.Įach department offers multiple courses, each subject is taught by a single instructor.Ī student may enroll for many courses offered by different departments.įollow the steps given below to draw an Entity Relationship (ER) diagram for a University database application − Step 1 − Identifying the entity sets. Drawing of ER model of university database application considering the constraints −Įach department has multiple instructors (one person is HOD). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |