Assignment 2 PDF

Preview

Summary

Unit 2 assignment...

Description

Figure 1: Example E-R diagram. Reprinted from Entity Relationship Modeling – Principles (p. 24) by A. A. Pedersen, n. d. Some valid tools include DBModeler, Microsoft Visio, PowerPoint, OpenOffice Draw, OpenOffice Impress. Whichever tool you use you must be able to copy your results into a Word document for your final submission. If you use either OpenOffice Draw or Impress you will need to get arrows’ for your connecting lines that have the standard ‘crows’ foot notation used in E-R diagrams. In the hospital, there is a reporting relationship between the head doctor and other doctors that report to the head doctor. This is known as a Unary relationship. You must be able to both describe and model this relationship within your relation and within your Entity Relationship diagram. Your assignment must include the following: 

An Entity Relationship (E-R) diagram that defines the following relations and the relationships between them:  Doctor  Patient  Appointment



Each entity must include appropriate attributes and primary keys



Each relationship must be labeled with the cardinality of the relationship



The unary relationship must be described

Doctor Relatio Attributes

DataType

DoctorID

Numeric(Integer)

DoctorFirstName Text(upto40character) DoctorLastName Text(upto40character) DoctorPhone

Numeric

SpecialtyNumbe r

Numeric

Specialty

Text Pati

Attributes

DataType

PatientID

Numeric

PatientFirstName

Text

PatientLastName

Text

PatientPhone

Numeric

PatientAddress

Text

PatientAddedDate

Date

Allergies

Text

PatientEmail

Text

DoctorID

Numeric

App oint

elati Attributes

DataType

AppointmentID

Numeric

DoctorID

Numeric

PatientID

Numeric

AppointmentDate

Date

BloodPressure

Numeric

This attribute defines the blood pressureof the patient.

Pulse

Numeric

This attribute defines the pulse of thepatient.

DoctorNotes

Text

This attribute defines the treatment notesbythedoctorfor thepatient.

MedicinesNotes

Text

Thefielddefinesthemedicinestreatmentnote sbythedoctor forthepatient.

References Pedersen, A. A. (n. d.). Entity Relationship Modeling – Principles....