BFY maintains a website to get customer orders. Customer can visit BFY website either directly or through other websites having partnership with BFY. All the customers are required to create an account before placing an order. Customers of BFY can be classified into individual customers and business customers. Privileges for business customers differ from that of individual customers. For example, business customers are given 30 or more days credit apart from some trade discount. Business customers mostly pay through checks and credit cards after receipt of the books whereas the individual customers have to make payment through a credit card when they place an order. BFY keeps
Design the back-end
Order Processing System:
BFY maintains a website to get customer orders. Customer can visit BFY website either directly or through other websites having partnership with BFY. All the customers are required to create an account before placing an order. Customers of BFY can be classified into individual customers and business customers. Privileges for business customers differ from that of individual customers. For example, business customers are given 30 or more days credit apart from some trade discount. Business customers mostly pay through checks and credit cards after receipt of the books whereas the individual customers have to make payment through a credit card when they place an order. BFY keeps a track of all the payments that it has to receive from credit card companies and banks.
A customer can buy any book of his choice and any customer can buy any book. Customers are given different shipping options and the charges and the delivery time will vary accordingly. Likewise sales taxes vary according to the location of the customer. A customer can choose only one shipping option per order. BFY accepts all major cards for payment. Customer can use only one credit card per transaction. Customers can return the books if they wish and BFY will send the money back to them after certain period. Since the market is highly competitive, BFY has exclusive partnerships with many major web portals. When BFY gets a customer order through a partner’s reference, BFY gives a commission to it. These portals help BFY to get more orders.
BFY stocks an impressive collection of book titles. Any customer can search for books written by a particular author. BFY buys books directly from publishers. A publisher can supply many books. Whenever the quantity of books in stock goes down, an order is placed with the publisher.
Include the following :
List of main entities (limit to 6 major entities).
Relational schema depicting the attributes and primary keys that adequately describe the identified entities.
Entity Relationship Diagram based on standard notations. You should also highlight the cardinalities. If you identify any M:N relationship then you have to highlight composite entities in your ER Diagram.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
