INF2603 Latest exam pack questions and answers and summarized notes for exam preparation. Updated for 2024 exams . For assistance Whats-App.0.6.7..1.7.1..1.7.3.9 . All the best on your exams!!
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 5 pages.
Instructions:
1. Answer all questions.
2. The marks for each question are given in brackets next to the question.
3. Please answer the questions in the order in which they have been set.
4. You signed an Honesty Declaration. This means you will complete this paper on
your own and without help.
5. This final pdf document should not be password protected.
6. Convert all the pages into a single PDF file.
7. Poorly scanned and hard to read answer files will result in a zero mark.
8. Once your document meets all the criteria, then you can upload the file to myAdmin.
GOOD LUCK.
, 2
INF2603
OCTOBER/NOVEMBER 2023
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. 11. (e)) (2 marks each):
1. The _____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. unique index
b. database tuple
c. system catalogue
d. systematic database
2. Within the relational model, tables are known as ____, columns of tables are referred
to as ____ and rows of tables are called ____.
a. tuples, attributes, entities
b. relations, attributes, tuples
c. relations, tuples, attributes
d. relation, attributes, tuples
3. Which of the following returns all tuples in one relation that are not found in the other
relation?
a. PRODUCT
b. SELECT
c. PROJECT
d. DIFFERENCE
4. The STUDENT table’s primary key is STUDENT_NUMB. The STUDENT primary key
column has no null entries, and all entries are unique. This is an example of _____
integrity.
a. null
b. entity
c. relational
d. referential
5. Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.
6. 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.
TURN OVER
, 3
INF2603
OCTOBER/NOVEMBER 2023
7. 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
8.The Chen notation identifies a weak entity by using a double-walled entity rectangle.
a. True
b. False
9. Which of the following special operator checks whether an attribute value matches any
value within a value list?
a. IN
b. LIKE
c. EXISTS
d. BETWEEN
10. If the attribute (A) is functionally dependent on a composite key (B) but not on any
subset of that composite key, the attribute (A) is fully functionally dependent on (B).
a. True
b. False
QUESTION 2 [15 marks]
Briefly explain what is meant by each of the following terms in a database design context
and provide an example. Do not copy examples from the book. (explanation = 2,
example =1 mark):
a. Atomic attribute
b. Recursive relationships
c. Disjoint subtypes
d. Granularity
e. OODM (object-oriented data model)
QUESTION 3 [12 marks]
a. Describe the entity-relationship model. How are entities, relationships, and attributes
represented in this model? What is a composite entity? Describe the approach to
diagrams that use a crow’s foot or UML. Describe how you would represent cardinality
in an E-R diagram. (12)
TURN OVER
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 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.
