Database Systems ER Diagram Design Project: Hot Water Spa

Desklib provides solved assignments and past papers to help students succeed.

ITC556 - DATABASE SYSTEMS
ASSESSMENT ITEM 2

Contents
Introduction................................................................................................................................3
Entity-Relationship Diagram.....................................................................................................4
Assumptions...............................................................................................................................4
Conclusion..................................................................................................................................6
References..................................................................................................................................7
Table of Figure
Figure 1: Entity-Relationship diagram.......................................................................................4

Introduction
Hot Water is the company that helps the customers by providing them the facilities of the spa.
In the assessment, there is a need to create an ER diagram that contains various entities and
relationships and the diagram is given in the report.

Part A
The History of the database is not that good as it has developed a lot with the time. Earlier,
there was a time when the data of any of the organization or the enterprises were saved in the
Files. Storing such a large amount of data was really risky to be stored and due to which the
confidential data many the times got leaked. The data extraction is quite difficult in the
previous time whereas along with the time consumption issue, security was the major issue.
By the introduction of the Database Management System, consistency, security and all others
are easily be achieved.
There are many different developments are being done in the database and mentioned below
are some of the developments mentioned:
Database Structure: One of the most important developments in the database management
system is the introduction of the structure of the database and that really helps in providing a
clear understanding of the entire database.
Structured Query Language: SQL is the Structure Query Language that really helps in
creating the entire database in a short period of time and also helps in extracting the particular
data using different commands.
Atomicity: Atomicity is the next important development in the database. Database really
keeps the entire data consistent and ignores the similar-looking data and keeps on updating
the data at regular intervals.

Part B
Entity-Relationship Diagram
Figure 1: Entity-Relationship diagram
Assumptions
Assumptions
Assumption 1 ID_BRAND is the primary key that is created so that every brand can
be identified uniquely in SPABrand table.
Assumption 2 A manufacturer can manufacture multiple brands, one-to-many
relationship with SPAManufacturer and SPABrand (Hingorani et al.,
2017).
Assumption 3 ID_MANFCT is created as the primary key so that every manufacturer
is unique.
Assumption 4 ID_MODEL is the primary key in SPAModel entity so that models can
be identified uniquely.

Assumption 5 ID_BRAND is foreign key here as it is the primary key in the table
SPABrand table.
Assumption 6 The single warehouse can contain more than one orders that justify the
relationship among the SPAWarehouse and SPAOrder tables.
Assumption 7 SPACustomers holds the information regarding the customer and the
primary key is also available in this table as well (Al-Masree, 2015).
Assumption 8 A customer can place multiple orders so this justifies the relationship
among the tables SPAOrder and SPACustomers.
Assumption 9 ID_ORDER is the primary key in table SPAOrder and IDModel and
IDCust are foreign keys in the table.
Assumption 10 ID_MANFCT is a foreign key in the table SPABrand as it takes
reference from SPAManufacturer entity.
Assumption 11 A single brand can have multiple brands so this justifies the
relationship among the tables SPAModel and SPABrand.

Conclusion
The conclusion of the given assessment is the ER diagram which is drawn and attached in the
report that contains all the essential tables and columns along with the relationship among
them.

References
Al-Masree, H. K. (2015). Extracting Entity Relationship Diagram (ERD) from relational
database schema. International Journal of Database Theory and Application, 8(3), 15-26.
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), 148-155.