A database tracks municipal construction projects. Each project has a different code and many orders for materials. Each order is named with the project code and an order number, beginning at 1000 for all projects. Orders have one or more line items, numbered sequentially, beginning at 1 for all orders.
Project ___
Order ___
LineItem ___