Spot the false statement

Exercise and reference answers

Questions

1. False statement

   Degree is the number of tuples

   Statements

   1. Degree is the number of attributes
   2. Cardinality is the number of tuples
   3. Degree is the number of tuples

2. False statement

   A DBMS removes all complexity

   Statements

   1. Redundancy can cause inconsistency
   2. A DBMS removes all complexity
   3. A foreign key links two relations

3. False statement

   One attribute may hold many values per tuple

   Statements

   1. Attribute values must be atomic
   2. One attribute may hold many values per tuple
   3. A column draws from a single domain

4. False statement

   Every relation has exactly one candidate key

   Statements

   1. A candidate key could serve as primary
   2. A foreign key comes from another primary key
   3. Every relation has exactly one candidate key

Instructions

Two statements are true and one is false. Tap the false one.

Explanation