Question: In SQL server answer for following questions then apply it and screenshot output : - Create all tables and relationship - Insert values for tables

In SQL server answer for following questions then apply it and screenshot output : - Create all tables and relationship - Insert values for tables - Create one index,cube query for each tables
Insurance Claims Dimensional Model Calendar PK Day Date Claims Week Number Month Number PK Claim ID Year Number FK Claim outcome Code FK Customer Policy. ID Date of Claim Date of Settlement Amount Claimed Amount Paid Claims Dimensional Model Total Policies Revenue Total Claims Settlements o PK Fact ID Claim Description FK Claim ID Other Details FK Claim Status Code FA Customer ID FK Date of Claim Customers FK Date of Settlement FK Employee ID PK customer ID FK Policy ID First Name FK Reporting Day.Date Middle Name Amount Claimed Last Name Amount Paid Gender MFU Total Claims Settlements Date of Birth Other Details Medication Medical Conditions Comments Other Details Database Answers Ltd. 2013 Employees o PK Employee ID Employee Details Policies PK Policy ID Policy Type Code Start Date End Date Other Details Ref Claim Status PK Claim Status Code Claim Status Description eg Disputed, in Progress, Settled
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
