A university bookstore currently maintains the following relational tables:

The fields in each table are shown in parentheses. The primary field is underlined. Convert the ratio to the equivalent of 3NF.

ORDER

(ORDER-NO, O-DATE, INSTRUCTOR-NO, INSTRUCTOR-NAME, INSTRUCTOR-DEPT)

ORDER-BOOK

(ORDER-NO, ISBN-NO, BOOK-TITLE, BOOK-AUTHOR, COURSE-NO, COURSE-NAME)

Aparte de las dependencias sugeridas por las llaves primarias, asuma solamente las siguientes dependencias funcionales.

[INSTRUCTOR-NO] [INSTRUCTOR-NAME, INSTRUCTOR-DEPT]

[ISBN-NO] [BOOK-TITLE, BOOK-AUTHORS]

[COURSE-NO] [COURSE-NAME]