ICT3621
EXAM PACK
, UNIVERSITY EXAMINATIONS
October / November 2020
ICT3621
Database Design
100 Marks
4 Hours
EXAMINERS:
FIRST: Mr, E S Mtsweni (UNISA)
SECOND: Ms. E Mwim (UNISA)
m
er as
EXTERNAL: Mr. T Museba (University of Johannesburg)
co
eH w
o.
This paper consists of 3 pages.
rs e
ou urc
Instructions:
o
aC s
Complete all questions
Write neatly
vi y re
The mark for each question is indicated in braker next to the question
Make sure your final document is in a form of pdf and is not a read only file
Agree to Honesty Declaration
ed d
ar stu
is
Th
sh
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
, Question 1 [70]
Study the table below so that you can answer the questions to follow. The table below
represents the information about the sales of snacks in a factory. The table below is not
normalized.
ORDER
DATE CUSTOMER SALES REPRESENTATIVE
PRODUCT QUANTITY UNIT PRICE TOTAL SALESUNIT COST TOTAL COST PROFITS
26-Apr Woolworths
Tshepo MahlanguFritos 86 R120 R10 320 R100 R8 600 R1 720
29-Aug Walmart Sipho NzimandePringles 70 R80 R5 600 R50 R3 500 R2 100
07-Sep Walmart Themba Msiza Ruffles 150 R120 R18 000 R80 R12 000 R6 000
22-Nov Shoprite Thapelo Mokgothu
Ruffles 85 R120 R10 200 R100 R8 500 R1 700
30-Dec ChoppeesThapelo Mokgothu
Sun Cracks 300 R50 R15 000 R40 R12 000 R3 000
07-Jul Spar Peter Phetla Pringles 40 R85 R3 400 R70 R2 800 R600
06-Aug Spar Thapelo Mokgothu
Snack Bar 45 R70 R3 150 R55 R2 475 R675
02-OctWoolworths
Thapelo Mokgothu
Sun Cracks 76 R35 R2 660 R25 R1 900 R760
m
er as
15-Nov Shoprite Tshepo MahlanguFritos 120 R80 R9 600 R50 R6 000 R3 600
co
21-Dec Walmart Tshepo Mahlangu
Sun Cracks 120 R35 R4 200 R25 R3 000 R1 200
eH w
28-Feb Pick N Pay Sipho NzimandeFritos 90 R120 R10 800 R100 R9 000 R1 800
o.
06-Mar Shoprite Sipho NzimandePringles 120 R80 R9 600 R50 R6 000 R3 600
16-Mar Spar
rs e
Themba Msiza Pringles 50 80 R4 000 R50 R2 500 R1 500
ou urc
23-Apr Shoprite Tshepo MahlanguFritos 150 120 R18 000 R100 R15 000 R3 000
04-Aug ChoppeesThapelo Mokgothu
Snack Bar 120 R70 R8 400 R55 R6 600 R1 800
18-Aug Walmart Peter Phetla Sun Cracks 450 R50 R22 500 R40 R18 000 R4 500
o
05-Sep Walmart Thapelo Mokgothu
Ruffles 769 R120 R92 280 R100 R76 900 R15 380
aC s
vi y re
28-Oct Spar Sipho NzimandePringles 340 R85 R28 900 R70 R23 800 R5 100
21-NovWoolworths
Tshepo MahlanguFritos 230 R80 R18 400 R55 R12 650 R5 750
29-Jan Spar Tshepo MahlanguFritos 450 R80 R36 000 R55 R24 750 R11 250
ed d
12-Apr Shoprite Themba Msiza Ruffles 450 R123 R55 350 R95 R42 750 R12 600
ar stu
16-Jun Shoprite Thapelo Mokgothu
Sun Cracks 800 R35 R28 000 R25 R20 000 R8 000
is
1.1 Create a dependency diagram using the above table. [15]
Th
1.2 Create a dependency diagram that is in 2NF. [5]
sh
1.3 Create a dependency diagram that is in 3NF. [5]
1.4 Deduce five business rules using the results in 1.3. [5]
1.5 Create an Entity Relationship Diagram using the results of 1.4. [20]
1.6 Create Data Dictionary using the results of 1.5. [20]
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
, Question 2 [30]
One of the important elements of database is database security. There are different
mechanisms that can be used to ensure database security. Discuss the different security
mechanisms that you can use. Discuss their advantages and disadvantages and provide
strategy on how you will implement them. Make sure you discuss a minimum of five
mechanisms.
©
UNISA 2020
m
er as
co
eH w
o.
rs e
ou urc
o
aC s
vi y re
ed d
ar stu
is
Th
sh
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
EXAM PACK
, UNIVERSITY EXAMINATIONS
October / November 2020
ICT3621
Database Design
100 Marks
4 Hours
EXAMINERS:
FIRST: Mr, E S Mtsweni (UNISA)
SECOND: Ms. E Mwim (UNISA)
m
er as
EXTERNAL: Mr. T Museba (University of Johannesburg)
co
eH w
o.
This paper consists of 3 pages.
rs e
ou urc
Instructions:
o
aC s
Complete all questions
Write neatly
vi y re
The mark for each question is indicated in braker next to the question
Make sure your final document is in a form of pdf and is not a read only file
Agree to Honesty Declaration
ed d
ar stu
is
Th
sh
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
, Question 1 [70]
Study the table below so that you can answer the questions to follow. The table below
represents the information about the sales of snacks in a factory. The table below is not
normalized.
ORDER
DATE CUSTOMER SALES REPRESENTATIVE
PRODUCT QUANTITY UNIT PRICE TOTAL SALESUNIT COST TOTAL COST PROFITS
26-Apr Woolworths
Tshepo MahlanguFritos 86 R120 R10 320 R100 R8 600 R1 720
29-Aug Walmart Sipho NzimandePringles 70 R80 R5 600 R50 R3 500 R2 100
07-Sep Walmart Themba Msiza Ruffles 150 R120 R18 000 R80 R12 000 R6 000
22-Nov Shoprite Thapelo Mokgothu
Ruffles 85 R120 R10 200 R100 R8 500 R1 700
30-Dec ChoppeesThapelo Mokgothu
Sun Cracks 300 R50 R15 000 R40 R12 000 R3 000
07-Jul Spar Peter Phetla Pringles 40 R85 R3 400 R70 R2 800 R600
06-Aug Spar Thapelo Mokgothu
Snack Bar 45 R70 R3 150 R55 R2 475 R675
02-OctWoolworths
Thapelo Mokgothu
Sun Cracks 76 R35 R2 660 R25 R1 900 R760
m
er as
15-Nov Shoprite Tshepo MahlanguFritos 120 R80 R9 600 R50 R6 000 R3 600
co
21-Dec Walmart Tshepo Mahlangu
Sun Cracks 120 R35 R4 200 R25 R3 000 R1 200
eH w
28-Feb Pick N Pay Sipho NzimandeFritos 90 R120 R10 800 R100 R9 000 R1 800
o.
06-Mar Shoprite Sipho NzimandePringles 120 R80 R9 600 R50 R6 000 R3 600
16-Mar Spar
rs e
Themba Msiza Pringles 50 80 R4 000 R50 R2 500 R1 500
ou urc
23-Apr Shoprite Tshepo MahlanguFritos 150 120 R18 000 R100 R15 000 R3 000
04-Aug ChoppeesThapelo Mokgothu
Snack Bar 120 R70 R8 400 R55 R6 600 R1 800
18-Aug Walmart Peter Phetla Sun Cracks 450 R50 R22 500 R40 R18 000 R4 500
o
05-Sep Walmart Thapelo Mokgothu
Ruffles 769 R120 R92 280 R100 R76 900 R15 380
aC s
vi y re
28-Oct Spar Sipho NzimandePringles 340 R85 R28 900 R70 R23 800 R5 100
21-NovWoolworths
Tshepo MahlanguFritos 230 R80 R18 400 R55 R12 650 R5 750
29-Jan Spar Tshepo MahlanguFritos 450 R80 R36 000 R55 R24 750 R11 250
ed d
12-Apr Shoprite Themba Msiza Ruffles 450 R123 R55 350 R95 R42 750 R12 600
ar stu
16-Jun Shoprite Thapelo Mokgothu
Sun Cracks 800 R35 R28 000 R25 R20 000 R8 000
is
1.1 Create a dependency diagram using the above table. [15]
Th
1.2 Create a dependency diagram that is in 2NF. [5]
sh
1.3 Create a dependency diagram that is in 3NF. [5]
1.4 Deduce five business rules using the results in 1.3. [5]
1.5 Create an Entity Relationship Diagram using the results of 1.4. [20]
1.6 Create Data Dictionary using the results of 1.5. [20]
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
, Question 2 [30]
One of the important elements of database is database security. There are different
mechanisms that can be used to ensure database security. Discuss the different security
mechanisms that you can use. Discuss their advantages and disadvantages and provide
strategy on how you will implement them. Make sure you discuss a minimum of five
mechanisms.
©
UNISA 2020
m
er as
co
eH w
o.
rs e
ou urc
o
aC s
vi y re
ed d
ar stu
is
Th
sh
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:41:48 GMT -05:00
https://www.coursehero.com/file/73897792/ict3621PDF/
