Task 3 Part C: Response – 20 marks (5%)
Time allocation: One week
Managing data: Normalisation
1.
Essential Supplies Ltd has multiple stores throughout WA and currently stores sales data in a flat file database that is susceptible to anomalies. Use the data shown
below to provide an explanation and an example of each of the following anomalies:
a)
b)
c)
insertion
deletion
update
(6 marks)
OrderNum
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
OrderAmount
$120.00
$356.00
$423.00
$88.00
$1023.00
$678.00
$569.00
$2300.00
$612.00
$332.00
$74.00
$654.00
$124.00
$1211.00
$489.00
$571.00
OrderDate
5/5/13
6/5/13
8/5/13
8/5/13
9/5/13
10/5/13
10/5/13
10/5/13
10/5/13
11/5/13
11/5/13
12/5/13
12/5/13
12/5/13
13/5/13
13/5/13
CustName
B and J Co
Johnston Co
Lee Co
Lee Co
Johnston Co
B and J Co
Dale Designs
Lee Co
Johnston Co
Dale Designs
Johnston Co
Dale Designs
B and J Co
B and J Co
Lee Co
Dale Designs
Custphone
9 212 3000
9 300 1000
9 323 0011
9 323 0011
9 300 1000
9 212 3000
9 123 4567
9 323 0011
9 300 1000
9 123 4567
9 300 1000
9 123 4567
9 212 3000
9 212 3000
9 323 0011
9 123 4567
SalesName
Longley
Forest
Williams
Stokes
Forest
Tan
Longley
Jones
Forest
Jones
Forest
Jones
Williams
Jones
Longley
Forest
SalesSalary
$60 000
$65 000
$46 000
$50 000
$65 000
$62 000
$60 000
$52 000
$65 000
$52 000
$65 000
$52 000
$46 000
$52 000
$60 000
$65 000
StoredAdd
1 Boaz Walk
23 Thor Road
23 Thor Road
7 Tin Street
23 Thor Road
7 Tin Street
1 Boaz Walk
3 Hay Terrace
23 Thor Road
1 Boaz Walk
23 Thor Road
1 Boaz Walk
3 Hay Terrace
1 Boaz Walk
1 Boaz Walk
23 Thor Road
StoreSuburb
Joondalup
Rockingham
Rockingham
Wangara
Rockingham
Wangara
Joondalup
Mandurah ...