bad 5

Uses of the Oracle DBMS

Written by Super User. Posted in bad 5

The Oracle DBMS serves many online retailers, organizing their customer and sales data. A Web database contains customer, order header, order detail and product tables. The customer table, for example, consists of the customer’s name, billing and shipping addresses, credit card and other information. The order header table has an order date, customer ID code and a unique order ID. Order details have an item number, price, and order and ship dates. The product table has a stock keeping unit (SKU) code, description and price. When the customer places an order, the database software looks up his customer record and adds an order header record. As he adds items to his Web shopping basket, the database adds order detail records. The Web store owner runs reports on the database, totaling sales for the month, by state or for any criterion for which the database has information.