Question

1. If two tables have a many-to-many relationship, you need to define a/an _____________ table that relates their records.

10 points

Question 2

1. The most common type of relationship between two tables is called a/an _______________ relationship.

10 points

Question 3

1. The rows in a table are kept in the sequence that’s based on its __________________________ index.

10 points

Question 4

1. To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

10 points

Question 5

1. To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 1:

Answer :linking

Explanation :If two tables have a many-to-many relationship, you need to define a/an linking table that relates their records.

**************************

Question 2:

Answer :one-to-many relationship

Explanation :one-to-many relationship is most common type of relationship between two tables.

**************************

Question 3:

Answer :clustered

Explanation :By using clustered index the rows in the table are kept in sequence.

**************************

Question 4:

Answer :referential integrity

Explanation :To maintain referential integrity,  if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

**************************

Question 5:

Answer :Table

Explanation :To model a database on a real-world system, you typically represent each real-world entity as a/an table.

**************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.