"Investment Banking Data Model"

Questions:1) identify the fact table 2) identify the dimension tables, 3) for each dimension table, identify the attribute(s) that would be matched to an attribute in the fact table, and 4) list four queries that could be produced from this data model.

For example, the queries from a data model of real estate sales that could typically be produced by matching a fact table to one or more dimension tables include: a) list of properties sold by each real estate agent, b) total properties sold by state, c) types of properties sold by month and year, d) dollar value of properties sold by each real estate company, e) total homes sold by real estate agent by company by year.

Accounts PK Account_ID Account_Details Data Warehouse for Investment Banks - Final Version Barry Williams Database Answers March 9th. 2011 Locations PK Location_Name Location_Details - - - - - - Brokers PK Broker_ID Broker_Details Products PK Product_ID Product_Details - Clients PK Client_ID HO- Clients_Details O Regions PK Region_Code Region_Details Currencies PK Currency_Code Currency_Details O - Data_Warehouse_Facts_m PK Fact_ID FK Account_ID FK Broker_ID FK Client_ID FK Currency_Code FK Deal_ID FK Deal_Type_Code FK Facility_ID FK ISO_Country_Code FK Location_Name FK Product ID FK Region_Code FK Reporting_Day_Date > FK Settlement_ID FK Trader_ID FK Transaction_ID FK Transaction_Type_Code Averages, Counts, Totals KPIs, Graphs, Trends Percentages, Returns Other Derived Figures Settlements PK Settlement_ID Settlement_Details Facilities PK Facility_ID HO Facility_Details Traders PK Trader_ID Trader_Details 6 B Deals PK Deal_ID HO- Deal_Details Transactions -04 PK Transaction ID Transaction_Details - - - Ref_Calendar PK Day_Date Day_Number Ref_Countries PK ISO_Country_Code Country Name Ref_Deal_Types PK Deal_Type_Code Deal_Type_Description Ref_Transaction_Types PK Transaction_Type_Code Transaction_Type_Description Accounts PK Account_ID Account_Details Data Warehouse for Investment Banks - Final Version Barry Williams Database Answers March 9th. 2011 Locations PK Location_Name Location_Details - - - - - - Brokers PK Broker_ID Broker_Details Products PK Product_ID Product_Details - Clients PK Client_ID HO- Clients_Details O Regions PK Region_Code Region_Details Currencies PK Currency_Code Currency_Details O - Data_Warehouse_Facts_m PK Fact_ID FK Account_ID FK Broker_ID FK Client_ID FK Currency_Code FK Deal_ID FK Deal_Type_Code FK Facility_ID FK ISO_Country_Code FK Location_Name FK Product ID FK Region_Code FK Reporting_Day_Date > FK Settlement_ID FK Trader_ID FK Transaction_ID FK Transaction_Type_Code Averages, Counts, Totals KPIs, Graphs, Trends Percentages, Returns Other Derived Figures Settlements PK Settlement_ID Settlement_Details Facilities PK Facility_ID HO Facility_Details Traders PK Trader_ID Trader_Details 6 B Deals PK Deal_ID HO- Deal_Details Transactions -04 PK Transaction ID Transaction_Details - - - Ref_Calendar PK Day_Date Day_Number Ref_Countries PK ISO_Country_Code Country Name Ref_Deal_Types PK Deal_Type_Code Deal_Type_Description Ref_Transaction_Types PK Transaction_Type_Code Transaction_Type_Description