1. Convert the following the design to the third normal form. Using the steps of normalization, create a logical data model that represent this file in third normal form.

(Order #) > (Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Customer book preference 1, Customer book preference 2, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)