Database

Database

1. A database is a persistent organised store of data that is used on a computer system.

2. A database field is the structure to contain a single item of data.

3. A relational database is where it is contained in more than one table. Tables are then joined by linking a primary key in one table to a foreign key in another table.

4. A primary key is a unique identifier such as a code number that can be used to identify each record in a database table.

5. A foreign key is a field in a table which can be linked to the primary key of another table to from a relationship.

6. An entity is an object that we store data about, such as a customer or a product. It becomes a table in a database.

7. Data redundancy is where data is repeated unnecessarily in a database.

8. Flat-file database is a single-table databases are often referred to as flat-file databases; they are easy to understand but can cause problems and errors.

9. A DBMS is a management system (DBMS) is a software application designed to interact with database users, capture and extract and also analyse data, it also interacts with other software applications.