Scribd
Upload
300 views3 pages

CN3032 Databases Tutorial

This document provides instructions for students to complete two sections - Section A with 10 multiple choice questions about databases and files, and Section B with 3 comprehension questions. Section A questions are based on Chapter 8 of the recommended textbook and cover topics like relational database design, database storage units, keys, database paradigms, and relational algebra functions. Section B asks students to explain database management systems and the advantages/disadvantages of storing student records in a database, as well as relational algebra concepts and their use in queries.

Uploaded by

Tendai Chingeya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
300 views3 pages

CN3032 Databases Tutorial

This document provides instructions for students to complete two sections - Section A with 10 multiple choice questions about databases and files, and Section B with 3 comprehension questions. Section A questions are based on Chapter 8 of the recommended textbook and cover topics like relational database design, database storage units, keys, database paradigms, and relational algebra functions. Section B asks students to explain database management systems and the advantages/disadvantages of storing student records in a database, as well as relational algebra concepts and their use in queries.

Uploaded by

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

CN3032

Files and Databases.


Please complete Section A and Section B and upload on link on the Moodle site
under week 4. Both sections are 5 Marks each.

Section A: Multiple Choice Questions

These questions are based on chapter 8 of the recommended text book (An Introduction to
Information Systems by David Whiteley)

1. The relational approach to database design is accredited to:


a. Bill Gates
b. Thomas Edison.
c. Alan Turing
d. Edgar Codd.
e. No correct answer.

2. The typical unit of data written to and read from a disk is a:


a. File
b. Block
c. Record
d. Byte
e. None of the above

3. On a relational database, the associations between two relationships is established by the:


a. Foreign key
b. Hash key
c. Primary key
d. Linked list
e. None of the above

4. Popular databases such as Microsoft Access and Oracle are based on which of the following
paradigms?
a. Hierarchical
b. Network
c. Object-oriented
d. Relational
e. None of the above

5. Which of the following relational algebra functions select columns from an existing table?
a. Restrict
b. Project
c. Join
d. Select
e. None of the above.
6. Complete the following sentence. Secondary storage is any ______________ to which the
computer can write data.
a. medium
b. material
c. method
d. model
e. None of the above

7. Complete the following sentence: With a database, we are attempting to build a data
__________?
a. framework
b. platform
c. structure
d. warehouse
e. None of the above

8. Which of the following is an attribute in an entity that identifies a related record?


a. Home key
b. Primary key
c. Secondary key
d. Foreign key
e. None of the above

9. A method of achieving direct access to data held on files or a database is known as


___________?
a. Locked random
b. Sign random
c. Hash random
d. Back random
e. None of the above

10. The three traditional database paradigms are hierarchical, relational and __________?
a. network
b. neutral
c. Alphanumerical
d. sequenced
e. None of the above
Section B Comprehension questions

1. The University Student Record System uses a Database Management System (DBMS) to
store details of students and their progress through their studies.
a. What is a DBMS?
It is a file management system that collects all the organisation data within one file
and provides sophisticated way to access that data.
b. Explain the advantages and disadvantages of having student records stored on a
database
Advantages
 Inconsistency can be avoided: Duplicating data and making changes are
made at one site, which is not propagated to the other site, it gives rise to
inconsistency and the two entries.
 Improved data access: Different users can access or retrieve data on
demand using the applications and interfaces provided by the DBMS
Disadvantage
 Cost of DBMS: The cost varies significantly, depending on functionality
provided and there is also the recurrent annual maintenance cost.
 Size: The functionality that makes the DBMS may be extremely large piece of
software, occupying many megabytes of disk space and requires a lot of
memory to run efficiently

2. SQL queries employ the relational algebra concepts of select, restrict and join. Explain each
of these concepts and their use in extracting information from a database.
Select: The SELECT statement is used to select data from a database.
Restrict: A value cannot be updated or deleted when a row exists in a referencing or child
table that references the value in the referenced table.
Join: A JOIN clause is used to combine rows from two or more tables, based on a related
column between them.

3. For the order processing database, used as in an example in this chapter, which relational
algebra function would you use to:
a. List all products where the stock (prodStock) is 10 or less
SELECT * From product Where proStock<=10;

b. List the product code (prodCode) and warehouse location (whseLocn) of all
products.
SELECT FROM Product where prodCode, whselocn

c. List all products and include the corresponding product category data (prodcatDesc)
for each product

SELECT*FROM product where ProdcatDesc

You might also like