Database Design Project: Relational Diagram for SPA HW Company

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

Contents
Introduction..............................................................................................................................2
Relational Diagram..................................................................................................................3
To make ERD there is need to have some assumptions:......................................................3
Conclusion.................................................................................................................................5
Reference...................................................................................................................................6
Table of Figure
Figure 1: Relational diagram......................................................................................................3

Introduction
There is relational diagram made with the scenario which helps the SPA hw company to
generate the system. The tool which is used draw.io which is online.

Relational Diagram
Figure 1: Relational diagram.

Part A:
The database based is not so old technique, previously the data was used to store in the file
which was very difficult for the person to take the data out. The extracting of data is difficult
but along with this the updation of the data is also difficult. So there was the idea used to
create the database and reduce the difficulties. The database which is built helps to remove
the anomalies, insecurity, and inconsistency from the data. The database helps to have to
build security.
SQL: This is the Structure Query Language which consists of various commands which help
to build the database and extract the particular information.
Schema of the database: The database has the proper structure which helps the users to
understand the format of the database. Having a clear structure will help to make the database
very effective and clear database.
Atomicity: this helps to develop the database which will keep thee data consistent and pure.
This helps the data to not get repeated which means the database has to remove the
redundancy of data. Atomicity helps to have the data safe and kind of data.
The database helps to have the data easy secure and this also helps to have to modify the data
and update the data easily. The database follows the property of ACID.
To make ERD there is need to have some assumptions:
1. In table BrandSpa there is primary key B_Id which uniquely identify the row of the
tables.
2. In table OrderSpa there is primary key Order_Id which uniquely identify the row of
the tables.
3. In table CustomerSpa there is primary key Cust_Id which uniquely identify the row of
the tables.
4. In table ManufactureSpa there is primary key Man_Id which uniquely identify the
row of the tables.
5. In table ModelSpa there is primary key M_Id which uniquely identify the row of the
tables.

6. In table BrandSpa there is foreign key Man_Id which provide the reference for the
other table.
7. In table ModelSpa there is foreign key B_Id which provide the reference for the other
table.
8. In table OrderSpa there is foreign key Cust_Id which provide the reference for the
other table.
9. There is one-to–many relationship between the Customerspa and Orderspa which
means one customer can order many things.
10. In table OrderSpa there is foreign key M_no which provide the reference for the other
table (Zirkelbach, & Hasselbring, 2019).s

Conclusion
The above relational diagram is simple and easy to understand and the tool which is used is
the draw.io.

Reference
Zhang, F., Ma, Z. M., & Cheng, J. (2016). Enhanced entity-relationship modeling with
description logic. Knowledge-Based Systems, 93, 12-32.
Zirkelbach, C., & Hasselbring, W. (2019). Live Visualization of Database Behavior for Large
Software Landscapes: The RACCOON Approach.
Link, S., & Prade, H. (2019). Relational database schema design for uncertain
data. Information Systems, 84, 88-110.