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
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
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.
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
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
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 this summary 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 this summary for R50,00. You're not tied to anything after your purchase.
