This is database schema of a company sells computer hardware including storage, motherboard, RAM, video card, and CPU.
The company maintain following information in database
Product information such as name, description standard cost, list price, and product line.
Inventory information for all products including warehouses where products are available.
warehouses locations The company operates globally, it has warehouses in various locations around the world.
Customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe.
sales order Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled.
employee data the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date.
Download Oracle Sample database
Download the following sample database in zip file format:
After downloading the file, you should extract it. The zip file contains the following *.sql files:
ot_create_user.sql is for creating OT user and grant privileges
ot_schema.sql is for creating database objects such as tables, constraints, etc.
ot_data.sql is for loading data into the tables.
ot_drop.sql is for removing all objects in the sample database.