11.4.1.1 describe relational databases and their purpose

11.4.1.4 define data types when creating a database

11.4.1.2 use the terms attribute, object, index, record, table, and tuple to describe databases 

Relational databases

A database is an organized collection of structured information

A relational database is a type of database that organizes data into structured tables, which are related to each other through common fields.

A relational database is a collection of data with predefined relationships between them. Database data is organized as a set of tables, consisting of columns and rows.

The tables store information about the entities represented in the database.

Each column of the table stores a specific data type, each cell contains the value of an attribute.

Each table is a collection of related values ​​that refer to a single object or entity.

Each row in a table can be labeled with a unique identifier called a primary key, and rows from multiple tables can be linked using foreign keys. This data can be accessed in many ways, without reorganizing the database tables.

Table is a collection of related data held in a structured format within a database.

Entity is a real-world object or concept that can be distinctly identified.

Field (Attribute) is one characteristic of an entity or an object in a database. (such as name, date of birth, or telephone number)

Record (Tuple) is all characteristics of one object.

Index is a value of the key field that helps database management systems to find and sort records quickly.

Primary key is the unique identifier for each record in a table.

Install XAMPP

What is XAMPP? XAMPP is the most popular PHP development environment, consisting of

• Database phpMyAdmin
• Local Server Apache
• other applications

Database MySQL in phpMyAdmin

phpMyAdmin is one of the most popular applications for MySQL database management. It is a free tool written in PHP. You can create, alter, drop, delete, import, and export MySQL database tables.

Study Data types

Study Primary key & Composite key

Questions:

1. Explain the term "relational database".

2. Provide examples of databases.

3. Give definitions for "table", "entity", "attribute", "record", "primary key", "index".

Exercises:

Ex. 1 "Terms & Definitions" (6 tasks)

Ex. 2 "Components of database"

Exam questions: