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?
Consider the following tables, Loan and Borrower, of a bank.
| Loan | ||
| loan_num | branch_name | amount |
| L11 | Banjara Hills | 90000 |
| L14 | Kondapur | 50000 |
| L15 | SR Nagar | 40000 |
| L22 | SR Nagar | 25000 |
| L23 | Balanagar | 80000 |
| L25 | Kondapur | 70000 |
| L19 | SR Nagar | 65000 |
| Borrower | |
| customer_name | loan_num |
| Anand | L11 |
| Karteek | L11 |
| Karteek | L14 |
| Ankita | L15 |
| Gopal | L19 |
| Karteek | L22 |
| Karteek | L23 |
| Sunil | L23 |
| Sunil | L25 |
Query: $\quad \pi_{\text {branch_name, customer_name }}$ (Loan $\triangleright \triangleleft$
Borrower) $\div \pi_{\text {branch_name }}$ (Loan)
where $\triangleright \triangleleft$ denotes natural join.
The number of tuples returned by the above relational algebra query is
__________
Suppose $X$ and $Y$ are random variables. The conditional expectation of $X$ given $Y$ is denoted by $E[X \mid Y]$. Then $E[E[X \mid Y]]$ equals
GATE Data Science and Artificial Intelligence Papers
All year-wise previous year question papers