IT

Question 1

Database?

Answer 1

An organised collection of data regarding a specific topic. More specifically a database is an electronic system that allows data to be easily stored organise processed and changed

Question 2

DBMS?

Answer 2

A database management system is a collection of programs that enables us to create and maintain a database. it is a general-purpose software system that facilitates the process of defining constructing and manipulating database for various applications a database system consists of a combination of dbms and a database

Question 3

Distributed database?

Answer 3

A database that will be stored in Multiple computers located in the same physical location or dispersed over a network of interconnected computers

Question 4

Cloud?

Answer 4

Is a network of remote servers hosted on the internet to store manage and process data

Question 5

DB field?

Answer 5

The part of a record which contains a single piece of data for the subject of the record

Question 6

DB Primary key?

Answer 6

A field that uniquely identifies each record in the table

Question 7

Composite/Combined primary key?

Answer 7

Is a set of more than one key that together uniquely identifies each record

Question 8

Data-types of fields?

Answer 8

This is the type of data of the input data of that field

Question 9

DB Record?

Answer 9

A record that is composed of Fields and contains all the data about one particular person company or item in a database

Question 10

DB Table?

Answer 10

A database table is composed of Records and fields that hold data. Each table in a database holds data about a different but related subject

Question 11

DB Relationships?

Answer 11

This is a situation that exists between two relational database tables when One table has a foreign key as references primary key of the other table.

Question 12

Information System?

Answer 12

Any organized system for the collection, organisation, storage and communication of information.

Question 13

Ethics?

Answer 13

Refers to the right and wrong actions of an individual acting on fuel using choice to determine their behaviour

Question 14

Mobile offices?

Answer 14

These are temporary offices that are designed to be transported or moved easily

Question 15

Decentralization of labour?

Answer 15

This means that people no longer have to be together in an office to perform many different types of jobs. People can work at home and avoid wasting their time by sitting in traffic everyday

Question 16

AI?

Answer 16

Artificial intelligence refers to a field of computer studies in which program is tried to create or simulate human intelligence in machines

Question 17

Privacy?

Answer 17

This is defined as a person’s ability to control how information about them is shared with other people or institutions

Question 18

POPI act

Answer 18

Protection of Personal information act

Question 19

Database administrator?

Answer 19

This is a person responsible for managing the database of a company
Responsibilities:
Build and Design database
Creating and defining users

Question 20

DB programmer?

Answer 20

This is someone who create databases and database queries
Responsibilities:
Creating database and database structures
Creating database queries

Question 21

DB analyst?

Answer 21

This is the person working for companies to identify opportunities to setup and improve their Data Systems.
Responsibilities:
Adding and removing Fields from existing databases
Plan how information will flow through the database

Question 22

DB Project manager?

Answer 22

The person who must make sure that any database projects are completed on time at the right cost and at the right quality level.
They develop project schedules and d3s9gn project goals

Question 23

Examples of distributed database?

Answer 23

Amazon web services or Google firebase