Question
[8:47 PM, 1/21/2022] BIG GOD: Established in 1914, ABC-books is well-known in Accra, Kumasi and Tamale. The shop has operated manually since its inception; however,
[8:47 PM, 1/21/2022] BIG GOD: 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 each customers 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started