Podcast
Questions and Answers
A flat database stores data in multiple connected tables.
A flat database stores data in multiple connected tables.
False (B)
A field in a database contains a group of related records.
A field in a database contains a group of related records.
False (B)
Primary key is a field that holds a unique identifier for each record in the database.
Primary key is a field that holds a unique identifier for each record in the database.
True (A)
Each table in a database consists of categories called records.
Each table in a database consists of categories called records.
It is common practice to create a new field specifically for the primary key in a database.
It is common practice to create a new field specifically for the primary key in a database.
A primary key allows you to refer to multiple entries in a table.
A primary key allows you to refer to multiple entries in a table.
Databases are stored in 1s and 0s.
Databases are stored in 1s and 0s.
Data structures are used in computers to organize 1s and 0s.
Data structures are used in computers to organize 1s and 0s.
Characters like 'orange' or 'love' represent concepts in databases.
Characters like 'orange' or 'love' represent concepts in databases.
Anomalies in poorly planned databases make handling data easier as the database grows.
Anomalies in poorly planned databases make handling data easier as the database grows.
Normalisation is a process to efficiently organize data in a database.
Normalisation is a process to efficiently organize data in a database.
According to Edgar F Codd, the inventor of relational databases, the goals of normalisation do not include data consistency.
According to Edgar F Codd, the inventor of relational databases, the goals of normalisation do not include data consistency.
