1. How would a view of the entire database for certain tables out of that database allow us to get a feel for the data?

2. What types of data would you guess that Dillard's, a retail store, gathers that might be useful? How could Dillard's suppliers use these data to predict future purchases?

Quick Launch (Ctrl+Q) E TRANSACT (dbo) (Read-only) 9 TRANSACTION ID TRAN_DATE STORE REGISTER + TRANNUM TRAN TIME CUSTID TRAN_LINE_NUM MIC TRAN_TYPE ORIG_PRICE SALE PRICE TRAN AM TENDER TYPE SKU ESSQL1.WCOB_DILLARDS - Diagram_0* - Microsoft SQL Server Management Studio File Edit View Project Table Designer Tools Window Help 9. New Query 3 % 19 - | Execute E = 1.7 Object Explorer 4 X ESSQL1.WCOB_DILLARDS - Diagram_0* = X Connect Tyth # UNILSP215044 UNILSP215045 UNILSP215046 # UNIL SP215047 # UNILSP215048 # UNILSP215049 # UNILSP215050 # UNILSPF001 UNREDLF001 # UNSTGAF001 UNVTORF001 VRICPROJECT WCOB_DILLARDS # Database Diagrams Tables + Views External Resources SKU (dbo) (Read-only) + Synonyms Programmability SKU_CLASS Service Broker SKU_STYLE # Storage # Security #wcob_esreq WCOB_RSC WCOB_RSC_Test #WCOB_SAMS_INTEGRATED #WCOB_SAMS_SALES #WCOB_SAMS_STOREVISITS # WCOB-ESAS WCOB-ESAS-C DEPARTMENT (dbo) (Read-only) wensu 9 DEPT Xanadu # xz035 yelpdb + YelpReviews # zresearch + 9 SKU DEPT SKU_STORE (dbo) (Read-only) 9 STORE 9 SKU UPC COLOR RETAIL SKU_SIZE OOST CUSTOMER (dbo) (Read-only) 9 CUST ID BRAND NAME STORE (dbo) (Read-only) 9 STORE CLASSIFICATION OTY PACKS ZE DIVISION CITY STATE STATE F ZIP CODE ZIP SECSEG ZIP CODE ZIP SECSEG DISTANCE TO NEAREST STORE PREFERRED STORE DEPT DES DEPTDEC DEPTOEC DESC DEPTCENT DEPTCENT DESC O Ready H -- mm @ 8 9 10 3:11 PM 9/21/2021 Quick Launch (Ctrl+Q) E TRANSACT (dbo) (Read-only) 9 TRANSACTION ID TRAN_DATE STORE REGISTER + TRANNUM TRAN TIME CUSTID TRAN_LINE_NUM MIC TRAN_TYPE ORIG_PRICE SALE PRICE TRAN AM TENDER TYPE SKU ESSQL1.WCOB_DILLARDS - Diagram_0* - Microsoft SQL Server Management Studio File Edit View Project Table Designer Tools Window Help 9. New Query 3 % 19 - | Execute E = 1.7 Object Explorer 4 X ESSQL1.WCOB_DILLARDS - Diagram_0* = X Connect Tyth # UNILSP215044 UNILSP215045 UNILSP215046 # UNIL SP215047 # UNILSP215048 # UNILSP215049 # UNILSP215050 # UNILSPF001 UNREDLF001 # UNSTGAF001 UNVTORF001 VRICPROJECT WCOB_DILLARDS # Database Diagrams Tables + Views External Resources SKU (dbo) (Read-only) + Synonyms Programmability SKU_CLASS Service Broker SKU_STYLE # Storage # Security #wcob_esreq WCOB_RSC WCOB_RSC_Test #WCOB_SAMS_INTEGRATED #WCOB_SAMS_SALES #WCOB_SAMS_STOREVISITS # WCOB-ESAS WCOB-ESAS-C DEPARTMENT (dbo) (Read-only) wensu 9 DEPT Xanadu # xz035 yelpdb + YelpReviews # zresearch + 9 SKU DEPT SKU_STORE (dbo) (Read-only) 9 STORE 9 SKU UPC COLOR RETAIL SKU_SIZE OOST CUSTOMER (dbo) (Read-only) 9 CUST ID BRAND NAME STORE (dbo) (Read-only) 9 STORE CLASSIFICATION OTY PACKS ZE DIVISION CITY STATE STATE F ZIP CODE ZIP SECSEG ZIP CODE ZIP SECSEG DISTANCE TO NEAREST STORE PREFERRED STORE DEPT DES DEPTDEC DEPTOEC DESC DEPTCENT DEPTCENT DESC O Ready H -- mm @ 8 9 10 3:11 PM 9/21/2021