Databases and database systems university exams questions - acaproso
A relation that has no partial functional dependencies is in 2NF.
A relation in 1NF suffers from insertion, deletion and update anomalies.
A table with insertion, deletion and update anomalies has to be broken down into two to remove the anomalies.
A relationship is an association between two or more tables in an E-R model.
We use a surrogate key when no field can be unique for each entity instance.