Q23

A database of research articles in a journal uses the following schema. $\text{(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE)}$ The primary key is '$\text{(VOLUME, NUMBER, STARTPAGE, ENDPAGE)}$ and the following functional dependencies exist in the schema. \begin{align*}&(\text{VOLUME , NUMBER, STARTPAGE, ENDPAGE}) & \rightarrow \text{TITLE} \\ &(\text{VOLUME, NUMBER}) & \rightarrow \text{ YEAR} \\ &(\text{VOLUME, NUMBER, STARTPAGE, ENDPAGE}) &\rightarrow \text{PRICE} \end{align*} The database is redesigned to use the following schemas $(\text{VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE}) \\ \text{(VOLUME, NUMBER, YEAR})$ Which is the weakest normal form that the new database satisfies, but the old one does not?