Database Design and Implementation

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

DATABASE DESIGN AND IMPLEMENTATION
1
Table of Contents
Introduction................................................................................................................................2
ER-Diagram...............................................................................................................................2
Assumptions...............................................................................................................................3
Logical Design...........................................................................................................................4
Physical Design – Column Specification...................................................................................5
Conclusion..................................................................................................................................8
References..................................................................................................................................9

DATABASE DESIGN AND IMPLEMENTATION
2
Introduction
Database design is a very important phase of system development. It can be done
using different available modelling techniques. The modelling starts with the conceptual
design to achieve physical design (Coronel and Morris 2016). The Hassle free Dry Cleaners
Australia, provides services related to the ironing, dry cleaning, garment preservations etc.
HDCA's owner Victor collects all the data required in the process of function the Company.
This report intends to discuss the identification of the entities, attributes, data type and
relation in the current system using the Entity-Relation modelling. The ERD model will help
the implementation of the database in MS access. The report also includes a table entity
description along with the conceptual, logical design of the system.
ER-Diagram
The ERD is developed to establish the entities that exist in the system along with the
useful attributes and their relationship. The database is the most integral part of any system
(Thalheim 2013). The conceptual model of any database hardly shows any details about the
structure of the database in the physical level (real implementation). The conceptual model
consists of entity attribute and relationship only (Hoang and Van Nguyen 2013). Figure 1
shows the conceptual model of the current HDCA system.