Database Design and Implementation

Running head: DATABASE DESIGN AND IMPLEMENTATION
Database Design and Implementation
Name of the Student
Name of the University
Author’s note:

1DATABASE DESIGN AND IMPLEMENTATION
Table of Contents
Entity Relationship Diagram:..........................................................................................................2
Relational Tables:............................................................................................................................3
Data Creation in MS Access:...........................................................................................................5
Form to input/update data for Candidate:........................................................................................6
Queries:............................................................................................................................................6
Report:.............................................................................................................................................7
Bibliography:...................................................................................................................................8

2DATABASE DESIGN AND IMPLEMENTATION
Entity Relationship Diagram:
Figure 1: Entity Relationship Diagram
(Source: Created by Author)
The above entity relationship diagram shows that eight entities are required to support the
data requirements. The ERD shows that the RoomAdmission table is a bridge table that converts
the many-to-many relationship into one-to-one and many-to-one relationship. The ERD also
represent that the each admission has to be associated with the payment. The diagram clearly
shows the cardinality and optionality of the entities. It is not necessary that each doctor will