a. Consider the following set of data requirements for Bookstore database which contains data about books and selling transactions. The Bookstore consists of several branches. Each branch is identified by uniquely assigned ID, Name, and location. b. A book is identified by an ISBN (unique), title, publisher, and one or more authors. There may be one or more copies of the same book, distributed over the Bookstore branches. Each book copy is identified by a Copy Number which is unique for all copies of the same book. It is required to keep track of the number of book copies in each Bookstore branch. Each book belongs to one category (Art, Literature, Science, Engineering ... etc). Each category has a recruitment budget. A publisher is identified by Name (unique), Address, Email Address, and Phone numbers. d. Each buyer is registered in the system through his/her email address and Name. No two users are allowed to have the same email address. It is required to keep track of the selling transactions of each Bookstore branch. Each selling transaction is identified by a unique reference number and having information about the buyer, the book, the bookstore branch and selling date. C. Design a database for the bookstore described above, illustrating your design through an ERD. After designing your ERD, construct the relational model for your database, illustrating the constraints on each relation