Table Old has:

columns A$,$ B$,$ C$,$ D

candidate keys A and C

dependencies on A and C only

Revise table Old and create table New to achieve Boyce$-$Codd normal form.

What columns are in the revised table Old, table New, and the table New primary key?

A $BD$

$,$ table Old

$$ table New

table New primary key