AMOUNT The two keys are NAME,DATE and ID,DATE. Note that NAME is dependent on ID, which is a proper subset of a key. However, NAME is a prime attribute since it is part of a key. Thus this is in third normal form, but not in Boyce Codd normal form.
Rated 5 – based on votes of