1.3.1 Databases & SQL

“Allows the user to specify information about multiple tables and the relationship between those tables”

• Redundancy
• Record Locking
• ACID
• Transaction Processing
• Relational Database

“A database that allows the user to specify data attributes (columns, databases etc.) for only one table at a time, storing those attributes independently”

• Relational Database
• Redundancy
• Record Locking
• ACID
• Flat File

“A field that uniquely identifies a record in a table”

• Flat File
• Relational Database
• Redundancy
• Record Locking
• Primary Key

“The linking field in the foreign table formed when a relationship is made. The FK becomes by default the PK of the new table.”

• Primary Key
• Flat File
• Relational Database
• Redundancy
• Foreign Key

“When more than one field is added together to form a unique primary key for a table.”

• Foreign Key
• Primary Key
• Flat File
• Relational Database
• Concatenated Primary Key

“A key field which can be used to access a table in a different way”

• Concatenated Primary Key
• Foreign Key
• Primary Key
• Flat File
• Secondary Key

Entity Relationship Modelling: “The process of producing a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a data such as a relation database.”

• Secondary Key
• Concatenated Primary Key
• Foreign Key
• Primary Key
• ERM

“The process of arranging data in tables and setting their relationships to move them through normal forms”

• ERM
• Secondary Key
• Concatenated Primary Key
• Foreign Key
• Normalisation

“The process of creating a database index, which is a data structure that improves the speed of data retrieval operations on a dataset table at the cost of additional writes and storage space to maintain the index data structure.”

• Normalisation
• ERM
• Secondary Key
• Concatenated Primary Key
• Indexing

“A table with no normalisation. All data and all fields in one table”

• Indexing
• Normalisation
• ERM
• Secondary Key
• 0NF