Question $3$

$($Marks: $40)$

Principal Thabo is enthusiastic about the prospective development of a new information system for Mzansi High School. In this section, the goal is to help Thabo grasp database concepts and comprehend how they will be advantageous for the school's operations.

Q$3\mathrm{.}1$ Engage with Principal Thabo to explain the concept of a database and outline at

$(5)$

least two advantages of implementing a database in the context of the information system being developed for Mzansi High School.

Q$3\mathrm{.}2$ To facilitate Principal Thabo's understanding of databases and database

$(15)$

management systems at Mzansi High School, utilize an infographic that presents a clear list and explanation of the hierarchy of data. Ensure the infographic is designed for easy comprehension and list the data hierarchy in the order from the smallest to the largest.

Note: Remember to reference the sources used in the infographic

Q$3\mathrm{.}3$ Create sample tables for the information system to be implemented at Mzansi

$(20)$

High School. Include the following details for the sample database:

Specify table names.

Specify fields for each table $($up to $4$ fields per table$).$

Specify the primary keys for each table.

Specify foreign keys wherever applicable.

Populate the tables with at least two records.