Database Design Project: HOT WATER Company Entity-Relationship Diagram

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

ITC556 - DATABASE SYSTEMS
ASSESSMENT ITEM 2

Contents
Introduction................................................................................................................................2
Relational Diagram....................................................................................................................3
Assumptions...............................................................................................................................3
Reference....................................................................................................................................5
Table of Figure
Figure 1: Relational diagram......................................................................................................3

Introduction
The case study is related to a company named as HOT WATER and this assignment is related
to the diagram of entity-relationship that need to create in which various relationship and
entity related to each other is provided here. The given diagram is created using draw.io and
the image is given here. There are overall six different entities that are connected with each
other.

Relational Diagram
Figure 1: Relational diagram.
Assumptions
 As one customer can have multiple orders so the entities SPA_CUSTOMER and
SPA_ORDER are interconnected with one-to-many relationship with each other.
 SPA_ORDER can contain multiple models in the warehouse so the entities
SPA_ORDER and SPA_WAREHOUSE are interconnected with each other (Jia et al.,
2016).
 Model_No is the primary key in the entities SPA_WAREHOUSE and
SPA_MODELS as there can’t be duplicate entries in these columns (Jans & Soffer,
2017).
 Multiple Brands can be manufactured so the entities SPA_BRAND and
SPA_MANUFACTURE are interconnected with each other with a one-to-many
relationship.

 One brand can have multiple models so the entity SPA_BRAND is connected with
SPA_MODELS by one-to-many relationship.
 SPA_MODELS and SPA_WAREHOUSE are interconnected with each other as well.
 For every table, there are primary keys that uniquely define every column and no
duplicate entry can be there in the column (Letkowski, 2015).
 There are foreign keys that are available in the tables and mentioned in italic font,
they take reference from other tables.

Conclusion
The above relational diagram is connected with the case study that is given in assessment and
the diagram contains relationships and other constraints like foreign key and primary keys.
Moreover, every entity is related to some relationship as they depend on each other with
some relation. The diagram is given above with some assumptions that are mentioned.

Reference
Jans, M., & Soffer, P. (2017, September). From the relational database to the event log:
decisions with quality impact. In International Conference on Business Process
Management(pp. 588-599). Springer, Cham.
Jia, T., Zhao, X., Wang, Z., Gong, D., & Ding, G. (2016, June). Model transformation and
data migration from the relational database to MongoDB. In 2016 IEEE International
Congress on Big Data (BigData Congress) (pp. 60-67). IEEE.
Letkowski, J. (2015). Doing database design with MySQL. Journal of Technology
Research, 6, 1.