Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are to develop a dimensional model for a bank data warehouse. The bank currently has a database system with the following tables: - Account
You are to develop a dimensional model for a bank data warehouse. The bank currently has a database system with the following tables: - Account - each record describes the characteristics of an account. - Client - each record describes the demographics and other characteristics of a client. - Disposition - each record relates a client with an account i.e., this relation describes the rights of clients to operate accounts. - Loan - each record describes a loan granted for a given account - Transaction - each record describes one transaction on an account. - District - each record describes demographic characteristics of a district. One client can have more than one account, and more than one client can own and access a single account. Clients and accounts are related together (i.e., mapped to each other) in relation Disposition. At most one loan can be granted for an account. However, many transactions may occur in an account. Even in a day, more than one transaction may take place in an account. Each district has only one bank branch. Account Client Disposition Loan District Transaction e bank wants to perform the following query: - List loan amount by branch mographics, owner demographics, loan date and loan status a. (5 pts.) Identify the measure and constraints in the query. b. (10 pts.)Develop a dimensional model. Your model must have FACT and DIMENSION tables. For each table, you need to identify all keys (primary and foreign, if applicable) and attributes to include. You need to also identify the relationships among the tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started