Week1_Tutorial_ICT200_T124 (1)
.docx
keyboard_arrow_up
School
King's Own Institute *
*We aren’t endorsed by this school
Course
200
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by DoctorGrasshopper4311
Questions extracted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer , 14
th
ed, Global Edition, Pearson
ICT200 Tutorial Compiled by: Anupam Makhija
ICT103: Tutorial 1
Compiled by: Shaleeza Sohail
T1 2024: ICT200 Database Design and Development
Tutorial: Week 1
Topic: Overview of Database concepts
Submission: Five minutes before the end of the tutorial.
Instructions: Form a group of 2-4 students and complete the following group activities.
After the discussion, each student answers the questions individually in their
own words. Every student must upload the answer file on Moodle
individually.
Part A: Multiple-Choice Questions
1.
The predecessors of database processing were ________.
a.
file managers
b.
hierarchical models
c.
network models
d.
relational data models
2.
What closely describes ‘redundancy’?
a.
Unwanted data
b.
Duplicate data
c.
Integrated data
d.
Structured data
3.
Which statement is not
true about the relational model?
a.
It was first proposed in 1970.
b.
It was developed by E. F. Codd.
c.
It was developed at Oracle.
d.
It resulted in the DBMS product DB2.
4.
Which of the following stores all of the data in the database?
a.
Field
b.
Table
c.
Query
d.
Record
5.
Which of the following is an example of a relational database management system?
a.
MongoDB
b.
Cassandra
c.
MySQL
d.
HBase
Questions extracted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer , 14
th
ed, Global Edition, Pearson
ICT200 Tutorial Compiled by: Anupam Makhija
ICT103: Tutorial 1
Compiled by: Shaleeza Sohail
Part B: Short Answer Questions
1.
Define the following terms:
a.
Database: A structured collection of data stored in a computer system for easy access,
management, and updating.
b.
Table/Relation:
A set of data organized in rows and columns, where each column is an
attribute and each row is a record.
c.
Record/Row/Tuple: A single, complete set of related data items in a table, represented by a row.
d.
Primary key:
A unique identifier for each record in a table, ensuring no two records have the same value in this column.
e.
SQL:
A programming language used for managing and manipulating relational databases.
2.
Briefly describe the function of the DBMS in a database system.
Answer:
A Database Management System (DBMS) serves as the intermediary between the user and the database, managing data, the database engine, and the database schema, to facilitate the organization, storage, retrieval, security, and integrity of data in a structured way. It supports various operations such as data insertion, querying, update, and administration, ensuring efficient data management and access while maintaining data consistency, security, and recovery mechanisms.
3.
What are the different components of a database system? Answer:
A database system typically consists of several key components that work together to ensure efficient data management and access:
1.
Database Application:
Interfaces and tools for users to interact with the database.
2.
DBMS Software:
Manages access, queries, updates, and organizes data.
3.
Database:
The structured collection of data itself.
4.
Database Schema:
The blueprint or architecture defining the database's logical structure.
5.
Data Storage:
Physical storage solutions for data (disks, SSDs).
6.
User and Database Administrator (DBA):
People who use and manage the database system.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help