Q4. Draw a logical relational data model for the proposed system. Be sure to include primary and foreign keys in your model as well as all non-key attributes and relationships. (15 marks) In addition to the information provided in the previous questions, while some stock is kept at each store, RB has a number of suppliers who provide books to the RB stores. RB keeps information on each supplier, specifically, their business name and address as well as the name, phone and email address of the contact person. Further, each book has an associated unique ISBN or International Standard Book Number. Also, each order has an additional delivery charge, based on the distance between the customer address and the nearest store. To simplify the calculation of the delivery charge, the charge is made based on one of three distance segments, Local, Metropolitan and Country, with each segment having a delivery charge of $2, $5 or $7, respectively. Platinum customers receive free delivery. Q4. Draw a logical relational data model for the proposed system. Be sure to include primary and foreign keys in your model as well as all non-key attributes and relationships. (15 marks) In addition to the information provided in the previous questions, while some stock is kept at each store, RB has a number of suppliers who provide books to the RB stores. RB keeps information on each supplier, specifically, their business name and address as well as the name, phone and email address of the contact person. Further, each book has an associated unique ISBN or International Standard Book Number. Also, each order has an additional delivery charge, based on the distance between the customer address and the nearest store. To simplify the calculation of the delivery charge, the charge is made based on one of three distance segments, Local, Metropolitan and Country, with each segment having a delivery charge of $2, $5 or $7, respectively. Platinum customers receive free delivery