Exam (elaborations)
INF2603 EXAM PACK 2024
- Course
- Institution
LATEST EXAM PACK QUESTIONS AND ANSWERS AND SUMMARIZED NOTES FOR EXAM PREPARATIONS. UPDATED FOR 2024 EXAMS.
[Show more]
Seller
Follow
examexpert01
Reviews received
Content preview
INF2603EXAM
PACK 2024
LATEST EXAM PACK QUESTIONS AND
ANSWERS AND SUMMARIZED NOTES FOR
EXAM PREPARATIONS.
UPDATED FOR 2024 EXAMS.
, 2
Stuvia.com - The study-notes marketplace
INF2603
October/November 2022
QUESTION 1 [20 marks]
Carefully select the most correct answer to each of the following questions. Please write
down only the question number and corresponding to it put the correct option’s number
(e.g. Qu. 1 (e)).
1. Which of the following is NOT a true statement about constraints:
a. Constraints are important because they help to ensure data integrity.
b. Constraints support high-level inserts, updates and deletes.
c. Constraints are normally expressed in the form of rules.
d. A constraint is a restriction placed on the data.
2. The logical view of the relational database is facilitated by the ____.
a. objects defined by the database wizard
b. file system used by the operating system
c. creation of queries using the database wizard
d. creation of data relationships based on a construct known as a table
3. ______ is a common term used in traditional entity relationship modelling, and is used to express
the maximum number of entity occurrences associated with one occurrence of the related entity.
a. Participation
b. Cardinality
c. Multiplicity
d. Association
4. What is the purpose of an entity cluster?
a. define physical database storage for related entities
b. group related entities into a single table
c. improve readability of the ERD
d. make the ERD more complex
5. A query language is a procedural language.
a. True
b. False
6. Business rules apply to businesses and government groups, but not to other types of organisations
such as religious groups or research laboratories.
c. True
d. False
7. In the object-oriented data model (OODM), both data and their relationships are contained in a single
structure known as a(n) ____.
a. entity
b. attribute
c. Constraint
d. Object.
TURN OVER
Downloaded by: modiehimokoena994 | modiehimokoena994@gmail.com Want to earn
Distribution of this document is illegal R13,625 per year?
, 3
Stuvia.com - The study-notes marketplace
INF2603
October/November 2022
8. Which of these is NOT a property of a relation?
a. Each table column represents an attribute, and each column has a distinct name.
b. The order of the rows and columns is important within a DBMS.
c. A table is perceived as a two-dimensional structure composed of rows and columns
d. Each column has a specific range of values known as the attribute domain.
9. Which attribute(s) make up the primary key in the table definition CLASS (CRS_CODE,
CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)?
a. CRS_CODE
b. CLASS_SECTION
c. CRS_CODE and CLASS_SECTION
d. there is no primary key.
10. Which statement about NULL values is NOT True?
a. A null does not mean a zero or a space.
b. Nulls should be avoided where ever possible
c. The existence of nulls in a table is often an indication of poor database design.
d. To maintain entity integrity, a null ‘value’ is permitted in the primary key.
QUESTION 2 [14 marks]
a. What are the six levels on which the quality of data can be examined? (6)
b. Given the below table structure, what data redundancies do you detect, and how could these
redundancies lead to anomalies? (6)
Table 2.1 The file structure for Problem 2b
PROJ_NUMB PROJ_NAME EMP_NUM EMP_NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_CELLPHONE
101 Mogamolo 2011 Previn B. Mochabo ZCM R1300.00 17.7 083-691-6060
101 Mogamolo 2051 Tumy A. Seoka KZN R800.00 20.6 072-369-9935
101 Mogamolo 2101 Charlotte P. Mkhize KZN R800.00 18.7 011-670-9085
102 Savana 2011 Previn B. Mochabo ZCM R1300.00 24.2 083-691-6060
102 Savana 2081 Thabo P. Mtsweni ZCM R1300.00 21.9 072-227-3895
103 Nuclear 2101 Charlotte P. Mkhize KZN R840.00 15.0 011-670-9085
103 Nuclear 2051 Tumy A. Nxumalo KZN R120.00 27.8 072-369-9935
103 Nuclear 2231 Daphny M. Zulu ZCM R1300.00 23.5 065-155-6553
103 Nuclear 2121 Mampilo M. Seoka BEE R1300.00 25.1 081-021-9504
c. What is an unnormalized relation? (2)
TURN OVER
Downloaded by: modiehimokoena994 | modiehimokoena994@gmail.com Want to earn
Distribution of this document is illegal R13,625 per year?
, 4
Stuvia.com - The study-notes marketplace
INF2603
October/November 2022
QUESTION 3 [16 marks]
a. Briefly explain what is meant by the term data governance? (2)
b. What is a table and what role does it play in the relational model? (4)
c. What is the role of a DBMS, and what are its advantages? (10)
QUESTION 4 [10 marks]
a. BTEE Shuttle Services is considering changing the way it handles reservations. Instead of storing
the number of persons associated with one reservation, the company would like to store the name
and address of each person associated with each reservation. If BTEE Shuttle Services decides to
implement this change, the trip price and other fee amounts for each trip would be deponent on
only the trip ID. Determine the multivalued dependencies in the following table, and then
converted this table to an equivalent collection of tables that are in fourth normal form:
RESERVATION (RESERVATION_ID, TRIP_ID, TRIPDATE, TRIPDATE, TRIP_PRICE,
OTHERFEES, (CLIENT_NUMB, CLIENT_SURNAME, CLIENTFIRSTNAME,
ADDRESS, CITY, PROVINCE, POSTAL_CODE, PHONE)) (10)
QUESTION 5 [30 marks]
Suppose you need to track data for mountain climbing expeditions. Each member of an expedition is
called a climber, and one of the climbers is named lead an expedition. Climbers can be members of many
expeditions over time. The climbers in each expedition attempt to ascend one or more peaks by scaling
one of the many faces of the peaks. The data you need to track includes the name of the expedition, the
leader of the expedition, and comments about the expedition; the first name, last name, nationality, birth
date, death date, comments about each climber; the name, location ,height, and comments about each
peak; the name and comments about each face of a peak; comments about each climber for each
expedition; and the highest height reached and date for each ascent attempt by a climber on a face with
commentary.
a. Without creating a set of dependency diagrams, write the relational schema that meet 3rd NF
requirements. (6)
b. Draw the entity-relationship diagram using UML notation for the expedition database. (24)
Make sure you include all appropriate entities, relationships, connectivities and cardinalities .
TURN OVER
Downloaded by: modiehimokoena994 | modiehimokoena994@gmail.com Want to earn
Distribution of this document is illegal R13,625 per year?
The benefits of buying summaries with Stuvia:
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
You can quickly pay through 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 these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller examexpert01. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.50. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77333 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now