Week1_Tutorial_ICT200_T124 (1)

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.