The following illustrates the sample database diagram: Table Names

In addition to the sales information, the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date. In case the customer cancels an order, the order status becomes canceled. When the company ships the order, the order status becomes shipped. Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. The company also places a credit limit on each customer to limit the amount that customer can owe. Each customer has at least one contact person with detailed information including name, email, and phone. The company records all customer information including name, address, and website. Because the company operates globally, it has warehouses in various locations around the world. It also tracks the inventory information for all products including warehouses where products are available. The company maintains the product information such as name, description standard cost, list price, and product line.

We provide you with an Oracle sample database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. Introduction to the OT Oracle sample database To create this database for practicing, you follow the creating the Oracle Sample Database tutorial. It doesn’t show you how to create this sample database in Oracle. Note that this tutorial explains you the Oracle Sample Database. Summary: this tutorial introduces you to an Oracle sample database and provides you with the links for you to download it.

Oracle pl sql developer download free