DATA 200: Database Design, ER Diagram, and Implementation Report

This report provides a comprehensive overview of database concepts, focusing on the implementation of a database for an Emergency Unit using MS Access. It begins with the creation of an ER diagram to identify key business rules, followed by the development of the database in MS Access. The entities included are doctors, nurses, receptionists, patients, medicines, beds, prescriptions, and admissions. The report also covers the normalization of the database tables, ensuring that they meet the first, second, and third normal forms. Furthermore, the report includes several SQL queries designed to retrieve specific information from the database, such as doctor details, admission records, and bed allocations. The assumptions and business rules used in the database design are also outlined. The document includes two ER Diagrams, one old and one new, and the bibliography lists the resources used. This assignment demonstrates the ability to design and implement a relational database effectively using MS Access.

Running head: DATABASE CONCEPTS
Database Concepts
Name of the Students:
Name of the University:
Author Note

1
DATABASE CONCEPTS
Reflection
The report contains the description of the ER diagram and the database concepts. For this
assignment at first we have implemented the ER diagram that helps us in identifying all the
important business rules provided by the organization. The ER diagrams have been created using
the tool named MS Visio. In addition to this, it is important to have knowledge about the
platform om which the database is to be created. The database has been created on the Microsoft
access database. In addition to this, the explanation about the case study and the entities and the
attributes that are to be included in the database. The entities of the database are doctors, nurses,
receptionists, patients, medicines, beds, prescriptions and admissions. The database provides the
details of the Emergency Unit and the information related to it. The ER diagram displays the
business rule for the organization efficiently and this is very important for us as this provides an
excellent platform for us to implement the database in the MS Access. We have tried to
implement the database according to the ER diagram and made all the possible fields in the
database. In addition to this, we have set up a number of relationships in the database and this
has helped in making the referential integrities in the database. The ER diagram and the database
would be very useful for anyone to read the report and understand the context of the report.
Additionally, we can easily say that after the completion of the assignment we would be capable
to implement any type of database in MS Access.

2
DATABASE CONCEPTS
ER Diagram (Old)

3
DATABASE CONCEPTS
ER Diagram (New)
Normalization
It is to be noted that all the tables in the ER diagram are normalized. All the primary keys
in the table have ER diagram are normalized. All the primary keys in the table have unique
values for themselves and also the there are no duplicate values. Hence, the relation is already in
first normal form. In addition to this, all the fields in the table are dependent on the primary field
of the tables. In addition to this the fields in the table does preserve transitive dependencies on
each other hence, the tables are in the third normal from.

4
DATABASE CONCEPTS
Queries
Query Query Description
qrydoctor List first name, last name, email address and mobile number of all
doctors.
qryAdmission List the details of the admission of the patients
qryBed Details of the patients who are allocated in the beds.
qryScheduler List of patients and the receptionists who schedule the appointment.
qryNurse Details of all the Nurses who are in charge of the beds.
Business Rules/Assumptions
The ER Diagram has been provided to us from the previous contains a number of entities
and attributes. In addition to this the two additional entities have been considered in place of the
staffs This would help in the normalization of the table for the database.

5
DATABASE CONCEPTS
Bibliography
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management.
Cengage Learning.
Hingorani, K., Gittens, D., & Edwards, N. (2017). REINFORCING DATABASE CONCEPTS
BY USING ENTITY RELATIONSHIPS DIAGRAMS (ERD) AND NORMALIZATION
TOGETHER FOR DESIGNING ROBUST DATABASES. Issues in Information Systems, 18(1).