Database Design for The Gill Art Gallery Scenario

DATABASE DESIGN

TABLE OF CONTENTS
TASK 1............................................................................................................................................1
Factors because of which database might be a target for an attack.............................................1
Type of attacks which may occur................................................................................................1
Type of data that might be extracted from the system in each attack..........................................1
Normalization table of The Gill Art Gallery Scenario................................................................2
TASK 2............................................................................................................................................3
Entity Relationship diagram........................................................................................................3
Data dictionary.............................................................................................................................3
REFERENCES................................................................................................................................6

TASK 1
Factors because of which database might be a target for an attack
There are various reason or factors because of which the Gill Art Galary database might be
at attack such as:
 Attacking database would provide attackers about information of rich or upper- class
customers who buy costly painting frequently (Alwan and Younis, 2017). Not only this, this
information is useful for attackers as using this information they can easily get account
details of those customers because of which security of those customers personal and
financial details might be at risk.
 Attackers might target and attack The Gill Art Gallery database for that they can easily show
costliest painting already sold without even making a payment for it.
 Attackers might target and attack The Gill Art Gallery database for altering prices of costliest
painting to cheapest price so that they can buy it for approximately negligible price (Ma, Xu
and Liu, 2020).
 Attackers can also target database for logging in to database as admin and making
alternations to information associated with client, paintings, sales data and past sales record.
 Mostly attackers attack database in order to gain access to sensitive or confidential data or
information which is being stored within database such as credit card details of clients or
customers. To gain access of backup storage media because often in database backup is
unprotected which becomes much easier for attackers to attack as backup media consist of all
important information backup which is stored within database.
Type of attacks which may occur
There are various types of attacks that might occur on database of The Gill Art Gallery.
Some of them are:
 Password cracking: it is one o the most common attack that attackers can do on database in
fact most of the organizations do not change their default password provided by service
providers and it can be easily compromised.
 Privilege escalation: with the help of this attack attackers can provide users with more access
to files than necessary (Uwagbole, Buchanan and Fan, 2017).
 SQL injections: Due to this attack, attackers can get into database and can make false
information and store false information to database.
1