[go: up one dir, main page]
Scribd
Upload
22 views1 page

ISTN212 Databases Tutorial 1 - Chapter 1

This tutorial provides practice questions related to databases and programming, focusing on concepts such as the difference between data and information, the importance of effective database design, and the functions of a Database Management System (DBMS). It also includes questions on data redundancy, anomalies, and practical problems related to a given file structure. Additionally, it references specific review questions from the textbook that are essential for understanding the material and preparing for exams.

Uploaded by

silindokuhleboyi6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views1 page

ISTN212 Databases Tutorial 1 - Chapter 1

This tutorial provides practice questions related to databases and programming, focusing on concepts such as the difference between data and information, the importance of effective database design, and the functions of a Database Management System (DBMS). It also includes questions on data redundancy, anomalies, and practical problems related to a given file structure. Additionally, it references specific review questions from the textbook that are essential for understanding the material and preparing for exams.

Uploaded by

silindokuhleboyi6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ISTN212 - Databases and Programming

Tutorial 1 (Chapter 1)

Instructions

These questions are designed to give you practice with the types of questions you can
expect in tests and examinations. The solutions are not one word answers and require
thought, analysis and the application of theory.

Questions

1. Explain the difference between data and information.

2. Explain, in business terms, why effective database design is so important. You should
also discuss the consequences of poor database design.

3. What is a DBMS, and what are its functions?

4. List the advantages and disadvantages of a DBMS

5. List and describes the main components of a Database System

6. Describe data redundancy and explain the three (3) types of data anomalies that may
exist due to redundant data.

7. Given the file structure below (adapted from Figure P1.1, page 32 of textbook), answer
the following problems:

PROJECT_CODE PROJECT_MANAGER MANAGER_PHONE MANAGER_ADDRESS PROJECT_BID_PRICE


21-5Z Holly B. Parker 904-338-3416 17 Church St, PMB, KZN, 3201 263516253.00
25-2D Jane D. Grant 615-896-9909 234 Pine Street, Durban, KZN, 2211 7236871263.00
25-5A George F. Dorts 615-227-1245 14 Seventh Avenue, Kennilworth, WC, 4433 217367213.00
25-9T Holly B. Parker 904-338-3416 17 Church St, PMB, KZN, 3201 123333.00
27-4Q George F. Dorts 615-227-1245 14 Seventh Avenue, Kennilworth, WC, 4433 213123.00
29-2D Holly B. Parker 904-338-3416 17 Church St, PMB, KZN, 3201 2767673.00
31-7P William K. Moor 904-445-2719 65 Old Main Road, JHB, Gauteng, 1234 5463275.00

1. How many records does the file contain? How many fields are there per record?

2. What problem would you encounter if you wanted to search for project managers
by city? How can this problem be solved by altering the structure?

3. What data redundancies do you detect? How could these redundancies lead to
data anomalies?

The following review questions from the textbook will not be covered in the tutorial session,
but deal with important concepts that lecturers will assume you are familiar with and ARE
EXAMINABLE in tests/examinations.

Chapter 1 (page 31-33): Questions 2, 3, 6, 8, 10, 12, 13, 14, 15, 16 and Problem questions
3, 5 – 10

You might also like