Informatica
Which of the following statements related to normalization are true and which are false?
The single attribute K is the primary key.
In 1NF, each attribute can have multiple values.
In 2NF, the relation must already be in 1NF.
In 3NF, every non-key attribute depends only on the key and not on other non-key attributes.
A table in 2NF is also a 3NF table.
The table T (K, A1, A2, A3) is definitely a 2NF table.
The table T (K, A1, A2, A3) is definitely a 3NF table.
The table T (K, A1) is definitely a 2NF table.
The table T (K, A1) is definitely a 3NF table.
A table is in 2NF if the table is in 1NF and there are no null values in primary key fields.
Il punteggio di un esercizio è determinato
dalla difficoltà: da 1 (più facile) a 5 (più
difficile). Vuoi saperne di più? Consulta il
Centro assistenza
Informatica
Which of the following statements is the definition of degree of a relation?
The degree of a relation is the number of attributes it contains.
The degree of a relation is the number of different values in a candidate key.
The degree of a relation is the number of alternate keys in the relation.
The degree of a relation is the number of candidate keys of the relation.
Il punteggio di un esercizio è determinato
dalla difficoltà: da 1 (più facile) a 5 (più
difficile). Vuoi saperne di più? Consulta il
Centro assistenza