hi @safeer,
You need to create table as i say,
First Table
CREATE TABLE [dbo].[Employees](
[employee_id] [int] NOT NULL,
[employee_name] [varchar](50) NOT NULL,
[employee_address] [varchar](100) NOT NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[employee_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Second
CREATE TABLE [dbo].[Experiences](
[experience_id] [int] NOT NULL,
[company] [varchar](50) NOT NULL,
[year_of_experience] [int] NOT NULL,
[employee_id] [int] NOT NULL,
CONSTRAINT [PK_Experiences] PRIMARY KEY CLUSTERED
(
[experience_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Experiences] WITH CHECK ADD CONSTRAINT [FK_Experiences_Employees] FOREIGN KEY([employee_id])
REFERENCES [dbo].[Employees] ([employee_id])
GO
ALTER TABLE [dbo].[Experiences] CHECK CONSTRAINT [FK_Experiences_Employees]
GO
Third
CREATE TABLE [dbo].[Qualifications](
[qualification_id] [int] NOT NULL,
[university] [varchar](50) NOT NULL,
[degree] [varchar](50) NOT NULL,
[end_date] [datetime] NOT NULL,
[employee_id] [int] NOT NULL,
CONSTRAINT [PK_Qualifications] PRIMARY KEY CLUSTERED
(
[qualification_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Qualifications] WITH CHECK ADD CONSTRAINT [FK_Qualifications_Employees] FOREIGN KEY([employee_id])
REFERENCES [dbo].[Employees] ([employee_id])
GO
ALTER TABLE [dbo].[Qualifications] CHECK CONSTRAINT [FK_Qualifications_Employees]
GO
Like this..
Warm Regards:-
