(Database Design Normalization: functional dependency: 3NF vs. BCNF)

Normalize the relation DISK_DRIVE (see below) into 3NF and BCNF, respectively, given the set of functional dependencies listed below. In your answer, draw the resulting relational schema and show the functional dependencies. Consider only lossless decomposition in the normalization. (Note lossy decomposition is not acceptable as it causes the query result to be incorrect). Discuss the resulting schema in terms of whether it preserves all functional dependencies and whether it eliminates the risk of update anomalies.

DISK DRIVE(serial number, manufacturer, model, batch, capacity, retailer) FDI : {serial-number, manufacturer) {model, batch, capacity, retailer) FD2: {model} {manufacturer) FD3: manufacturer, batch} -> fmodel) (Assume different manufacturers may happen to use the same batch number.) FD4: {modelj -> {capacity; (Note: we do not need 'manufacturer' as part of the determinant, because it is functionally dependent on model')