University of Arkansas

Walton College

The Sam M. Walton College of Business

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.

Data Dictionary and Entity Relationship Diagram

ERD

Dillards ERD

  • STRINFO (Store Information)
  • SKSTINFO (Sku and Store Information)
  • SKUINFO (Sku Information)
  • TRNSACT (Transaction Information)
  • STORE_MSA (Store/Metropolitan Statistical Area information)
  • DEPTINFO (Department Information)

Metadata

Attribute Description Values
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, ...

Sample

UA_DILLARDS contains sales transaction data for 453 Dillard's Department stores between August 2004 and July 2005.

DEPT ROW COUNT DEPTDESC
800 13,943,284 CLINIQUE
801 615,445 LESLIE
1100 350,695 GARY F
1107 1,055,599 JACQUES
1202 6,324,235 CABERN
1301 2,688,698 BE2
1704 1,146,320 R LAUREN
1905 1,765,532 R & Y
2102 4,450,180 CAB
2105 2,253,878 R TAYLOR
2107 1,925,467 MAI
2200 5,621,248 CELEBRT
2301 2,505,593 BEP
2503 1,204,225 CHORUS
3100 443,143 4711
3102 1,843,755 CAMBIO
3103 2,315,957 COP
3105 327,473 AUSTIN
3107 393,772 ONEIDA
3404 2,285,389 CITIZENS
3701 777,613 LACOSTE
4303 3,475,364 ESPRIT
4400 256,772 BORA
4402 5,189,640 1928
4407 199,826 ENVIRON
4505 5,763,323 POLOMEN
4704 563,218 DKNY
4801 111,097 GOTTEX
5100 800,700 COLOR
5102 2,284,121 P&Y
5203 3,278,462 COLEHAAN
5207 533,400 H SIERR
5301 1,356,282 KAREN K
5305 1,084,835 LIZ CLA
5404 1,902,502 CARTIER
5506 14,931 MOSCHINO
6006 2,983,211 INVEST
6107 3,144,346 NOB
6400 518,895 BLUE
6402 4,955,996 FREDERI
6404 3,151,918 ELLEN T
6505 2,871,267 ST JOHN
6601 426,252 MATTY M
7101 2,679,701 CAROLE
7102 1,512,383 BCH
7104 1,288,330 CARTERS
7106 1,464,803 BRIOSO
7200 247,335 COFFRET
7205 300,564 LOUISVL
7307 1,372,421 SIGRID O
8000 288,976 ETERNIT
8002 507 C KLEIN
8101 2,944,755 ECHO
8104 352,542 COP KEY
8305 2,155,521 NO FEAR
8306 1,298,724 REEBOK
9000 281,513 ANNASUI
9105 2,843,904 LISLI
9306 864,648 SPERRY
9801 1,916,410 CATALIN

Download PDF

Download