Question$-1[10$ marks$]$

Consider the following relational database schema:

Customers $($SSN$,$ name, address, city$)$ where SSN $($Social Security Number$)$ is unique for

each customer.

Accounts $($SSN$,$ AccntNo$)$

Transactions $($AccntNo$,$ ProductId, date, quantity$)$ where quantity is the number of

ProductId purchased on given transaction with a restriction that same product cannot be

bought using the same account number. An account number cannot be used to buy the

same product m ore than once.

Products $($ProductId$,$ ProductName, cost$)$

Identify the super key, candidate key, primary key, composite primary key $($if any$),$

alternate key $($if any$)$ foreign key $($if any$)$ and composite foreign key $($if any$)$ for the

'Transactions' relation. Also mention why AccntNo and ProductId can be used as foreign

keys but can't function completely as fo reign keys in $\text{'}$T ransactions' relation?

Question$-2[10$marks$]$

Given the following table and based purely on the data it holds:

Select all the functional dependencies below that are consistent w ith the table above:

$AB,BA,AC,CA,CD,DC$