ICT3621
EXAM
PACK
2024
LATEST EXAM PACK QUESTIONS AND
ANSWERS AND SUMMARIZED NOTES
FOR EXAM PREPARATIONS.
UPDATED FOR 2024 EXAMS!!
, Stuvia.com - The study-notes marketplace
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 SALES
UNIT 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 Mahlangu
Fritos 150 120 R18 000 R100 R15 000 R3 000
04-Aug ChoppeesThapelo Mokgothu
Snack Bar 120 R70 R8 400 R55 R6 600 R1 800
o
18-Aug Walmart Peter Phetla Sun Cracks 450 R50 R22 500 R40 R18 000 R4 500
aC s
05-Sep Walmart Thapelo Mokgothu
Ruffles 769 R120 R92 280 R100 R76 900 R15 380
v i 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
s h is
1.1 Create a dependency diagram using the above table. [15]
Th
1.2 Create a dependency diagram that is in 2NF. [5]
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/
Downloaded by: hlogzaogza |
Distribution of this document is illegal
, Stuvia.com - The study-notes marketplace
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
v i y re
ed d
ar stu
s h is
Th
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/
Downloaded by: hlogzaogza |
Distribution of this document is illegal
, Stuvia.com - The study-notes marketplace
Exam ICT3621 700553 2020/2
Student: 56661118
Question1 :
Partial dependency Partial dependency
1.1
Order Customer Sales Product Quantity Unit Total Unit Total Profits
Date Representative Price Sales Cost Cost
Partial dependency Transitive Transitive dependency
m
dependency
er as
co
eH w
o.
rs e
ou urc
o
1.2
aC s
vi y re
Orders Quantity
ed d
ar stu
Customer Sales Representative
sh is
Th
Product Unit Price Total Sales Unit Cost Total Cost Profits
1.3
Orders Quantity
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:39:15 GMT -05:00
Downloaded by: hlogzaogza |
Distribution of this document is illegal
https://www.coursehero.com/file/74564718/Exam-ICT3621-700553-2020pdf/
EXAM
PACK
2024
LATEST EXAM PACK QUESTIONS AND
ANSWERS AND SUMMARIZED NOTES
FOR EXAM PREPARATIONS.
UPDATED FOR 2024 EXAMS!!
, Stuvia.com - The study-notes marketplace
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 SALES
UNIT 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 Mahlangu
Fritos 150 120 R18 000 R100 R15 000 R3 000
04-Aug ChoppeesThapelo Mokgothu
Snack Bar 120 R70 R8 400 R55 R6 600 R1 800
o
18-Aug Walmart Peter Phetla Sun Cracks 450 R50 R22 500 R40 R18 000 R4 500
aC s
05-Sep Walmart Thapelo Mokgothu
Ruffles 769 R120 R92 280 R100 R76 900 R15 380
v i 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
s h is
1.1 Create a dependency diagram using the above table. [15]
Th
1.2 Create a dependency diagram that is in 2NF. [5]
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/
Downloaded by: hlogzaogza |
Distribution of this document is illegal
, Stuvia.com - The study-notes marketplace
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
v i y re
ed d
ar stu
s h is
Th
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/
Downloaded by: hlogzaogza |
Distribution of this document is illegal
, Stuvia.com - The study-notes marketplace
Exam ICT3621 700553 2020/2
Student: 56661118
Question1 :
Partial dependency Partial dependency
1.1
Order Customer Sales Product Quantity Unit Total Unit Total Profits
Date Representative Price Sales Cost Cost
Partial dependency Transitive Transitive dependency
m
dependency
er as
co
eH w
o.
rs e
ou urc
o
1.2
aC s
vi y re
Orders Quantity
ed d
ar stu
Customer Sales Representative
sh is
Th
Product Unit Price Total Sales Unit Cost Total Cost Profits
1.3
Orders Quantity
This study source was downloaded by 100000799301222 from CourseHero.com on 10-16-2021 00:39:15 GMT -05:00
Downloaded by: hlogzaogza |
Distribution of this document is illegal
https://www.coursehero.com/file/74564718/Exam-ICT3621-700553-2020pdf/
