Assignment 2: Data Model (ER Modeling) Little Rock Book Publishing (LRBP) database needs to maintain information on the books they publish, authors and customers (individuals or book stores). The followings are the data requirements for the database. uirements LRBP wants to maintain data on Book Title. Its attributes include ISBN, Title, Edition, and PublishDate. BookCopy. Attributes are CopyID, Price, and PrintDate. Author. Attributes are AuthorID, LastName, FirstName, Phone, StreetNo, City, State, and Zip. In addition, the database needs to maintain information on AuthorOrd, which represents the authorship orders (e.g., first author, second author etc.) for each book and RoyaltyShare (e.g., 50% for the first author, 30% for the second author, and 20% for the third author etc.) for each book they write. - - Customer. Attributes are CustID, Name, Address, and Contact - BookOrder. Attributes are OrdNum, OrdDate and ShipDate. In addition, the information on the quantity ordered (QtyOrdered) also needs to be maintained. You'll want to know how many books are ordered for each book in each order. Business Rules The followings describe the business rules for the database. There are many copies for each title. Each copy is associated with one book title. An author writes many books for LRBP. A book is written by one or more authors. A book order includes one or more book copies. A book copy appears on one or more book orders. - - - A customer places many book orders. Each book order is associated with a customer A customer may make a referral to one or more other customers. - - Based on the above mentioned business requirements and business rules, develop an ER model for the LRBP Due date: 3/13 (Tuesday, at the beginning of the class)