Database Management System Project: Hot Water Spas

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

ITC556

Table of Contents
Introduction................................................................................................................................3
ERD Diagram.............................................................................................................................4
Assumptions...............................................................................................................................5
Conclusion..................................................................................................................................6
References..................................................................................................................................7
2 | P a g e

Introduction
In the whole scenario, the company named as “Hot Water” which is a start-up organization
whole deals in selling spas. From many manufacturers, the Hot Water company purchase
spas. This organization is a normal warehouse at different locations where customers will
able to purchase different types of spas. So, for managing the complete data, the database will
be designed.
3 | P a g e

ERD Diagram
Figure 1: ERD Diagram
4 | P a g e

Assumptions
For managing the database, the Hot Water Company’s database is been designed. So, there
are some tables below, such as:
Manufacturers
 Manufacturing_ID: In this table, it is denoted as a primary key. It uniquely
identifies each manufacturer details (Al-Masree, 2015).
Brand
 Brand_ID: In this table, it is denoted as primary key and it uniquely identifies
each brand details.
 Manufacturing_ID: In this table, it is denoted as a foreign key and it is
referenced from the manufacturer table.
Model
 Model_Number: In this table, it is denoted as primary key and it uniquely
identifies each model details (Santos & Sá, 2016).
 Brand_ID: In this table, it is denoted as a foreign key and it is referenced from
the brand table.
Customers
 Cust_ID: In this table, it is denoted as primary key and it uniquely identifies each
customer details.
Orders
 Order_ID: In this table, it is denoted as primary key and it uniquely identifies
each order details.
 Model_Number: In this table, it is denoted as a foreign key and it is referenced
from the brand table.
 Cust_ID: In this table, it is denoted as a foreign key and it is referenced from the
customer table (Sorokin, et al., 2015).
5 | P a g e

Conclusion
In the overall scenario, the start-up organization wants to manage their database. It the
organization which deals in selling spas. It is the simple warehouse in different locations
where customers will able to view all the available models but any products that are sold can
be ordered easily. For managing the complete database, the ERD diagram is designed
including entities or attributes, primary keys, and foreign keys.
6 | P a g e

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.
Santos, M.Y. and e Sá, J.O., 2016, July. A data warehouse model for business processes data
analytics. In International Conference on Computational Science and Its Applications(pp.
241-256). Springer, Cham.
Sorokin, A., Le Novère, N., Luna, A., Czauderna, T., Demir, E., Haw, R., Mi, H., Moodie, S.,
Schreiber, F. and Villéger, A., 2015. Systems Biology Graphical Notation: entity relationship
language level 1 version 2. Journal of integrative bioinformatics, 12(2), pp.281-339.
7 | P a g e