Question: Create ER diagram for the following tables CREATE TABLE [dbo].[member.tbl]( [member_ID] [nchar](100) primary key NOT NULL, [FirstName] [nvarchar](50) NULL, [LastName] [nchar](100) NULL, [DOB] [numeric](18, 0)

Create ER diagram for the following tables

CREATE TABLE [dbo].[member.tbl]( [member_ID] [nchar](100) primary key NOT NULL, [FirstName] [nvarchar](50) NULL, [LastName] [nchar](100) NULL, [DOB] [numeric](18, 0) NULL, [Address] [nchar](100) NULL, [Gender] [nvarchar](50) NULL, [contact_Number] [numeric](18, 0) NULL, [status] [nvarchar](max) NULL, [Physcician_Name] [nchar](100) NULL, [Policy_Name] [nvarchar](100) NULL,

) //claim

CREATE TABLE [dbo].[claim]( [claim_ID] [int] NULL, [member_ID] [int] NULL, [case_Type] [nvarchar](100) NULL, [claim_case_status] [varchar](100) NULL, [case_Intitiated_Date] [varchar](50) NULL, [update_date] [nchar](100) NULL ) ON [PRIMARY] GO //policy CREATE TABLE [dbo].[policy]( [policy_Id] [int] primary key NOT NULL, [policy_number] [int] NULL, [policy_effective_date] [date] NULL, [policy_Expiry_date] [date] NULL, [paymnt_option] [varchar](100) NULL, [Total_Amount] [int] NULL, [Active] [varchar](100) NULL, [Created_date] [date] NULL,

) //provider

CREATE TABLE [dbo].[provider]( [provider_Id] [int] NOT NULL primary key , [provider_name] [nvarchar](100) NULL, [speciality] [varchar](100) NULL, [sub_speciality] [nvarchar](100) NULL, [Important_to_Know] [varchar](100) NULL, ) //case

CREATE TABLE [dbo].[case]( [case_ID] [int] NOT NULL primary key, [case_name] [varchar](100) NULL, [description] [varchar](100) NULL, [case_initiated_date] [date] NULL, [updated_date] [date] NULL, )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!