Hallux Productions (HP) is a small music publishing and management company focusing on local and regional artists in the Mid-South. HP aims to be a "one-stop shop" for bands and individual music artists by offering recording contracts, live booking services, marketing, and album sales and distribution. Income is generated through two primary sources: album sales and booking services. To assist in this process, HP employs agents who search for talent, execute and manage recording contracts, and schedule live appearances. HP also maintains relationships with venues in the areas it serves to provide a steady source of talent for the locations and a stream of events for the artists. In return, HP earns a percentage of ticket sales or cover charges for each performance.
The Hallux database contains information that provides a snapshot of the company over all of the ideas discussed above. The Contract table specifies the terms of the contract, which may be one of many possibilities: duration, a certain number of albums, a certain number of live performances, or perpetual. It also specifies the percentage to be earned by the client on album sales and live performances. An agent's contact information, hire date, and status is stored in the Agent table. Album information is recorded in the Album table and live bookings are tracked in the Performance table. The tables containing the most amount of data are the Order tables: Order_Detail, Order_Header, and Order_Source. These tables, in aggregate, detail orders that HP has managed and contain the source, date, total, and the contents of the order. Finally, HP keeps a record of the clients in the Band table. A contact person, status, members, members' contact information, and instruments are all stored.