Introduction to Databases

A compilation of key concepts and definitions related to databases and database management systems.

What is a database?

An organized collection of logically related data.

What are the four levels of the hierarchy of data in a database?

Tables, Records, Fields, Characters/Bytes.

What is a table in a database?

A table contains related records organized in rows and columns.

What does a record correspond to in a database?

A record corresponds to a row in a table.

What is a field in a database?

A field corresponds to a column name in a table.

What is a field value in a database?

A field value corresponds to a cell in a table.

Why do organizations use databases?

To efficiently manage large amounts of data for improved service delivery and informed decision-making.

What is a Database Management System (DBMS)?

A software program that manages data in electronic format, and is used to define, administer, and process databases.

What does a complete school database consist of?

Multiple linked tables, such as a Student Personal Info Table and a Student-Grade Table.

How does DBMS help in data management?

It retrieves and updates data as requested by users or applications.

What are some examples of industry standard DBMS tools?

MariaDB, Oracle, Microsoft Access, Microsoft SQL Server.

What is the significance of structured data in decision-making?

Organized data provides the foundation for well-informed decision making.