Relational Database Design for SPA Company Online System

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

ITC 556

Contents
Introduction...........................................................................................................................................3
Relational Database...............................................................................................................................4
Assumptions for making the relational database:.................................................................................5
Conclusion.............................................................................................................................................6
Reference..............................................................................................................................................7
Table of figure
Figure 1: Daigram..................................................................................................................................4

Introduction
There is case given for the SPA Company who is having online system and the company
same was HW which provides the various facilities. Therefore the company wants the system
which is relational database.

Part A: Database
Years ago the database was to present so all the work was done on the file and if any
updation was needed all the files and paper has to go through for only one paper updations.
So, therefore, was launching of database which helps to the things for easy updations,
modification on any tables of the column without going to read the whole database. The
database follows the properties of ACID which means the database helps to have the
atomicity, consistency, isolated and durability. The database follows all the property. The
database also helps to keep the data secure.
There is a schema of database which means this provides the format for the data to be stored
which help to show the database efficiency and effective database. The format which is
defined provide the consistency to the user and this also helps to remove the repeated value.
There is atomicity present in the database which helps to have the database and develop the
data. This helps the data to be safe and secure and this allows only the authorized user to
access the things. The database has reduced the load of man and this helps to keep the data
safe and secure and provides easy updation, modification, and deletion of the entries and also
this never allow to have the repeated entries.

Relational Database
Figure 1: Diagram

Assumptions for making the relational database:
1. In Model there is primary key named as Model_ID which means this will help to have the
unique identification of row.
2. In Manufacutre there is primary key named as Manufacture_ID which means this will help
to have the unique identification of row.
3. In Brand there is primary key named as Brand_ID which means this will help to have the
unique identification of row.
4. In Customer there is primary key named as Customer_ID which means this will help to
have the unique identification of row.
5. In Order there is primary key named as Order_ID which means this will help to have the
unique identification of row.
6. In Model there is foreign key named as Brand_ID which means this will help to have the
reference for the other table.
7. In Brand there is foreign key named as Model_ID which means this will help to have the
reference for the other table.
8. In Order there is foreign key named as Model_ID which means this will help to have the
reference for the other table.
9. In Order there is foreign key named as Customer_ID which means this will help to have
the reference for the other table.
10. There is relationship present between the Customer and Order which mean customer can
order as many as products they want (Ghawi, R. 2019, May).

Conclusion
There is relational diagram made which will help the user to understand the system of the
SPA Company. The software used for the implementation is draw.io.

Reference
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.
Link, S., & Prade, H. (2019). Relational database schema design for uncertain
data. Information Systems, 84, 88-110.
Das, S., Grbic, M., Ilic, I., Jovandic, I., Jovanovic, A., Narasayya, V. R., ... & Chaudhuri, S.
(2019, June). Automatically Indexing Millions of Databases in Microsoft Azure SQL
Database. In Proceedings of the 2019 International Conference on Management of Data (pp.
666-679). ACM.