ممنونم،بفرمایید
USE [master]
GO
/****** Object: Database [Farsh] Script Date: 10/27/2014 20:21:41 ******/
CREATE DATABASE [Farsh] ON PRIMARY
( NAME = N'Farsh', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Farsh.mdf ' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Farsh_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Farsh_log .ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Farsh] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Farsh].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Farsh] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Farsh] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Farsh] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Farsh] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Farsh] SET ARITHABORT OFF
GO
ALTER DATABASE [Farsh] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Farsh] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Farsh] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Farsh] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Farsh] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Farsh] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Farsh] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Farsh] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Farsh] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Farsh] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Farsh] SET DISABLE_BROKER
GO
ALTER DATABASE [Farsh] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Farsh] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Farsh] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Farsh] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Farsh] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Farsh] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Farsh] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Farsh] SET READ_WRITE
GO
ALTER DATABASE [Farsh] SET RECOVERY FULL
GO
ALTER DATABASE [Farsh] SET MULTI_USER
GO
ALTER DATABASE [Farsh] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Farsh] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'Farsh', N'ON'
GO
USE [Farsh]
GO
/****** Object: Table [dbo].[factor] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[factor](
[f_ID] [int] NOT NULL,
[f_date] [date] NULL,
[karmozd] [int] NULL,
[t_type] [varchar](20) NULL,
CONSTRAINT [PK_factor] PRIMARY KEY CLUSTERED
(
[f_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
/****** Object: Table [dbo].[customer] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[customer](
[cu_code] [int] NOT NULL,
[cu_name] [varchar](20) NULL,
[cu_addr] [varchar](30) NULL,
CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED
(
[cu_code] 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
/****** Object: Table [dbo].[curpet] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[curpet](
[c_code] [int] NOT NULL,
[c_color] [varchar](20) NULL,
[c_price] [int] NULL,
[c_size] [int] NULL,
[c_model] [varchar](20) NULL,
CONSTRAINT [PK_curpet] PRIMARY KEY CLUSTERED
(
[c_code] 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
/****** Object: Table [dbo].[seller] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[seller](
[seller_code] [int] NOT NULL,
[seller_name] [varchar](20) NULL,
[seller_addr] [varchar](30) NULL,
CONSTRAINT [PK_seller] PRIMARY KEY CLUSTERED
(
[seller_code] 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
/****** Object: Table [dbo].[store] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[store](
[c_code] [int] NULL,
[c_num] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[sell] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sell](
[sell_ID] [int] NOT NULL,
[c_code] [int] NULL,
[cu_code] [int] NULL,
[f_ID] [int] NULL,
[sell_num] [int] NULL,
CONSTRAINT [PK_sell] PRIMARY KEY CLUSTERED
(
[sell_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
/****** Object: Table [dbo].[buy] Script Date: 10/27/2014 20:21:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[buy](
[buy_ID] [int] NOT NULL,
[f_ID] [int] NULL,
[c_code] [int] NULL,
[seller_code] [int] NULL,
[buy_num] [int] NULL,
CONSTRAINT [PK_buy] PRIMARY KEY CLUSTERED
(
[buy_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
/****** Object: ForeignKey [FK_store_curpet] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[store] WITH CHECK ADD CONSTRAINT [FK_store_curpet] FOREIGN KEY([c_code])
REFERENCES [dbo].[curpet] ([c_code])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[store] CHECK CONSTRAINT [FK_store_curpet]
GO
/****** Object: ForeignKey [FK_sell_curpet] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[sell] WITH CHECK ADD CONSTRAINT [FK_sell_curpet] FOREIGN KEY([c_code])
REFERENCES [dbo].[curpet] ([c_code])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[sell] CHECK CONSTRAINT [FK_sell_curpet]
GO
/****** Object: ForeignKey [FK_sell_customer] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[sell] WITH CHECK ADD CONSTRAINT [FK_sell_customer] FOREIGN KEY([cu_code])
REFERENCES [dbo].[customer] ([cu_code])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[sell] CHECK CONSTRAINT [FK_sell_customer]
GO
/****** Object: ForeignKey [FK_sell_factor] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[sell] WITH CHECK ADD CONSTRAINT [FK_sell_factor] FOREIGN KEY([f_ID])
REFERENCES [dbo].[factor] ([f_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[sell] CHECK CONSTRAINT [FK_sell_factor]
GO
/****** Object: ForeignKey [FK_buy_curpet] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[buy] WITH CHECK ADD CONSTRAINT [FK_buy_curpet] FOREIGN KEY([c_code])
REFERENCES [dbo].[curpet] ([c_code])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[buy] CHECK CONSTRAINT [FK_buy_curpet]
GO
/****** Object: ForeignKey [FK_buy_factor] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[buy] WITH CHECK ADD CONSTRAINT [FK_buy_factor] FOREIGN KEY([f_ID])
REFERENCES [dbo].[factor] ([f_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[buy] CHECK CONSTRAINT [FK_buy_factor]
GO
/****** Object: ForeignKey [FK_buy_seller] Script Date: 10/27/2014 20:21:43 ******/
ALTER TABLE [dbo].[buy] WITH CHECK ADD CONSTRAINT [FK_buy_seller] FOREIGN KEY([seller_code])
REFERENCES [dbo].[seller] ([seller_code])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[buy] CHECK CONSTRAINT [FK_buy_seller]
GO
--
insert into curpet values (1,'red',1000,6,'500s')
insert into curpet values (2,'green',2000,9,'600s')
insert into curpet values (3,'blue',3000,12,'700s')
--
insert into customer values (12,'ali','arak')
insert into customer values (13,'reza','arak')
insert into customer values (14,'hossein','arak')
--
insert into factor values (21,'12-1-2014',500,'cach')
insert into factor values (22,'12-2-2014',600,'peyment')
insert into factor values (23,'12-3-2014',700,'cach')
--
insert into seller values (31,'ahmad','arak')
insert into seller values (32,'nima','arak')
insert into seller values (33,'sina','arak')
--
insert into store values (1,100)
insert into store values (2,100)
insert into store values (3,100)
--
insert into sell values (41,1,12,21,10)
insert into sell values (42,2,13,22,20)
insert into sell values (43,3,14,23,30)
--
insert into buy values (51,21,1,31,61)
insert into buy values (52,22,2,32,62)
insert into buy values (53,23,3,33,63)