Data Science: DBMS

What is a field in a database?

• A field is a row in a database table that contains multiple records.
• A field is a column in a database table that stores a specific attribute of a record.
• A field is a type of database that stores entire tables.
• A field is a command used to query a database for information.

What is a record in a database?

• A record is a type of database software.
• A record is a single data type in a database.
• A record is a collection of related data items stored together in a database.
• A record is a command used to query a database.

A row is ​ (a)   in a table that ​ (b)   all the​ (c)   about one item or ​ (d)  

• a record
• contains
• information
• person.

What is a primary key?

• A primary key is a type of foreign key.
• A primary key can be duplicated in a table.
• A primary key is used to store images in a database.
• A primary key is a unique identifier for a record in a database table.

• A field that uniquely identifies each record in a table is a _____ _____ (P... K...)

(a)  

What is a foreign key in a database?

• A foreign key is a unique identifier for a single table.
• A foreign key is a type of index that speeds up queries.
• A foreign key is a field that stores data from the same table.
• A foreign key is a field that links two tables by referencing the primary key of another table.

• A field in one table that links to the primary key in another table is called a _____ _____(F... K...)

(a)  

Which of these is an example of a primary key?

• PhoneNumber
• Username
• UserID
• Email

Why do we use foreign keys in a database?

• To store duplicate data in multiple tables.
• To connect related data in different tables

• To improve the speed of data retrieval.
• To increase the size of the database.

What is normalisation in a database?

• Dividing data into smaller, related tables to reduce redundancy

• Normalisation is a method to encrypt data in a database.

• Normalisation refers to the physical storage of data on disk drives.

• Normalisation is the process of increasing redundancy in a database.