Entity Relationship Diagram

0 / 5. 0

Doctoral Tracking Database – Entity Relationship Diagram (ERD) The ERD was designed in Visio (Microsoft) keeping in view the data presentation requirements from the reports. Crow's Foot notation was used for modeling the data (Dybka). Based on the proposed ERD, the enrollment, course completion, course sequence, advisor and thesis committee reports can easily be generated at any time. Entities Four entities extracted from the data presented in the reports include student, course, professor and thesis committee. Relationships and Cardinalities The relationships between the entities were based on the following business rules: Many students enroll to many courses (mandatory, many-to-many) Many courses have many students (mandatory, many-to-many)’ A course may have a prerequisite course (optional, one-to-one) A course may be a prerequisite to many courses (optional, one-to-many) A student may have a thesis committee (optional, one-to-one) Many committees have many professors (mandatory, many-to-many) A committee has a chair (mandatory, one-one) A professor may be part of many committees (optional, one-to-many) A student has an advisor (mandatory, one-to-one) An advisor may advise many students (optional, one-to-many) The many-to-many relationships between entities were resolved by introducing relationship entities containing foreign keys from the related entities. Third Normal Form For the ERD to be in its 3NF, its attributes must be atomic, no repeating groups should be present, and there should be no partial or transitive dependencies between the attributes within the entities. The proposed ERD conforms to all the requirements of 2NF. Figure SEQ Figure * ARABIC 1

Free Entity Relationship Diagram Essay Sample

Related samples

Zika virus: Transmission form Introduction The Zika virus belongs to the Flaviviradae family, was found for the first time in a monkey called Rhesus febrile and in...

Zika virus: cases and prevention Introduction The World Health Organization (WHO) has confirmed that Zika is a virus caused through the mosquito bite which is...

Zeus The King of Greek mythology Introduction Zeus is the Olympic God of heaven and thunder, the king of all other gods and men and, consequently, the main figure...

Zeus's punishment to Prometheus Introduction Prometheus, punished by Zeus Prometheus, punished by Zeus. Prometheus is a ‘cousin’ of Zeus. He is the son of the...

Comments

Leave feedback

Your email address will not be published. Required fields are marked *