Consider following two statements:

Statement I: Relational database schema represents the logical design of the database.

Statement II: Current snapshot of a relation only provides the degree of the relation. In the context to the above statements, choose the correct option from the options given below:

1. AStatement I is TRUE but Statement II is FALSE
2. BStatement I is FALSE but Statement II is TRUE
3. CBoth Statement I and Statement II are FALSE
4. DBoth Statement I and Statement II are TRUE

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: A. Statement I is TRUE but Statement II is FALSE

Explanation

The schema is the logical design (I true). A snapshot (instance) gives the current tuples, i.e. its cardinality and contents, not just the degree (II false).