Relasi Database

Multiple Choice

Which of the following best describes a one-to-one (1-1) relationship in a database?

• Each row in the first table can be linked to multiple rows in the second table.

• Each row in the first table can only be linked to one row in the second table, and vice versa.

• Each row in the first table can be linked to no rows in the second table.

• Each row in the first table must be linked to every row in the second table.

Fill in the Blanks

Fill in the blank: In a library database, the relationship between 'Books' and 'Authors' is typically ___-to-___.

Multiple Choice

Compare the one-to-many (1-M) and many-to-many (M-M) relationships in databases. What is a key difference between them?

• In one-to-many, both tables can have multiple links to each other.

• In many-to-many, each row in the first table can only be linked to one row in the second table.

• In one-to-many, a row in the first table can be linked to multiple rows in the second table, but not vice versa. In many-to-many, both tables can have multiple links to each other.

• There is no difference between one-to-many and many-to-many relationships.

Multiple Select

Which of the following are advantages of using relationships in a database?

• Data is more structured and organized.

• It is harder to update data.

• Data storage is more efficient by avoiding duplication.

• It is easier to perform data analysis.

Multiple Choice

Which of the following is a challenge in managing relationships in a database?

• Complexity of database design

• Ease of data retrieval

• Unlimited storage capacity

• Automatic data backup

Multiple Choice

Which of the following is NOT a main type of relationship commonly used in database systems?

• One-to-One (1-1)

• One-to-Many (1-M)

• Many-to-Many (M-M)

• One-to-Two (1-2)