a Part I: Database Design Established in 1914, ABC books is well-known in Accra, Kumasi and Tamale. The shop has operated manually since its inception; however, since 2000 ABC -books has witnessed a consistent decline in sales across all its branches This has compelled management of ABC-book shop to go online with their activities. The following requirements were gathered after interacting with management, employees and customers of ABC -books: 1. ABC-book has 3 branches 2. Each branch of ABC has a unique branch number, branch name, address and phone number 3. Each branch stocks a quantity of books from publishers. 4. Each publisher has a name, address, phone number and web address. 5. Each publisher publishes books from authors. 6. Each book has year, edition, price, title, ISBN and DIO. 7. Each book is written by an author. 8. Each author has a name, address, title, specialty, date of birth and nationality. 9. The online bookshop should have a distinct customer accounts. 10. Each customer account should have a distinct user identity which should be linked to individual customers in the system 11. The system should capture cach customer's name, national identity, gender, date of birth, email, address and phone number 12. Each customer account should be linked to a unique cart with a cart number. 13. A cart takes a number of books and a cart can have a number of selected items. 14. Selected items should have unique a quotation number, number of selected items, payment status. 15. Selected items is linked to payment. 16. Payment should have unique receipt number, amount paid, outstanding balance. 17. Payment is linked to customer accounts. 18. Selected items should be moved to Transit items after payment. 19. Transit items should have unique tracking code, current location, date, time, destination delivery confirmation 20. Transit items should be moved to delivered items after delivery is confirmed. 21. Delivered items should linked to a particular customer 22. Delivered items have delivery date, time, signature, location, status, remarks. Question 1: Using entity relationship diagrams, construct a conceptual model for the proposed ABC online bookshop. Use assumptions where necessary. (20 Marks) a) Identify all entities. (4 Marks) b) Identify attributes of entities. (4 Marks) c) Identify Relationships. (4 Marks) d) Indicate cardinality. (4 Marks) e) Indicatication entity participation. (4 Marks) 2