1. Entity Relationship Model:The Entity Relationship Model refers to the data model which is aimed to describe theinformation and data and related aspects of business or its processes requirements. In otherwords, it is graphical representation which ultimately implemented in the database for instancerelational database (Bagui et. al., 2011). Major components of this mode include groups orentities and relationship between these groups and entities. Entity relationship model for subjectcase of University Database is summarized in diagram below.Elements or entities in this regards include:1. Faculty Groups:2. Deans to Each Faculty Group:3. Schools:4. Teachers and Instructors:5. Students:6. Enrollment:7. Discipline:8. Courses and others:2. Assumptions or Limitations for each Relationship:1. Each faculty member belongs to faculty group will be able to teach more than singlecourse.2. Each faculty member belongs to faculty group will be able to teach in more than singlediscipline (Chen, 2002).3. Each faculty member belongs to faculty group will be able to teach in one faculty fromwhich he/she belongs to.4. Each student will be able to enroll in single program at the same time.5. Each dean will supervise single faculty group at the same time.6. Each college is able to start more than one program.7. One program can be initiated in single college at the same time.8. Each faculty will have individual key for identity.9. Each school will have individual ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.