Functional Dependencies and Normalization · Database Management System and Warehousing · GATE Data Science and Artificial Intelligence

If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order to maintain the dependencies?

Consider the following two relations, named Customer and Person, in a

database:

Person (

aadhaar CHAR(12) PRIMARY KEY, name VARCHAR(32));

Customer (

name VARCHAR(32), email VARCHAR(32) PRIMARY KEY, phone CHAR(10), aadhaar CHAR(12), FOREIGN KEY (aadhaar) REFERENCES Person(aadhaar)); Which of the following statements is/are correct?

Consider a database relation $R$ with attributes ABCDEFG , and having the following functional dependencies:

$$ \mathrm{A} \rightarrow \mathrm{BCEF} \quad \mathrm{E} \rightarrow \mathrm{DG} \quad \mathrm{BC} \rightarrow \mathrm{~A} $$

Which of the following statements is/are correct?