Question

1 Approved Answer

Posted on Jun 24, 2024

What are the data entities present (~tables)? What data elements or attributes are present (~columns)? What are the expected data types of the data elements/attributes?

What are the data entities present (~tables)?
What data elements or attributes are present (~columns)?
What are the expected data types of the data elements/attributes?

Q G H Sales Customer Name Manufacturer Order Date PK Order ID PK Postal Code Product Name PK Region Segment Ship Date Ship Mode State Sub-Category Discount Number of Records Profit Profit Ratio Quantity Category City Country 1/3/13 CA-2011-103800 77095 Message Book Central Consumer 1/7/13 Standard Class Texas Paper 20% $6 34% 2 $16 Office Supplies Houston United States Darren Powers Message Book 36% $12 3 Office Supplies Naperville United States Phillina Ober Avery 1/4/13 CA-2011-112326 6054 Avery 508 Central Home Office 1/8/13 Standard Class Illinois Labels 20% $65 -24% $273 4 Office Supplies Naperville United States Phillina Ober SAFCO 1/4/13 CA-2011-112326 60540 AFCO Boltless Steel Shelving Central Home Office 1/8/13 Standard Class Illinois Storage 20% $5 -155% Naperville United States Phillina Ober GBC 1/4/13 CA-2011-112326 6054 GBC Standard Plastic Binding System Central Home Office 1/8/13 Standard Class Illinois Binders 80% 5 Office Supplies $5 $20 Philadelphia United States Mick Brown Avery 1/5/13 CA-2011-141817 19143 Avery Hi-Liter EverBold Pen Style FI East Consumer 1/12/13 Standard Class Pennsylvania Art 20% 25% 6 Office Supplies 0% $9 48% Los Angeles United States Lycoris Saunders Xerox 1/6/13 CA-2011-130813 90049 Xerox 225 West Consumer 1/8/13 Second Class California Paper South First Class Art 41% - N N N OW WW N WW 7 Office Supplies Corporate 1/7/13 Georgia 0% $13 8 Office Supplies Athens United States Jack O'Briant Dixon 1/6/13 CA-2011-106054 30605 Dixon Prang Watercolor Pencils 1/10/13 Standard Class Kentucky Chair 0% $746 29% $2,574 9 Furniture Henderson United States Maria Etezadi Global 1/6/13 CA-2011-167199 42420 Global Deluxe High-Back Manager's South Home Office $274 $610 Henderson United States Maria Etezadi Ibico 1/6/13 CA-2011-167199 42420 bico Hi-Tech Manual Binding System South Home Office 1/10/13 Standard Class Kentucky Binders 0% 45% 10 Office Supplies Standard Class Kentucky Art 0% $1 27% 11 Office Supplies Henderson United States Maria Etezadi Rogers 1/6/13 CA-2011-167199 42420 Rogers Handheld Barrel Pencil Sharp South Home Office 1/10/13 GE 30524EE4 Sout Home Office 1/10/13 Standard Class Kentucky Phones 0% $114 29% $392 12 Technology Henderson United States Maria Etezadi GE 1/6/13 CA-2011-167199 42420 1/10/13 Standard Class Kentucky Phones 0% $204 27% $756 13 Technology Henderson United States Maria Etezadi Other 1/6/13 CA-2011-167199 42420 Wireless Extenders zBoost YX545 SO South Home Office Fasteners 0% SO 1% $31 United States Maria Etezadi Alliance 1/6/13 Sout Home Office 1/10/13 14 Office Supplies Henderson CA-2011-167199 42420 Alliance Super-Size Bands Standard Class Kentucky Standard Class Kentucky Paper 0% $3 46% 15 Office Supplies United States Maria Etezad CA-2011-167199 42420 Southworth 25% Cotton Granite Par South Home Office 1/10/13 Henderson Southworth 1/6/1 $54 $77 16 Furniture Huntsville United States Vivek Sundaresam Howard Miller 1/7/13 CA-2011-105417 77340 Howard Miller 14-1/2" Diameter Chi Central Consumer 1/12/13 Standard Class Texas Furnishings 60% -70% 1/7/13 CA-2011-105417 77340 Acco Four Pocket Poly Ring Binder w Central Consumer 1/12/13 Standard Class Texas Binders 80% $18 175% $10 17 Office Supplies Huntsville United States Vivek Sundaresam Acco Newell 1/9/13 CA-2011-135405 78041 Newell 312 Central Consume 1/13/13 Standard Class Texas Art 20% $1 13% 18 Office Supplies Laredo United States Melanie Seite Standard Class Texas Accessories 20% $10 31% $31 Laredo United States Melanie Seite Memorex 1/9/13 CA-2011-135405 78041 Memorex Micro Travel Drive 8 GB Central Consumer 1/13/13 19 Technology 0% 47% 20 Office Supplies Springfield United States Anthony Jacobs Avery 1/10/13 CA-2011-149020 22153 Avery 482 South Corporate 1/15/13 Standard Class Virginia Labels $1 1/15/13 Standard Class Virginia Furnishings |0% $21 419 $52 21 Furniture Springfield United States Anthony Jacobs Howard Miller 1/10/13 CA-2011-149020 22153 Howard Miller 11-1/2" Diameter Ric South Corporate DAX 1/11/13 CA-2011-130092 19901 DAX Value U-Channel Document Fra East Consume 1/14/13 Delaware Furnishings |0% $3 31% $10 First Class 22 Furniture Dove United States Seth Vernon 1/15/13 Second Class Louisiana Envelopes 0% $5 47% $11 23 Office Supplies Bossier City United States Chris Selesnick Staple envelope 1/13/13 CA-2011-162775 71111 Staple envelope South Corporate $51 Bossier City United States Chris Selesnick Other 1/13/13 CA-2011-162775 71111 Brown Kraft Recycled Envelopes South Corporate 1/15/13 Second Class Louisiana Envelopes 0% $25 509 24 Office Supplies N U O O W OWNNER 1/13/13 CA-2011-162775 71111 Plantronics S12 Corded Telephone H Sout Corporate 1/15/13 Second Class Louisiana Accessories 0% $259 409 $64 25 Technology Bossier City United States Chris Selesnick Plantronics $6 3-ring staple pack 1/13/13 CA-2011-162775 71111 3-ring staple pack South Corporate 1/15/13 Second Class Louisiana Binders 0% $3 489 26 Office Supplies Bossier City United States Chris Selesnick 0% $34 6% $57 27 Office Supplies Bossier City United States Chris Selesnick Fellowes 1/13/13 CA-2011-162775 71111 Fellowes Stor/Drawer Steel Plus Sto South Corporate 1/15/13 Second Class Louisiana Storag $87 29464 16% $546 Mount Pleasant United States Natalie DeCherney Global 1/13/13 CA-2011-109232 Global Highback Leather Tilter in Bu South Consume 1/16/13 Second Class South Carolina Chairs 28 Furniture 0% $239 18% $1,326 29 Office Supplies San Francisco United States Brian Dahlen Tennsco 1/13/13 CA-2011-157147 94109 Tennsco 6- and 18-Compartment Lock West Consumer 1/18/13 Standard Class California Storage Bookcases 15% $4 1% $334 30 Furniture San Francisco United States Brian Dahlen O'Sullivan 1/13/13 CA-2011-157147 94109 O'Sullivan Elevations Bookcase West Consumer 1/18/13 Standard Class California Art $7 33% $20 31 Office Supplies San Francisco United States Brian Dahlen Other 1/13/13 CA-2011-157147 94109 4009 Highlighters by Sanford West Consumer 1/18/13 Standard Class California 43055 East Consumer 1/18/13 Standard Class Ohio Paper 20% $13 35% $37 32 Office Supplies Newark United States Michael Moore Xerox 1/13/13 CA-2011-118192 Xerox 1923 Avery 1/13/13 CA-2011-118192 43055 Avery Metallic Poly Binders East Consumer 1/18/13 Standard Class Ohio Binders 709 -$3 -73% $3 33 Office Supplies Newark United States Michael Moore Sauder 1/14/13 CA-2011-149524 19140 Sauder Cornerstone Collection Libral East Corporate 1/15/13 First Class Bookcases 50% -$53 1-86% $62 34 Furniture Philadelphia United States Brendan Sweed Pennsylvania Consumer 1/17/13 First Class Georgia Accessories 10% $ 66 44% $150 35 Technology Roswell United States Erica Hackney Logitech 1/15/13 CA-2011-103366 30076 Logitech 910-002974 M325 Wireless South 1529 $127