Explain any assumptions made in your design.

Learning Goal: I’m working on a data engineering multi-part question and need an explanation and answer to help me learn.1. Design an appropriate dimensional model (in a graphical form) to support the business questions above. The granularity of the fact table(s) of the model should be at the level of the individual ATM transaction. Explain any assumptions made in your design. Provide a set of at least 2 sample rows of all table(s) of the proposed model. Where applicable, the rows you provide should use/include data from the operational data subset given to you.2. Design a second dimensional model (also in a graphical form) to support the business questions above. In the second model, the granularity of the fact table(s) should not be at the level of the individual ATM transaction. Moreover, the model should be optimal, in the sense that it should be at the appropriate granularity and include only the entities that are necessary in order to support the questions above. Therefore, you should not define a granularity or include other entities which are not required (marks may be deducted if you do so). Explicitly state the granularity of the fact table (or tables, if multiple) of your schema and include as many details as possible concerning the schemas’ attributes. Explain any assumptions made in your design. Provide a set of at least 2 sample rows of the fact tables of the proposed schema illustrating the respective data interrelationships. Where applicable, the rows you provide should use/include data from the operational data subset given to you.3. Design two suitable Cubes that show data corresponding to the following: ▪ Daily Number of Transactions, per card network type (Visa, Mastercard), per transaction type (withdrawal, deposit, etc.). ▪ Total Amounts of Daily Transactions per card type, per city, on Bank XYZ (“us”) terminals. Where applicable, the cubes should illustrate in their visible parts some corresponding data from the subset given to you (i.e. data for one day).4. Answer the following question: Apart from the identification of facts/measures, in order to be comprehensive on the proposed dimensional models, it is necessary to discuss and agree with the business stakeholders on at least one additional important aspect of the model. Identify this aspect and briefly explain its importance.
Requirements: As long as possible, i need a detailed explanation