Veri Tabanı Yönetimi Hakkında Bir Soru

USE [emre]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aile](
    [kisino] [varcahar](50) NOT NULL,
    [ana_adı] [varcahar](50) NULL,
    [baba_adı] [varcahar](50) NULL,
 CONSTRAINT [PK_aile] PRIMARY KEY CLUSTERED
(
    [kisino] 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_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[es](
    [kisino] [varcahar](50) NOT NULL,
    [ad] [varcahar](50) NULL,
    [soyad] [varcahar](50) NULL,
    [dogumtaihi] [varcahar](50) NULL,
 CONSTRAINT [PK_es] PRIMARY KEY CLUSTERED
(
    [kisino] 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_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[kişiler](
    [kisino] [varcahar](50) NOT NULL,
    [ad] [varcahar](50) NULL,
    [soyad] [varcahar](50) NULL,
    [dogumtarihi] [varcahar](50) NULL,
 CONSTRAINT [PK_kişiler] PRIMARY KEY CLUSTERED
(
    [kisino] 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
ALTER TABLE [dbo].[es]  WITH CHECK ADD  CONSTRAINT [FK_es_kişiler] FOREIGN KEY([kisino])
REFERENCES [dbo].[kişiler] ([kisino])
GO
ALTER TABLE [dbo].[es] CHECK CONSTRAINT [FK_es_kişiler]
GO
ALTER TABLE [dbo].[kişiler]  WITH CHECK ADD  CONSTRAINT [FK_kişiler_aile] FOREIGN KEY([kisino])
REFERENCES [dbo].[aile] ([kisino])
GO
ALTER TABLE [dbo].[kişiler] CHECK CONSTRAINT [FK_kişiler_aile]
GO