Database Basics: Tables and Fields

In a flat database, data is stored in multiple connected tables.

A field holds a unique identifier for each record in the database.

Each table may have multiple primary keys to identify records uniquely.

Fields in a table represent the actual data being captured.

Primary keys in a database are usually created by modifying an existing field in a table.

In a well-run database, metadata is not considered valuable

Denormalized flat-file databases do not create problems when trying to insert, delete, or modify records

Edgar F Codd, the inventor of relational databases, did not emphasize the importance of normalisation

Data integrity becomes easier to maintain when anomalies occur in a poorly planned database

Binary data is always converted into human-readable format before it becomes meaningful information