Need task 2 done

Task 1 Define relations with associated attributes, primary keys, alternate keys and foreign keys for the complete conceptual model described later in the assignment. You should then explain how you have checked that the re database is normalized that is, to describe specifically what you have checked to verify that the model is in the first, second and third normal form respectively Task 2 Consider the following table of an online bookstore and answer the following questions book_order (orderno, isbn, shipdate, title, cid, orderdate, email) where orderno is a unique number with each order isbn is a unique 13 digits number of a book. An order may contain many books. shipdate is the date when an order is shipped to a customer. Books belonging to a particular order may not be shipped together title is the title of a book. Many books may have same title cid is a unique number associated with each customer of this bookstore orderdate is the date when the customer placed an order. email is the customer's up to date email address. The email address may change between the time of ordering and the time when the books are shipped a) Find the functional dependencies and candidate keys. Choose a primary key b) Discuss the anomalies present, if any, in this relation. Give examples from the relation to explain each of the anomaly present in this relation c) In which normal form, this relation is? Explain your answer d) Normalize the relation to BCNF. Specify primary and foreign keys in the resulting relations