Week1_Tutorial

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.

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 5. Open Seek.com.au. Enter ‘Database’ as the keyword and search for the jobs. a. How many jobs are displayed? Ans: There are 6,658 jobs. b. What is the salary range you find there for Database jobs? Ans: The salary range I found there for Database jobs varies from 30k to 350k+ annually. c. What are the main key requirements for the jobs you have found? Ans: The main key requirements for the jobs I found are as follow;  Minimum 3 years’ experience within Database Administration  Strong knowledge of SQL Server  Knowledge of database systems in a cloud infrastructure environment  Knowledge of database security best practices and experience implementing security measures.  Great understanding of data modelling concepts and practices  ITIL Certification preferred  Advanced teamwork skills, must be able to connect with colleagues and work together toward common goals  Excellent time management skills with the ability to set priorities and follow direction to plan and organise. 6. Install SQL Server 2019 and SQL Server Management Studio on your computer. Watch the following YouTube videos and follow the instructions. Video: Instructions to install SQL Server https://www.youtube.com/watch?v=QsXWszvjMBM