decomposition using functional dependencies

mcqspedia.com has 5 Question/Answers about Topic decomposition using functional dependencies

An instance of a relation that satisfies all real-world constraints is called a

An instance of a relation that satisfies all real-world constraints is called a
  • A. Associated instance
  • B. Legal instance
  • C. Participant instance
  • D. Domain instance
  • Correct Answer: Option B

For relations, best practice is to use a

For relations, best practice is to use a
  • A. Sentencecase name
  • B. Uppercase name
  • C. Lowercase name
  • D. First-letter capital case
  • Correct Answer: Option C

Definition of 3NF permits certain functional dependencies that are not allowed in

Definition of 3NF permits certain functional dependencies that are not allowed in
  • A. BCNF
  • B. 1NF
  • C. 2NF
  • D. 3NF
  • Correct Answer: Option A

Schema for relation r, with ‘R’ denoting set of attributes, can be expressed by notation

Schema for relation r, with ‘R’ denoting set of attributes, can be expressed by notation
  • A. r
  • B. R
  • C. r( R)
  • D. R ( r)
  • Correct Answer: Option C

Functional dependencies are used for

Functional dependencies are used for
  • A. Testing instances of relations
  • B. Specify constraints on legal relations
  • C. Both A and B
  • D. Specifying Domain
  • Correct Answer: Option C