jaykob
یک شنبه 29 خرداد 1390, 17:09 عصر
سلام دوستان
من یک دیتابیس با یکسری خانه ها و جداول دارم که از نظر ارتباطی می خوام ببینم به چه شکل بهتره که ارتباط داشته باشند با توجه به column ها که در اجرا کوئری ها مناسب باشه من اطلاعات زیادی در این رابطه ندارم ممنون می شم بررسی کنید و ارتباطات رو اعمال کنید و بفرمایید با تشکر
USE [course]
GO
/****** Object: Table [dbo].[SISTER] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SISTER](
[id#1] [smallint] NOT NULL,
[id#2] [smallint] NOT NULL,
[Father] [smallint] NOT NULL,
[Mother] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[PARENTS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PARENTS](
[Relation] [char](10) NOT NULL,
[id#1] [nchar](10) NOT NULL,
[id#2] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[NAMES] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NAMES](
[id#] [smallint] NOT NULL,
[Name] [char](30) NOT NULL,
[Family] [char](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ME] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ME](
[Add#] [smallint] NOT NULL,
[id#] [smallint] NOT NULL,
[Name] [char](30) NOT NULL,
[Family] [char](50) NOT NULL,
[City] [char](30) NULL,
[Relation] [char](10) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Dead] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dead](
[id#] [smallint] NOT NULL,
[Year] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BROTHERS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BROTHERS](
[id#1] [smallint] NOT NULL,
[id#2] [smallint] NOT NULL,
[Father] [smallint] NOT NULL,
[Mother] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BIRTHDATE] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BIRTHDATE](
[id#1] [smallint] NOT NULL,
[Year] [smallint] NOT NULL,
[Month] [char](10) NOT NULL,
[Day] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ADDRESS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ADDRESS](
[Add#] [smallint] NOT NULL,
[Country] [char](30) NOT NULL,
[City] [char](30) NULL,
[Address] [char](200) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
من یک دیتابیس با یکسری خانه ها و جداول دارم که از نظر ارتباطی می خوام ببینم به چه شکل بهتره که ارتباط داشته باشند با توجه به column ها که در اجرا کوئری ها مناسب باشه من اطلاعات زیادی در این رابطه ندارم ممنون می شم بررسی کنید و ارتباطات رو اعمال کنید و بفرمایید با تشکر
USE [course]
GO
/****** Object: Table [dbo].[SISTER] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SISTER](
[id#1] [smallint] NOT NULL,
[id#2] [smallint] NOT NULL,
[Father] [smallint] NOT NULL,
[Mother] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[PARENTS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PARENTS](
[Relation] [char](10) NOT NULL,
[id#1] [nchar](10) NOT NULL,
[id#2] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[NAMES] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NAMES](
[id#] [smallint] NOT NULL,
[Name] [char](30) NOT NULL,
[Family] [char](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ME] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ME](
[Add#] [smallint] NOT NULL,
[id#] [smallint] NOT NULL,
[Name] [char](30) NOT NULL,
[Family] [char](50) NOT NULL,
[City] [char](30) NULL,
[Relation] [char](10) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Dead] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dead](
[id#] [smallint] NOT NULL,
[Year] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BROTHERS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BROTHERS](
[id#1] [smallint] NOT NULL,
[id#2] [smallint] NOT NULL,
[Father] [smallint] NOT NULL,
[Mother] [smallint] NOT NULL,
[Add#] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BIRTHDATE] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BIRTHDATE](
[id#1] [smallint] NOT NULL,
[Year] [smallint] NOT NULL,
[Month] [char](10) NOT NULL,
[Day] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ADDRESS] Script Date: 06/19/2011 16:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ADDRESS](
[Add#] [smallint] NOT NULL,
[Country] [char](30) NOT NULL,
[City] [char](30) NULL,
[Address] [char](200) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO