Central Hospital is a fictional general hospital located in more than 50 locations. Each local central hospital has more than 70 departments (e.g. Emergency, Allergy, Cancer Care, Pediatrics, Pharmacy), hundreds of doctors, nurses, and staff. A special service provided by Central Hospital is patients have their medical accounts. They can deposit money in advance to their accounts with extra credits. For example, by depositing $75 in advance in the medical accounts, patients will receive $100 credits and can use them for paying all the bills generated by the hospital. There's no expiration date for the credits in the accounts. Every time after a patient visited the central hospital, a bill will be generated. The majority of the bill will be paid by insurance companies. For the remaining balance of the bill, the patient can pay them using the credits from the medical account, cash, credit cards, debit cards, and so on. Central Hospital wants to build a data warehouse and use the data warehouse to answer the following questions: (1). Which local central hospitals, what departments and what doctors are generating most of the bills? (2). Who are our patients, and how are they paying for their bills? (3). What is the daily balance of credit in a medical account? (4). What is the % used and % left of credits in the medical accounts given in a particular month? (5). When filling claims to patients' insurance companies, what is the average duration between the claim filling date and the payment receipt date? To answer the above questions, please design a dimensional model (star schema) to include all the necessary dimensions and facts by following the steps: (1). Identify the business process; (2). Determine the dimensions; (3). Identify the facts; (4). Draw the star schema by connecting the tables. If you need more than one fact table in your model. The design of the dimensional model is very flexible, you can include all the dimensions and facts you think are necessary for the model. Please clearly explain the reasons why you include certain dimension tables and fact measurements, and how they can further be used to answer the above questions. Please also indicate certain attributes you think are important in the tables (At least 4 attributes for each table). For the definitions of dimension and fact tables, please use the metadata tables with the following columns: Column Name When you Nullable Description draw your final star schema, you need the full list of attributes in the tables: PRODUCT CALENDAR CalendarKey ProductKey SALES Fact fact table Day Month Year CalendarKey (FK) ProductID ProductName STORE ProductKey (FK) StoreKey (FK) CustomerKey DollarsSold (FK) CUSTOMER StoreKey CustomerKey StoreID Store Zip |CustomerID CustomerZip Instructions: Use ERDPlus (https://erdplus.com) to create the star schema and import it to image that you can embed in a MS Word Document and submit it under this submission area. You can work in groups/individually