NEW
Font size
Worksheetsโมเดลฐานข้อมูล ER
Total questions: 10
Worksheet time: 6mins
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
