SLR 10 Flashcards
What is a database
An organised collection of data
What is a flat file database
A database with only one table, often stored as comma-separated values (CSV) files.
Suitable for storing small amounts of data
Can become very inefficient, with repetitive data.
What are the three kinds of relationships between tables
one-to-one
one-to-many
many-to-many (not good table design)
What is a relational database
a collection of tables in which relationships are modelled by shared attributes
WHat is a primary key
one or more attributes that uniquely identify a particular record in the table.
WHat is a foreign key
An attribute in a table that is the primary key of another table
WHat is normalisation
a processor to come up with the best possible design for a relational database
What is first normal form (1NF)
a table that contains no repeating attribute or groups of attributes
