Inf3703 Assignment 2

From WikiStudent

You are here:Main Page > Unisa Modules > Information Systems > INF3703

Jump to: navigation, search

Online Dating in South Africa

Principles of databases


A database is a storage of data. Databases consist of tables, which each have descriptive fields (such as 'name', 'address', 'phone') and rows of data, where the actual information is placed. Database design involves first analysing how you need to store and access your data (which tables need to be linked to which, etc) before you go ahead and create the actual database.

INF3703 is one of those modules with a theory side as well as an application side, here in the form of case studies. Entity-Relationship Diagrams are used to model the database design.

The prerequisites for this module are either COS2611 or ICT2622.

The Unisa syllabus

  1. Database systems and data models (Chapters 1 and 2 need not be studied for the exam)
  2. The relational database model (Chapter 3)
  3. Entity relationship (ER) modelling (Chapter 5)
  4. Advanced data modelling (Chapter 6)
  5. Normalisation of database tables (Chapter 7)
  6. Transaction management and concurrency control (Chapter 12)
  7. Distributed database management systems (Chapter 14)
  8. Database connectivity and Web development (Chapter 16)

The INF3703 textbook

Prescribed textbook

Recommended reading

The INF3703 exam

Past exam papers

The exam in Oct/Nov 2009

The exam in Oct/Nov 2007

The exam was similar to past exams and followed the format of Chen ERD (20 marks) (The Airport Co.), a dependency diagram, with no denormalization (10 marks) and the rest was the theory evenly spread through the chapters (10 marks a section). The theory was very similar to the questions asked in the assignments. One of the questions that was asked was 4 phases of data mining.

Tip: Don't spend to much time on drawing the ERD diagram since you will not have enough time to complete the exam.

The exam in Oct/Nov 2004

They were giving away 40% in this exam: A 20-mark case study that came straight from the previous year's exam (to which we had the solutions), plus 20 marks in very easy multiple-choice. A lot of people thought it was a nasty paper, but it was easy to pass.

The exam in Oct/Nov 2003

  • Question 1: A case study about an insurance company
  • Question 2: Mapping an ER diagram into a relational model
  • Question 3: A dependency diagram that we had to convert to 3NF
  • Question 4: Concurrency control (explain what it is and give the 3 most common concurrency problems)
  • Question 5: Data fragmentation (define and illustrate it using a given relation)
  • Question 6: Client-server architecture
  • Question 7: Convert an ERD into the OO equivalent
  • Question 8: Mini case-study
  • Question 9: XML (discuss DTD and correct some XML)

The exam in Oct/Nov 2002

This year the case study was about a Dinner Club. We had to know the advantages and disadvantages of the OODMS. A nice paper overall.

The exam in Oct/Nov 2001

There were 9 questions (100 marks), and the exam started off with a case study where we had to draw an ERD. Other diagrams we had to draw were a dependency diagram, and 3NF relations. On the theory side, we had to compare the OO data model with the relational model (table format) and also the differences between MOLAP and ROLAP.

How to pass INF3703

Study tips

Useful links

Study notes

Download notes

Create notes online

Student opinions

Student survey

Pros of INF3703

Cons of INF3703

Categories: Unisa Modules | Completed Modules | Information Systems

Submission of some semester 2 assignments extended to Monday 21 August 2017

We are aware that your registration may have been finalised after the closing date for semester 2 registrations and that you may, therefore, have missed some assignment submission dates.

To ensure that every Unisa student has the opportunity to submit their assignments, the submission cut-off date for all assignments scheduled before 21 August 2017 has been changed to 21 August 2017. Unisa will therefore accept, mark and process your assignments until 21 August 2017 if you are unable to submit them by the published due dates. We urge you to submit your assignments as per the original submission dates, if at all possible, to prevent an overload of the myUnisa system on 21 August 2017.

This extension is applicable to all assignments that contribute to admission to examinations, but excludes blog and discussion forum assignments. All assignments due after 21 August 2017 must be submitted by the relevant due dates as indicated in your Tutorial Letters 101.

0 Replies to “Inf3703 Assignment 2”

Lascia un Commento

L'indirizzo email non verrĂ  pubblicato. I campi obbligatori sono contrassegnati *