Dillard's Department Stores
Dillard's Inc., founded in 1938, is a publicly traded U.S.-based retailer. Dillard's ranks among the largest U.S. fashion apparel and home furnishings retailers. Dillard's has grown through expansion into mall properties as well as through acquisition of smaller department stores. Headquartered in Little Rock, Arkansas, Dillard's has been using centralized computer systems since the 1960's.
The Dillard's Department Store Database contains retail sales information gathered from store sales transactions. The sale process begins when a customer brings items intended for purchase (clothing, jewelry, home décor, etc) to any store register. A Dillard's sales associate scans the individual items to be purchased with a barcode reader. This populates the transaction table (TRNSACT), which will later be used to generate a sales receipt listing the item, department, and cost information (related price, sale price, etc.) for the customer. When the customer provides payment for the items, payment details are recorded in the transaction table, the receipt is printed, and the transaction is complete. Other tables are used to store information about stores, products, and departments.
This retail sales information, UA_DILLARDS, was provided to the Walton College of Business by Dillard's stores, Inc. Consisting of 5 tables with more than 128 million rows already populated and ready for use.
This is a gifted dataset that is based on real operational data. Like any real database, integrity problems may be noted. This can provide a unique opportunity not only to expose students to real data but also to illustrate the effects of data integrity problems.
Below is the ERD for the Dillard's Department Store Database.
The six tables are: STRINFO (Store Information), SKSTINFO (Sku and Store Information), SKUINFO (Sku Information), TRNSACT (Transaction Information), STORE_MSA (Store/Metropolitan Statistical Area information), and DEPTINFO (Department Information).
Below is an actual table retrieved from the Dillard's Department Stores Database.
UA_DILLARDS contains sales transaction data for 453 Dillard's Department stores between August 2004 and July 2005.
|1905||1,765,532||R & Y|
Metadata for the Dillard's Department Stores Database is shown below.
|AMT||Total amount of the transaction charge to the customer||26.25, 44.00, ...|
|BRAND||The brand name of the stock item||TOMMY HI, MARK ECK, ...|
|CITY||City where the store is located||ST. LOUIS, TAMPA, ...|
|CLASSID||Stock Item Classification||5305, 4505, 8306, ...|
|COLOR||The color of the stock item||BLACK, KHAKI, ...|
|COST||The cost of the stock item||9.00, 15.00, ...|
|DEPT||Department where the stock item belong||800, 801, 1100, ...|
|DEPTDESC||Description of the department||CLINIQUE, LESLIE, ...|
|INTERID||Internal ID||265005802, 671901998, ...|
|MIC||Master Item Code||862, 689, ...|
|ORGPRICE||Original price of the item stock||75.00, 44.00, ...|
|PACKSIZE||The quantity of item per pack||1, 3, ...|
|QUANTITY||Item quantity of the transaction||1, 2, 3, ...|
|REGISTER||Register Number of the current transaction||580, 30, 460, ...|
|RETAIL||The retail price of the stock item||19.75, 34.00, ...|
|SALEDATE||Sale price of the item stock||2005-01-20, 2005-06-02, ...|
|SEQ||Sequence number||298100028, 213500030, ...|
|SIZE||The size of the stock item||L, 070N, 22, ...|
|SKU||Stock Keeping Unit number of the stock item||4757355, 2128748, ...|
|SPRICE||Sale price of the item stock||26.25, 65.00, ...|
|STATE||State where the store is located||FL, MO, AR, ...|
|STORE||Store Number||2, 3, 4, 100, ...|
|STYLE||The specific style of the stock item||51 MERU08, 9 126NAO, ...|
|STYPE||Type of the transaction (Return or Purchase)||P, R|
|TRANNUM||Transaction Code||09700, 01800, ...|
|UPC||Universal Product Code for the stock item||000400004087945, ...|
|VENDOR||The vendor number of the stock item||5511283, 2726341, ...|
|ZIP||ZIP Code||33710, 63126, ...|