Database Management Systems Quiz 2: 16 March 2025 (January 2025 term)

Consider the relation players(Name, Team, Coach, Runs) with the data:

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 __________