The database schema should support the business requirements rather than the typical query-driven requirements of an OLTP database design. For example, given the following database schema from an order entry system:
The steps involved in converting this OLTP schema into a star schema include: