2. A proposed relational model of the OLAP-BookShop is: REGION P REGION ID NUMBER (5) REGION NAME REGION PK (REGION_ID) VARCHAR2 SUBREGION P SUBREGION ID SUBREGION_NAME F REGION REGION_ID NUMBER (5) VARCHAR2 (30) NUMBER (5) SUBREGION PK (SUBREGION ID) SUBREGION REGION FK (REGION REGION_ID) PYEAR ID YEAR YEAR NUMBER (5) NUMBER (4) YEAR PK (YEAR_ID) MONTH P MONTH ID MONTH F YEAR YEAR ID NUMBER (5) VARCHAR2 (15) NUMBER (5) MONTH PK (MONTH_ID) MONTH YEAR FK (YEAR YEAR ID) P CODE F SUBREGION SUBREGION_ID WAREHOUSE NUMBER (5) NUMBER (5) SELL BY PRODUCT TICKET NUMBER FACTS TICKET NUMBER WAREHOUSE PK (CODE) WAREHOUSE CODE NUMBER NUMBER (5) F DAY DAY ID WAREHOUSE SUBREGION FK (SUBREGION SUBREGION_ID) F BOOKS ISBN VARCHAR2 (45) NUMBER (15) FACTS TICKET PK (TICKET_NUMBER) FACTS TICKET WAREHOUSE FK (WAREHOUSE_CODE) FACTS TICKET DAY_FK (DAY_DAY_ID) FACTS_TICKET_BOOKS FK (BOOKS ISBN) DAY NUM_DAY NUMBER (5) VARCHAR2 (45) NUMBER (5) * DAY_ID MONTH MONTH ID DAY PK (DAY ID) DAY MONTH FK (MONTH MONTH ID) BOOKS PISBN TITLE PRICE NUMBER (15) VARCHAR2 (45) VARCHAR2 (45) BOOKS PK (ISBN) Explain why the proposed design meets OLAP requirements. Comment on schema functionality. - model and their