In SQL server answer for following questions then apply it and screenshot output

Question

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

Explanation / Answer

As per given model:

CREATE TABLE Claims (
Claim_ID int NOT NULL,
Claim_Outcome_Code int NOT NULL,
Customer_Polocy_ID int NOT NULL,
Date_Of_Claim DATE,
Date_Of_Statement DATE,
Amount_Claimed NUMBER,
Amount_Paid NUMBER,
Total_Policies_Revenue int,
Total_Claims_Settlements int,
Claim_Description VARCHAR2(255),
Other_Details VARCHAR2(255),
PRIMARY KEY (Claim_ID),
FOREIGN KEY (Claim_Outcome_Code)

REFERENCES Claims_Dimensional_Model

(Claim_Status_Code)

FOREIGN KEY (Claim_Policy_ID) REFERENCES

Poicies(Policy_ID)

);

CREATE TABLE Customers (
Customer_ID int NOT NULL,
First_name VARCHAR2(25),
Middle_name VARCHAR2(25),
Last_name VARCHAR2(25),
Date_Of_Birth DATE,
Gender_MFU VARCHAR2(1),
Mediciation VARCHAR2(255),
Medical_Conditions VARCHAR2(255),
Comments VARCHAR2(255),
Other_Details VARCHAR2(255),
PRIMARY KEY (Customer_ID),

);

CREATE TABLE Calendar (
  
Day_Date DATE,
Weak_Number NUMBER,
Month_Number NUMBER,
Year_Number NUMBER,
PRIMARY KEY (Day_Date),

);

CREATE TABLE Claims_Dimensional_Model (
Fact_ID int NOT NULL,
Claim_ID int NOT NULL,
Claim_Status_Code int NOT NULL,
Customer_ID int NOT NULL,
Date_Of_Claim DATE,
Date_Of_Statement DATE,
Employee_ID int NOT NULL,
Policy_ID int NOT NULL,
Reporting_Day_Date DATE,
Amount_Claimed NUMBER,
Amount_Paid NUMBER,
Total_Claims_Settlements int,
Other_Details VARCHAR2(255),
PRIMARY KEY (Fact_ID),
FOREIGN KEY (Claim_Status_Code)

REFERENCES Claims(Claim_Outcome_Code)

FOREIGN KEY (Claim_ID) REFERENCES Claims

(Claim_ID)

FOREIGN KEY (Customer_ID) REFERENCES

Custoomer(Customer_ID)
FOREIGN KEY (Date_Of_Claim) REFERENCES

Claims(Date_Of_Claim)
FOREIGN KEY (Date_Of_Statement) REFERENCES

Claims(Date_Of_Statement)
FOREIGN KEY (Employee_ID) REFERENCES

Employees(Employee_ID)
FOREIGN KEY (Policy_ID) REFERENCES Policies

(Policy_ID)
FOREIGN KEY (Reporting_Day_Date) REFERENCES

Calendar(Day_Date)

);

CREATE TABLE Employees (
  
Employee_ID int NOT NULL,
Employee_Details VARCHAR2(255),
PRIMARY KEY (Employee_ID),

);

CREATE TABLE Policies (
  
Policy_ID int NOT NULL,
Policy_Type_Cose int NOT NULL,
Start_Date DATE,
End_Date DATE,
Other Details VARCHAR2(255),
PRIMARY KEY (Policy_ID),

);

CREATE TABLE Ref_Claim_Staus(
  
Claim_Status_Code int NOT NULL,
  
Claim_Status_DescriptionDay_DateAR2(255)
PRIMARY KEY (Claim_Status_Code),

);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.