Question 1

Consider the relation **players**(Name, Team, Coach, Runs) with the data: | Name | Team | Coach | Runs | |---|---|---|---| | Sharma | CSK | Steven | 99 | | Sharma | MI | Mahela | 50 | | Sharma | MI | Mahela | 99 | | Sharma | CSK | Steven | 50 | Table 1: **players** Check whether the relation **players** is in 4NF or not. If not, then decomposed it into 4NF. Choose the correct option. Consider the relational schema **car**(*carEngineNo, model, fuelType, company, headQuarters, aadhaar, customer, state, mobile, purchaseDate*) with the following set of functional dependencies (assume that all the attributes have atomic values). $$\begin{aligned} &\mathcal{F} = \{ \\ &carEngineNo \rightarrow (model, fuelType, company), \\ &(carEngineNo, aadhaar) \rightarrow purchaseDate, \\ &company \rightarrow headQuarters, \\ &aadhaar \rightarrow (customer, state), \\ &customer \rightarrow mobile, \\ &mobile \rightarrow aadhaar \\ &\} \end{aligned}$$ Check if the relational schema **car** is in BCNF or not. If **car** is not in BCNF, decompose into minimum **X** number of relations, so that all the relations are in BCNF as well as dependency preserving. The value of **X** is \_\_\_\_\_\_\_\_\_\_ Figure from the original question paper