Database - Relationships

Which of the following is not a type of a database?

• Flat-file database

• Relational Database

• Dynamic database

Choose all the disadvantages of the flat-file database

• ease of updating

• Data duplication

• Likelihood of errors

• difficulty in updating

Choose all the advantages of the relational database

• no duplication of data

• data duplication

• ease of updating

• reduced likelihood of errors

What is a foreign key?

• A key from another country

• A key that refers to a primary key in another table

• A new key in a table

• all of the above

What is a primary key?

• A key that is primary school

• A new key in a table

• A field that uniquely identifies records in a field

• None of the above

Which two keys are used to create a relationship between two tables?

• Two foreign keys

• Two primary keys

• Primary key and candidate key

• Foreign key and Primary key

Select the options that represent the types of relationships present in relational databases

• one-to-many

• many-to-none

• many-to-many

• one-to-one

What is a flat-file database?

• A database that is made up of just one table

• A database that has many tables that are random

• A database that has many related tables

• None of the above

What is a relational database?

• A database that has many tables that are random

• A database that has many related tables

• A database that is made up of just one table

• None of the above

what type of database that this belong?

• flat-file

• relational

• dynamic

• None of the above