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

Related samples

Name Name von Professor Disziplin Datum Inhalt TOC o "1-3" h z u 1 Einleitung PAGEREF _Toc507996845 h 32 Chancen und Risiken der Digitalisierung PAGEREF...

Motivation und Gesundheitsverhalten Inhaltsverzeichnis TOC o "1-3" h z u Abbildungsverzeichnis PAGEREF _Toc507269413 h 31. Gesundheit und gesundheitsbezogenes...

Descartes
0
(0)

DESCARTES MEDITATION Student’s Name Institution Introduction This term paper reflects Descartes’ meditation. It gives a critical analysis concerning the...

Student’s Name: Professor’s Name: Course Number: Date: Schizophrenia Psychological disorders are a pattern of irregular thoughts and behaviors which impede a...

Comments

Leave feedback

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