An online bookst track their orders, but, as their business grows, it the current schema and facts about the domain that you may need to know ore has asked for your help. Currently, they are using an Excel spreadsheet to is becoming unwieldy. The following describes BookOrder(isbn, tile, author, gy in stock, price, year, published, cid, cname, c adress, order_num, card_num, order_gty, orde isbn-The ISBN number that identifies a unique book. title-The book title r_date, ship_ date) author -The author of the book. You may assume that multiple book authors will be stored inside the same author string for this schema. For example, if the book was written by John Smith and James Miller, the author value with be "John Smith& James Miller" gty-in stock-How many of a book is in stock price - The price of the book year-published - The year the book was published cid - The unique identifier for a customer cname- The name of the customer c address-The address of the customer and where to ship the book to. order_num -The unique identifier for an order instance card num -The credit card number used for the order order_gty - How many of a specific book were ordered order_date- When the order was placed ship_date -When the order was shipped (if it has not been shipped yet, this is null) Additional Information i. A customer may order multiple books under a single order number (order_num). i. For each order, only one credit card can be used to complete the purchase i Currently, to know how many items are in stock, the company looks for the last sale of a book (or the last entry of a book with no sale). The company would like to change this and instead store the number of items in stock by the ISBN number. Identify the functional dependencies in the problem domain above. Note these in the table Identify the functional depen a) elow. Then, for each functional dependency, indicate if it is in 3NF and/or BCNF. Use the table below to format your answers. In the table, Y-Yes True and indicates that a dependency is in the specified form. N = No/False, indicating that a dependency does not fit the specified form. An online bookst track their orders, but, as their business grows, it the current schema and facts about the domain that you may need to know ore has asked for your help. Currently, they are using an Excel spreadsheet to is becoming unwieldy. The following describes BookOrder(isbn, tile, author, gy in stock, price, year, published, cid, cname, c adress, order_num, card_num, order_gty, orde isbn-The ISBN number that identifies a unique book. title-The book title r_date, ship_ date) author -The author of the book. You may assume that multiple book authors will be stored inside the same author string for this schema. For example, if the book was written by John Smith and James Miller, the author value with be "John Smith& James Miller" gty-in stock-How many of a book is in stock price - The price of the book year-published - The year the book was published cid - The unique identifier for a customer cname- The name of the customer c address-The address of the customer and where to ship the book to. order_num -The unique identifier for an order instance card num -The credit card number used for the order order_gty - How many of a specific book were ordered order_date- When the order was placed ship_date -When the order was shipped (if it has not been shipped yet, this is null) Additional Information i. A customer may order multiple books under a single order number (order_num). i. For each order, only one credit card can be used to complete the purchase i Currently, to know how many items are in stock, the company looks for the last sale of a book (or the last entry of a book with no sale). The company would like to change this and instead store the number of items in stock by the ISBN number. Identify the functional dependencies in the problem domain above. Note these in the table Identify the functional depen a) elow. Then, for each functional dependency, indicate if it is in 3NF and/or BCNF. Use the table below to format your answers. In the table, Y-Yes True and indicates that a dependency is in the specified form. N = No/False, indicating that a dependency does not fit the specified form