Scribd
Upload
53 views

Tutorial Week 2 - Introduction To Database

This document provides a tutorial on database management systems (DBMS). It asks students to distinguish between data, information, and knowledge, with data being what is stored in a database. Students are tasked with creating a spreadsheet based on a template to store student records, including entering the class timetables of two classmates, and then discussing the redundancies and anomalies caused by this design. The tutorial covers important features of DBMS like storage and retrieval and challenges of file systems for managing information.

Uploaded by

Jack
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
53 views

Tutorial Week 2 - Introduction To Database

This document provides a tutorial on database management systems (DBMS). It asks students to distinguish between data, information, and knowledge, with data being what is stored in a database. Students are tasked with creating a spreadsheet based on a template to store student records, including entering the class timetables of two classmates, and then discussing the redundancies and anomalies caused by this design. The tutorial covers important features of DBMS like storage and retrieval and challenges of file systems for managing information.

Uploaded by

Jack
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/ 1

WIA2001/WIB2001

DATABASE
SEM 1, 2021/2022

Tutorial 1

1. Storage and retrieval are among the key features of DBMS. Why are they
important?

2. Distinguish between data, information and knowledge. Which one is stored in the
database?

3. What are the problems associated with file systems? How do they challenge the
types of information that can be created from the data as well as the accuracy of
the information?

4. Answer the following questions :


MatricsNo Name CourseCode CourseName CreditHours LecturerName ClassDays ClassTime Venue

a. Create a spreadsheet using the template shown in Table 1.0 above and enter
required information
b. Enter the class time table of two of your classmates into the same
spreadsheet.
c. Discuss the redundancies and anomalies caused by this design

You might also like