Biblion-line is a small bookshop located at Dawn, in Dawnshire, in an isolated place nearby called End earth. The bookshop keeps stock of a variety of special and rare book titles including adventure, novels, kid-stories, science fiction and history. There are currently 3 people working for the company. Pluto, who is the owner of the bookshop, is responsible for keeping stock live and up-to-date. Venus and Maya are the two clerks dealing with customers. In particular, they keep the bookshop’s call centre, where customers make their enquiries about stock availability, ordering, delivery and payment options. At the moment, when a customer makes enquiry about a book, either Venus or Maya fill in a paper based pre-order slip and pass it to Pluto. He then looks at his stock and checks the availability of the item asked for. If the item is available Venus (or Maya) calls the customer back and if he still wants the item ordered, payment and delivery arrangements take place. One of the many problems that Biblion-line has at this particular stage is what is going to happen if there is a single copy of an item when two or more customers want to order it. If the item is unavailable then Pluto, Venus or Maya suggest another place, nearby Middle Earth (hundreds of miles away), where the customer may have better luck. Finally, if the order take place, Hermes (a small local parcel company) collects the item(s) and undertakes the responsibility to deliver the item(s) to the customer as appropriate.
Mr. Pluto would like to take advantage of Internet technology by overseeing the implementation of online bookshop, to serve the customers around the world. He believes that this system will simplify the ordering system and increase sales for the company. The system will also simplify payment for the books and make it easier for customers and members of public to search for books of their choice.
1. Construct an entity relationship diagram from the BIBLION-LINE Bookshop case study.
This means that you need to identify the entities, give them an appropriate name, include all possible attributes and their data type, name all bi-directional relationships , indicate cardinalities as necessary and final indicate the Primary keys (PKs) and Foreign keys.
Attachments:
PRACTICAL-ONE….docx
