Database Systems ER Diagram Report: Hot Water Company Entities

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

ITC556 - DATABASE SYSTEMS
ASSESSMENT ITEM 2

Table of Contents
Introduction................................................................................................................................2
Relationship Diagram.................................................................................................................3
Assumptions...............................................................................................................................4
Conclusion..................................................................................................................................5
References..................................................................................................................................6

Introduction
This report is about the creation of the ER diagram for the Hot Water company as this
company wants to deploy their business and create all the relationships between different
entities present over there. The connectivity is done using cross foot notations and the tool
used for ER diagram is draw.io.

Relationship Diagram
Figure 1: Relationship Diagram

Assumptions
 manufacturer_id: In the Manufacturer table, it is the primary key and used for
identifying all details of manufacturers (Zhang, et al., 2016).
 brand_id: In the brand table, it is the primary key and used for identifying all details of
brands.
 manufacturer_id: In the brand's table, it is the foreign key and used for making a
connection with the manufacturer's table.
 model_no: In the model table, it is the primary key and used for identifying all details of
spa models.
 brand_id: In the model table, it is the foreign key and used for making the connection
with the brand table (Zhang, et al., 2016).
 customer_id: In the customer table, it is the primary key and used for identifying all
details of customers.
 Order_id: In the order table, it is the primary key and used for identifying all details of
spa orders.
 model_no: In the HW_warehouse table, it is the primary key used for identifying all
details of the warehouse of Hot Water organization.
 customer_id: In the order table, it is the foreign key and used for making the connection
with the customer table (Gaikwad, et al., 2017).
 model_no: In the order table, it is the foreign key and used for making the connection
with the model table.

Conclusion
The ER diagram included in this report have connectivity among all the entities and the
primary and foreign keys are also clearly displayed. This diagram is totally made on
assumptions as the Hot Water company has lots of connections and relationships.

References
Zhang, F., Ma, Z. M., & Cheng, J. (2016). Enhanced entity-relationship modeling with
description logic. Knowledge-Based Systems, 93, 12-32.
Zhang, Y., Zhou, S., & Cao, C. (2016). Establishment of Color Matching Database Based on
MySQL. In Advanced Graphic Communications, Packaging Technology and Materials (pp.
373-378). Springer, Singapore.
Gaikwad, A. S., Kadri, F. A., Khandagle, S. S., & Tava, N. I. (2017). Review on Automation
Tool for ERD Normalization. International Research Journal of Engineering and
Technology (IRJET)[Online], 4(2), 1323-1325.