Database Design Report: ER Diagram, Schema, Attributes, and Tables

This report focuses on the design of a database, presenting an Entity-Relationship (ER) diagram and database schema. The report details the attributes for each table, including data types, sizes, and key constraints. The tables include: Administrator, Staffs, Medicines, Disease, Patients, Diagnosis, Prescribed Dose, and Alert. The ER diagram visually represents the relationships between these entities. The data dictionary provides comprehensive information on each attribute within the tables, such as primary keys, foreign keys, and data types. The report concludes with a bibliography of relevant sources.

Running head: DATABASE DESIGNING
Database Design
Name of the Student:
Name of the University:
Author note

1
DATABASE DESIGN
ER Diagram
Database schema
Administrator (AdminID (pk), AdminName, AdminAddress)
Staffs (StaffID (pk), StaffName, Contact, Fax, Email)
Medicines (MedID (pk), MedName, Composition)
Disease (DiseaseID (pk), DiseaseName)
Patients (PatientID (fk), PatientName, Age)
Diagnosis (DiagnosisID (pk), StaffID (fk), DiseaseID (fk), PatientID (fk))
Prescribed Dose (DoseID (pk), PatientID (fk), DiagnosisID (fk), MedID (fk), DoseDetails,
AdminID (fk))
Alert (AlertID (pk), DoseID (fk), StaffID (fk), Intervals)

2
DATABASE DESIGN
Data Dictionary
Administrator
Attributes Datatypes Size Key Not Null/ Null
AdminID int 10 Primary Key Not Null
AdminName Varchar2 20 Not Null
AdminAddress Varchar2 30 Not Null
Staffs
Attributes Datatypes Size Key Not Null/ Null
StaffID int 10 Primary Key Not Null
StaffName Varchar2 20 Not Null
StaffAddress Varchar2 30 Not Null
Contact int 10 Not Null
Fax int 20 Not Null
Email Varchar2 30 Not Null
Medicine
Attributes Datatypes Size Key Not Null/ Null
MedID int 10 Primary Key Not Null
MedName Varchar2 20 Not Null
Composistion Varchar2 30 Not Null
Disease
Attributes Datatypes Size Key Not Null/ Null
DiseaseID int 10 Primary Key Not Null
DiseaseName Varchar2 20 Not Null
Patients
Attributes Datatypes Size Key Not Null/ Null

3
DATABASE DESIGN
DiseaseID int 10 Primary Key Not Null
DiseaseName Varchar2 20 Not Null
Diagnosis
Attributes Datatypes Size Key Not Null/ Null
DiagnosisID int 10 Primary Key Not Null
StaffID int 10 Foreign key Not Null
DiseaseID int 10 Foreign key Not Null
PatientID int 10 Foreign key Not Null
Prescribed Dose
Attributes Datatypes Size Key Not Null/ Null
DoseID int 10 Primary Key Not Null
DiagnosisID int 10 Foreign key Not Null
MedID int 10 Foreign key Not Null
PatientID int 10 Foreign key Not Null
AdminID int 10 Foreign key Not Null
DoseDetails Varchar2 100 Not Null
Alert
Attributes Datatypes Size Key Not Null/ Null
AlertID int 10 Primary Key Not Null
DoseID int 10 Foreign key Not Null
StaffID int 10 Foreign key Not Null
Intervals Time Not Null

4
DATABASE DESIGN
Bibliography
Connolly, T., & Begg, C. (2015). Database systems. Pearson Education UK.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management.
Cengage Learning.