Week1_Tutorial
.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
4
Uploaded by ElderTitanium8792
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 database is a structured collection of data that is organized and stored electronically.
b.
Table/Relation:
A table, also known as a relation is a structured representation of data organized in rows and columns.
c.
Record/Row/Tuple:
A record, row, or tuple refers to a single instance of data within a table.
d.
Primary key:
A primary key is a unique identifier for each record in a table.
e.
SQL:
SQL is a specialized programming language used for managing and manipulating relational databases.
2.
Briefly describe the function of the DBMS in a database system.
Ans: The Database Management System (DBMS) serves as the intermediary between users and the database, providing an interface for users to interact with the database without needing to understand its internal complexities. Its functions include:
a)
Data Definition: DBMS allows users to define the structure of the database, including creating tables, specifying data types, defining relationships between tables, and setting constraints.
b)
Data Manipulation: DBMS enables users to insert, update, delete, and retrieve data from the database using query languages like SQL (Structured Query Language).
c)
Data Storage: DBMS manages the storage of data on disk or in memory, optimizing
storage allocation and retrieval for efficiency and performance.
d)
Data Security: DBMS ensures data security by providing mechanisms for user authentication, access control, encryption, and data integrity constraints.
e)
Concurrency Control: DBMS handles multiple users accessing the database simultaneously, ensuring that transactions are executed in a controlled manner to maintain data consistency and integrity.
f)
Backup and Recovery: DBMS facilitates backup and recovery procedures to protect
data against loss or corruption, allowing for the restoration of the database to a previous state in case of failure or disaster.
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