Orinoco is a company providing specialist multi-media items e.g. DVDs, CDs, vinyl records, cassette tapes, books. The company does not keep items in stock, but acts as a broker between buyers and sellers. They require a system Orinoco Order Processing System – OOPS) that provides a website for sellers to post items and buyers to buy items or post requests. Sales managers will need to monitor trading activity and produce monthly reports.
To add items to the Sales List, sellers must be registered with Orinoco and be added to the Sellers List. They should be able to remove, or update their own information. Once registered, sellers should be able to post items for sale or withdraw items at any time. The system should maintain Seller Accounts and provide the Sales Manager with lists of payments to be passed by Orinoco on to sellers (after deducting a commission).
Buyers should be able to view the Sales List and order items they wish to buy. To order items, the buyer must have an account, which can be created with their first order. Buyers will place required items in a “basket”, and on “move to checkout”, the order will be created and debit card payment taken. A buyer should be able to view their orders and get contact details of sellers. After an item has been ordered, the system will inform the seller, who must then ensure that the item is delivered to the buyer. If the item is unsatisfactory, buyers can return the item to the seller and ask Orinoco for a refund.
Buyers may log satisfaction feedback about their experience of Orinoco or the seller. They may also complain to Orinoco if there are problems with the seller such as poor quality, late delivery, no refund for returned items, or poor service. Orinoco managers will then deal with the sellers, and may remove them from the Sellers list.
The management of Orinoco require a system to handle the above aspects of the business. Orinoco would like the website to have a very distinctive “look and feel” in line with the Orinoco brand. The company will also need advice on hardware and software. Security of the payment system is very important. In line with the requirements of GDPR, access to seller and buyer details should be secure. The company’s accountants will want to be able to produce accounts based on trading, but this is currently outside the scope of this project. The Managing Director is also keen that the system will be accessible to visually impaired buyers.
Types of relationships between classes are shown by different types of lines linking the classes. Give one example of each type of relationship shown in the above diagram:
·name the type of relationship
·identify the two classes that are linked by the relationship
·explain the nature of the relationship.
Explain the difference between implementing the above one-many relationship between Buyer and Order in a relational database and implementing it in an object-oriented language (such as Java).
If the OOPS system described above is implemented using a Relational Database, explain THREE different ways in which the relationship between Seller, Private and Retail can be reflected in database tables, and say briefly when you would use each way.
The acronym ORM is used in system implementation. Explain what ORM stands for, what it involves and why it is necessary:
The post Orinoco Order Processing System Case Study – OOPS appeared first on My Assignment Online.