Question $4$

Looking at the relation R$($Album$,$ Artist, Track$)$ again, what is a potential consequence $($could be multiple$)$ of allowing multiple artists to be associated with a single album? Recall that the relational data model disallows non$-$atomic data values in each attribute, i$.$e$.,$ no list$/$array of values.

A$.$ Increased query speed due to data simplification.

B$.$ Reduced data redundancy and more efficient storage.

C$.$ Increased data redundancy and potential update anomalies.

D$.$ Simpler insertion and deletion operations.

E$.$ Increased occurrence of NULL values.