Q46.Marks: +2.0UGC NET Paper 2: Computer Science 26th Nov 2021
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.Statement I is TRUE but Statement II is FALSE✓ Correct
2.Statement I is FALSE but Statement II is TRUE
3.Both Statement I and Statement II are FALSE
4.Both Statement I and Statement II are TRUE
Solution
Relational database schema represents the logical design of the database: TRUE
A relational database schema is a set of table definitions, constraints, and derivation rules. A table scheme is a named set of attributes that draw their values from domains. Each column, or column set, spanned by a minimal uniqueness constraint is a candidate key.
Current snapshot of a relation only provides the degree of the relation: FALSE
Current snapshot of a relation provides the degree of the relation as well as the source of the database because of which, the size of the database increases as the changes are made to the source database.