Consider the following relation R(A, B, C, D, E) and functional dependencies F that hold over this relation. Consider the following relation R (ApplicationID, BankID, SSN, type, income, name) for loan bank systems. Using the following assumptions Each customer can have one SSN and only one name associated with the SSN and have one income A customer can apply for multiple loans. However, applicationID at a given bankID, is for one customer and one given type. One application ID is associated with one customer at a given bankID applying for a given types loan The functional dependencies deduced for these assumptions are as follow: SSN income, name ApplicationID, BankID SSN, type, name SSN , BankID, type ApplicationID, income 1- Find the candidate key (s) 2- Find the canonical cover 3- What normal is R 4- Decompose R into 3NF schema 5- Decompose R into BCNF schema Consider the following relation R(A, B, C, D, E) and functional dependencies F that hold over this relation. Consider the following relation R (ApplicationID, BankID, SSN, type, income, name) for loan bank systems. Using the following assumptions Each customer can have one SSN and only one name associated with the SSN and have one income A customer can apply for multiple loans. However, applicationID at a given bankID, is for one customer and one given type. One application ID is associated with one customer at a given bankID applying for a given types loan The functional dependencies deduced for these assumptions are as follow: SSN income, name ApplicationID, BankID SSN, type, name SSN , BankID, type ApplicationID, income 1- Find the candidate key (s) 2- Find the canonical cover 3- What normal is R 4- Decompose R into 3NF schema 5- Decompose R into BCNF schema