skip navigation

Hallux Productions - Datasets

The Hallux database is comprised on 25 tables with over one million rows. It contains sales data from 1990 to 2006 from 5000 customers and 400 bands.

Band_Id Number of Albums Zip Code
1000 11 90001
1001 3 39577
1002 11 00924
1003 1 11694
1004 3 75681
1005 2 17046
1006 5 37211
1007 5 92243
1008 4 11375
1009 11 21532
1010 2 32773
1011 9 40013
1012 7 19139
1013 4 91340
1014 8 27502
1015 6 42001
1016 2 95117
1017 9 01040
1018 10 42223
1019 9 33920
1020 12 97520
1021 4 45014
1022 11 32401
1023 1 29150
1024 5 70510
1025 11 55364
1026 10 29728
1027 3 53202
1028 9 04102
1029 5 98024
1030 11 35957
1031 12 98626
1032 1 23233
1033 12 21742
1034 4 30004
1035 8 31406
1036 5 38128
1037 1 13021
1038 8 50266
1039 8 80526
1040 5 19355
1041 10 62521
1042 7 03102
1043 6 13617
1044 9 60621
1045 3 90006
1046 11 11362
1047 5 90012
1048 9 50554
1049 12 53209
1050 7 11213
1051 7 32207
1052 4 18018
1053 4 30080
1054 7 11377
1055 12 28083
1056 1 12958
1057 3 11718
1058 3 64133
1059 6 90026
1060 10 11220
1061 1 06385
1062 4 82520
1063 12 45653
1064 12 15024
1065 11 99005
1066 6 62703
1067 10 42081
1068 10 60548
1069 3 32068
1070 11 95446

   

Below is the ERD for Hallux Productions dataset.

Metadata for the UA_HALLUX dataset is shown below.

Attribute Name Description Possible Values
Agent_ID Agent_ID is a Person_ID. Uniquely identifies an Agent Person_ID
Agent_Status_Code Whether an agent is active or inactive "A"=Active, "I"=Inactive
Album_Count Number of albums to be produced under a contract  
Album_ID Uniquely identifies an album.  
Album_Name The name of an album  
Album_Rev_Pct The percentage the band makes on each album "0.00-1.00" i.e. 0.20 (20%)
Band_ID Uniquely identifies a band.  
Band_Name The name of a Band  
Band_Status_Code Whether a band is active or not "A"=Active, "I"=Inactive
Begin_Date The date a contract begins  
Birthdate The birthdate an individual customer provides for their online profile  
City The city associated with a certain ZIP code  
Commission The percentage an agent gets from his or her sales "0.0000-1.0000" i.e. 0.0650 (6.5%)
Contact_Phone The phone number for the contact person at a Venue  
Contract_ID Uniquely identifies a contract  
Customer_ID Uniquely identifies a customer  
Duration_Seconds The length of the song in seconds i.e. 180, 220, 167
Email The e-mail address for a customer or person  
End_Date The date a contract ends  
Favorite_Album This is an Album_ID representing a customer's favorite album Album_ID
Favorite_Band This is a Band_ID representing a customer's favorite band Band_ID
Favorite_Song This is a Song_ID representing a customer's favorite song Song_ID
First_Name The first name of an individual customer or person  
Formation_Date The date a band officially formed  
Gender Whether the customer is male or female "M"=Male, "F"=Female
Genre A genre of music  
Genre_ID Uniquely identifies a genre  
Hire_Date When an agent was hired  
Instrument_ID Uniquely identifies an instrument  
Instrument_Name The name of the instrument Vocals, Piano, Guitar, etc
Item_Description A description of the item  
Item_ID This is either an Album_ID, Song_ID, or Video_ID Album_ID, Song_ID, or Video_ID
Item_Type What type of item this is Album, Song, or Video
Item_Type_ID Uniquely identifies an item type  
Join_Date The date a band member joined the band  
Last_Name The last name of an individual customer or person  
Latitude The latitude of the location represented by the ZIP code  
Line_Number The line number of that item on an order.   
Live_Count The number of live performances in a contract  
Live_Rev_Pct The percentage the band makes on each live performance "0.00-1.00" i.e. 0.20 (20%)
Longitude The longitude of the location represented by the ZIP code  
Member_ID Member_ID is a Person_ID. This uniquely identifies a member of a band.  
Member_Status_Code Whether a member is active or inactive "A"=Active, "I"=Inactive
Name The full name of a customer. Either a company name or the full name of an individual  
Order_Date The date and time an order is placed i.e. 9/1/2007 3:26 PM
Order_ID Uniquely identifies an order  
Order_Source_ID Uniquely identifies the source of an order.  
Performance_Date The date of the performance  
Performance_ID Uniquely identifies a performance  
Person_ID Uniquely identifies a person. Value is used for Agent_ID, Member_ID, and Primary_Contact_ID  
Phone_Number The phone number for a person or customer i.e. 479-555-5555
Primary_Contact_ID Primary_Contact_ID is a Person_ID. Identifies the primary contact person for a band.  
Producer_ID Uniquely identifies a video production company  
Producer_Name The name of a video production company  
Production_Cost The total cost to produce an album i.e. 1000.00
Profile_ID Profile_ID is a Customer_ID. Uniquely identifies a customer profile and associates it with a customer  
Promise_Date The date of arrival promised for an order.  
Quantity The number of the particular item ordered on that line  
Release_Date The date an album is released  
Revenue The amount brought in from a performance  
Salary The salary received by an agent  
Sequence The track number the song appears on the album "1-99"
Song_ID Uniquely identifies a song  
Song_Name The name of the song  
Source_Description Description of the source for orders.  
Source_Name Name of a source  
State_Abbr The 2 letter abbreviation for a State  
State_Name The full name of a State  
Street_Address The street address of a person, customer, or venue  
Subtotal_Amount The total amount of an order before tax is added to the order  
Tax_Amount The amount of tax to be applied to the order  
Total_Amount The total amount with tax to be charged to the customer for this order  
Unit_Price The price of the item on that line of the order i.e. 9.00 or 11.50
Venue_ID Uniquely identifies a venue  
Venue_Name The name of the venue  
Video_ID Uniquely identifies a video  
Video_Name The title of the video  
ZIP_Code Uniquely identifies a location in the U.S. in the ZIP_Code table.  
ZIP_Code_Ext The last 4 numbers in an extended 9-digit ZIP code  
Enterprise Systems
Business Building 225
Fayetteville, AR 72701
(479) 575-6114  p