ITC 556 Database Report: Relational Diagram for SPA HW Company

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

ITC 556

Contents
Introduction..............................................................................................................................................3
Relational Diagram..................................................................................................................................4
Assumptions and business rule:...............................................................................................................5
Conclusion...............................................................................................................................................7
References................................................................................................................................................8

Introduction
In the report, the user will learn about the relational diagram which is made by using the tool
known as draw.io. The diagram is based according to the scenario given, which is of SPA hw
company.

Part A: Database research
History: Earlier, the database was used to get stored in the form of the Files and due to the
File system, there were a lot of errors occurred. Fetching of a particular type of Data was also
difficult as finding the particular data becomes really hard. Not just the data fetching but also
the updates became really hard to do and if done then there is a high risk of inconsistency in
data. The main reason for creating the present database was removing the inconsistency,
anomalies, and insecurity from the database. The safety of the data is must when the data gets
stored in bulk.
There are various inventions made after the database got developed and the three of
them are mentioned below as:
SQL- SQL is expressed as Structure Query Language that contains various commands which
also help in developing the database and also contains few of the commands that would
definitely be used for fetching of the particular kind of data.
Atomicity- Atomicity is the other introduction to the development of the database that purely
helps in keeping the data consistent, durable as well as makes sure if any of the data doesn’t
get repeated. Atomicity is must require a thing that would definitely help in keeping the data
safe and consistent.
Schema of Database- Having the proper structure of the database really helps in
understanding the data really well and due to the introduction or the development of having
the proper structure really makes the database very effective and efficient.

Part B: Data Modelling
Relational Diagram
Figure 1: Relational Database

Assumptions and business rule:
Assumptions Descriptions
Primary Key In Brand_Spa there is primary key present
named as BS_Id which used to help the row
for unique identification.
Primary Key In Order_spa there is primary key present
named as OS_Id which used to help the row
for unique identification.
Primary Key In Manufacture_Spa there is primary key
present named as MS_Id which used to help
the row for unique identification.
Primary Key In Model_Spa there is primary key present
named as MO_Id which used to help the row
for unique identification.
Primary Key In Customer_Spa there is primary key
present named as C_Id which used to help
the row for unique identification.
Foreign Key In Brand_Spa there is foreign key present
named as MS_Id which used to help to take
the reference of other tables.
Foreign Key In Order_Spa there is foreign key present
named as MO_Id which used to help to take
the reference of other tables.
Foreign Key In Model_Spa there is foreign key present
named as BS_Id which used to help to take
the reference of other tables.
Foreign Key In Order_Spa there is foreign key present
named as C_Id which used to help to take the
reference of other tables.
Relationship There is a one-to-many relationship present
in Customer_spa and Order_spa which
means that the customer can order many

products.
Relationship There is a one-to-many relationship present
in Brand_spa and Model_spa which means
that the brand can order many models of the
products (Kumar, & Azad, 2019).

Conclusion
The above diagram explains the proper relational database diagram. This will help the user to
understand the SPA hw system. The entire consists of the two different parts and both the
parts are explained properly along with the relational diagram present or created in Part B
using draw.io.

References
Kumar, K., & Azad, S. K. (2019). Determining All Possible Candidate Keys for Relational
Database Design. In Innovations in Soft Computing and Information Technology(pp. 241-
248). Springer, Singapore.
Link, S., & Prade, H. (2019). Relational database schema design for uncertain
data. Information Systems, 84, 88-110.
Ghawi, R. (2019, May). Interactive Decomposition of Relational Database Schemes Using
Recommendations. In International Conference: Beyond Databases, Architectures and
Structures (pp. 97-108). Springer, Cham.