100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
ICT3621 EXAM PACK 2023 $2.76
Add to cart

Exam (elaborations)

ICT3621 EXAM PACK 2023

1 review
 97 views  4 purchases
  • Course
  • Institution
  • Book

Latest exam pack questions and answers and summarized notes for exam preparation. for assistance. All the best on your exams!!

Preview 4 out of 197  pages

  • January 4, 2022
  • 197
  • 2022/2023
  • Exam (elaborations)
  • Questions & answers

1  review

review-writer-avatar

By: calvinkutama • 11 months ago

avatar-seller
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/

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller iStudy. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $2.76. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

52355 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$2.76  4x  sold
  • (1)
Add to cart
Added