โมเดลฐานข้อมูล ER

We have supermarkets in which many employees work and each employee only works in one supermarket, what would be the cardinality of the question?

• (1,n)

• (1,1)

• N:N

• (0,n)

We have supermarkets where customers buy, what is the cardinality with question marks?

• N:M

• N:N

• Both answers are correct

• None of the above

In the following table, what is the Foreign Key FK?

• Nombre

• Id_País

• Id_Provincias

• There is no foreign key.

In the following table, what is the Primary Key PK?

• Id_coche

• Nombre

• There can be 2 PK that would be DNI and Id_Client

• Id_Cliente

A PK (Primary Key)...

• 1 .- ...cannot contain null values.

  2.- ...can be repeated in some rows.

  3.- There can only be one PK per table.

• 1 .- ...can contain null values.

  2.- ...cannot be repeated in any row.

  3.- There can only be one PK per table.

• 1 .- ...cannot contain null values.

  2.- ...cannot be repeated in any row.

  3.- There can only be one PK per table.

• 1 .- ...cannot contain null values.

  2.- ...cannot be repeated in any row.

  3.- There can only be two PK per table.

We have a database in which we are going to create Activities, there are outdoor activities with the attributes of place and number of people and there are classroom activities with the attributes of materials and place. What is this relationship called and how is it represented?

• 
• 
• 
• None of the previous answers

We have Sporting Events taking place in Cities, what is the cardinality requested?

• (1,n)

• (1,1)

• (n,n)

• N:N

what is the cardinality requested?

• 1:1

• 1:0

• N:0

• N:1

An Employee may manage many Employees, but an Employee is managed by only one Employee, what are the cardinalities?

• (0,n)

  (1,1)

• (1,n)

  (1,1)

• (0,n)

  (0,1)

• (1,n)

  (0,1)

A diet may be followed by several animals and an animal follows only one diet, What is the cardinality?

• (0,1)

• (1,n)

• (1,1)

• 1:1