Able to explain how models are related in a database

Question 1

Able to explain how models are related in a database

Answer 1

In a database, models represent entities,

• such as people,
• products,
• or orders,
  and their relationships to one another. Models are related to one another through the use of foreign keys.

There are three main types of relationships between tables in a database:
One-to-One (1:1)
One-to-Many (1:N)
Many-to-Many (N:M)

Question 2

One-to-One (1:1)

Answer 2

when each record in one table is associated

• with one and only one record in another table.

Question 3

One-to-Many (1:N)

Answer 3

• when each record in one table can be associated with one or more records in another table,
• but each record in the second table is associated with only one record in the first table.

Question 4

Many-to-Many (N:M)

Answer 4

• when each record in one table can be associated with one or more records in another table,
• and each record in the second table can be associated with one or more records in the first table.

Question 5

One-to-Many Relationship in foxshop

Answer 5

Question 6

Many-to-Many Relationship in foxshop

Answer 6