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 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 a) Identify all entities. b) Identify attributes of entities. c) Identify Relationships.
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 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 a) Identify all entities. b) Identify attributes of entities. c) Identify Relationships.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
don't copy
Transcribed Image Text: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 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
a) Identify all entities.
b) Identify attributes of entities.
c) Identify Relationships.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY