Advanced Higher Databases: Relational Databases

What is a relational database?

• A type of database that only stores unconnected data points

• A type of database that does not allow access to the stored data

• A type of database that stores and provides access to data points that are related to one another.

• A type of database that is only used for storing images and videos

What are the key features of a relational database?

• Files, folders, paths, and directories

• Arrays, objects, functions, and loops

• Tables, relationships and SQL

• Graphs, nodes, edges, and traversal

What is a primary key in a relational database?

• The last record added to the table

• A random number assigned to each record

• A unique identifier for each record in a table

• A value that can be duplicated in the table

What is a foreign key in a relational database?

• A type of key used to unlock foreign data

• A key that is only used for data encryption

• A key that is used to access a foreign language database

• A field in a table that establishes a link between two tables

Discuss the concept of relationships in a relational database.

• Relationships in a relational database are established between columns using keys.

• Relationships in a relational database are established between records using keys.

• Relationships in a relational database are established between files using keys.

• Relationships in a relational database are established between tables using keys.

Discuss the role of SQL in relational databases.

• SQL is used to access and manipulate data in relational databases.

• SQL is primarily used for graphic design in relational databases

• SQL is not compatible with relational databases

• SQL is only used for creating tables in relational databases

What does the term 'mandatory relationship' mean in the context of databases?

• A relationship that must exist between two tables

• A relationship that is optional between two tables

• A relationship that is forbidden between two tables

• A relationship that is temporary between two tables

What is a 'weak entity' in a database?

• An entity that does not have a primary key

• An entity that depends on another entity for its existence

• An entity that has multiple primary keys

• An entity that cannot be linked to another entity

What does 'optional relationship' mean in the context of databases?

• A relationship that must exist between two tables

• A relationship that is optional between two tables

• A relationship that is forbidden between two tables

• A relationship that is temporary between two tables

What is a surrogate key in a database?

• A key that is used to access a foreign language database

• A unique identifier for each record in a table, which is not derived from the application data

• A key that is only used for data encryption

• The last record added to the table