Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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;

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions