100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
INF3703 Assignment 02 2022 Real Case Study Report $5.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. University Of South Africa (Unisa)
  4.  
  5. INF3703 - Databases II (INF3703)

Other

INF3703 Assignment 02 2022 Real Case Study Report
 37 views  2 purchases
  • Course
  • INF3703 - Databases II (INF3703)
  • Institution
  • University Of South Africa (Unisa)
  • Book
  • DATABASE PRINCIPLES

This document is a summary of a Real Case Study done on an Organization pertaining the Assignment 02 for INF3703. It gives an idea of the the steps that should be taken before jumping into writing the assignment itself.

Preview 1 out of 20  pages

Document information

  • June 27, 2022
  • 20
  • 2021/2022
  • Other
  • Unknown

Subjects

  • real case study

Connected book

book image

Book Title:

Author(s):

  • Edition:
  • ISBN:
  • Edition:

More summaries for

  • INF3703 Assignment solutions 2024
  • 2024 INF3703 Assignment 1 solutions
  • INF2630 Comprehensive Exam and Study Pack: Worked Out Exam Papers from 2017 until October 2022 plus past assignments.
All for this textbook (9)

Written for

  • University of South Africa (Unisa)
  • INF3703 - Databases II (INF3703)
All documents for this subject (52)

Seller

avatar-seller
JayJo

Reviews received

Content preview

TABLE OF CONTENTS PAGE


1. DESCRIBING THE ORGANISATION SITUATION
1.1. Organisation full address 3
1.2. Organisation mission or business objectives 3
1.3. Organisation general operating environment 3

1.4. Organisation structure 4
2. DEFINING PROBLEMS AN CONSTRAINS
2.1. Description of the challenges facing the organisation 5
2.2. Identify the project constraints 5

3. PROJECT OBJECTIVES 6
4. PROJECT SCOPE AND BOUNDARIES PERMISSION 6
5. SOURCES OF INFORMATION 7
6. INFORMATION COLLECTED AND PROCESSED 7
7. PROPOSED BUSINESS RULES 8
8. DATABASE DESIGN APPROACH 9
9. CONCEPTUAL DATABASE DESIGN
9.1. Main entities 9
9.2. Primary and foreign keys 10
9.3. Normalised entities 10

9.4. ER diagram 11
10. LOGICAL DATABASE DESIGN
10.1. Relational model 12

11. PHYSICAL DATABASE DESIGN
11.1. Composite/Transaction usage map 13

11.2. Estimation of hard disk space 13
12. DEFINE AND EXPLAINED TRANSACTIONS 14
13. FORMULATE POSSIBLE SQL STATEMENTS FOR THE DATABASE 14
14. DISCUSSION OF DIFFERENT DATABASE PERFORMANCE TURNING
METHODS/CONCEPTS 16
15. QUESTIONS AND ANSWERS

15.1. Challenges Encountered and How They Were Handled 17
15.2. Question and Answers 17
16. DECLARATION 19

1
INF3703_ASS02_2020

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 JayJo. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

53068 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
$5.49  2x  sold
  • (0)
Add to cart
Added