Suppose there is a relational schema R in a commercial group database as follows: R(store id, item id, storage num, department id, department manager) Given the following information: Each item in each store is sold in only one department of the store 2 Each department in each store has only one manager There is only one number of storage per item per store Answer the following questions:[3 marks each]

1. According to the above rules, write the basic function dependency of relational schema R.

2. Find all candidate keys of relation R

3. What is the highest level normal form that relation R can satisfy.

4. If the R doesnt satisfy 3NF, decompose this to 3NF.

Question 4 (12 marks) al group database as follows: Suppose there is a relational schema R in a c R(store.id, item.id, storage num, department.id, department manager) Given the following information: . Each item in each store is sold in only one department of the store . Each department in each store has only one manager There is only one number of storage per item per store Answer the following questions:[3 marks each] 1. According to the above rules, write the basic function dependency of relational schema R. 2. Find all candidate keys of relation R 3. What is the highest level normal form that relation R can satisfy. 4. If the R doesnt satisfy 3NF, decompose this to 3NF