You are required to develop an information management system that supportssome of the services involved in an Online Bookstore $($e$.$g$.,$ Amazon.com$).$ Therequirements of the Online Bookstore are as follows:The Book store has registered customers in order to sell books.It also contains the publishers information and a customer can place the bookhe desires to buy on a shopping basket.A customer has an email, name, phone and address.A book has and ISBN, year, title and price. Publisher has a name, address, phoneand URL and publishes several books, but one book can be published by onepublisher.An author has a name and address and can write several books.Books can be written by only one author and they are stored on manywarehouses and one warehouse has many books.A customer can have several shopping baskets. Each shopping basket belongsto one customer, where each shopping basket can contain several books.Develop and draw the Diagram for the Entity$-$Relationship Model of theBookshop.Reduce the E$-$R model into a relational model.