base de datos

CREATE DATABASE FENIX
USE [fenix]
GO
/****** Object: Table [dbo].[clientes] Script Date: 06/13/2014 19:33:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[clientes](
[id_cliente] [char](10) NOT NULL,
[nombre] [varchar](50) NOT NULL,
[apellido] [varchar](50) NOT NULL,
[dui] [varchar](50) NOT NULL,
[dirrecion][varchar](50) NOT NULL,
[telefono] [varchar](50) NOT NULL,
CONSTRAINT [PK_clientess] PRIMARY KEY CLUSTERED
(
[id_cliente] 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].[Reparto] Script Date: 06/13/2014 19:33:20 ******/
SETANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Reparto](
[id_reparto] [char](10) NOT NULL,
[Autorprincipal] [varchar](50) NOT NULL,
[Autorsecundario] [varchar](50) NOT NULL,
[Participacionespecial] [varchar](50) NULL,
[Paisdefilmacion] [varchar](50) NOT NULL,
CONSTRAINT [PK_Reparto] PRIMARY KEY CLUSTERED
(
[id_reparto] 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].[empleados] Script Date: 06/13/2014 19:33:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[empleados](
[id_empleado] [char](10)NOT NULL,
[nombres] [varchar](50) NOT NULL,
[apellidos] [varchar](50) NOT NULL,
[direccion] [varchar](50) NOT NULL,
[telefono] [varchar](50) NOT NULL,
[dui] [varchar](50) NOT NULL,
CONSTRAINT [PK_empleados] PRIMARY KEY CLUSTERED
(
[id_empleado] 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].[detallepedido] Script Date: 06/13/2014 19:33:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[detallepedido](
[id_detallepedido] [char](10) NOT NULL,
[nombre] [varchar](50) NOT NULL,
[cantida] [money] NOT NULL,
[preciou] [money] NOT NULL,CONSTRAINT [PK_detallepedido] PRIMARY KEY CLUSTERED
(
[id_detallepedido] 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].[Peliculas] Script Date: 06/13/2014 19:33:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOSET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Peliculas](
[id_pelicula] [char](10) NOT NULL,
[id_reparto] [char](10) NOT NULL,
[Titulo] [varchar](50) NOT NULL,
[Director] [varchar](50) NOT NULL,
[Duracion] [varchar](50) NOT NULL,
[Año] [datetime2](7) NOT NULL,
[Formato] [varchar](50) NOT NULL,
[Precio] [money] NOT NULL,
[id_detallepedido] [char](10) NOT NULL,
CONSTRAINT[PK_Peliculas] PRIMARY KEY CLUSTERED
(
[id_pelicula] 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].[pedido] Script Date: 06/13/2014 19:33:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GOCREATE TABLE [dbo].[pedido](
[id_pedido] [char](10) NOT NULL,
[fecha] [date] NOT NULL,
[total] [money] NOT NULL,
[id_detallepedido] [char](10) NOT NULL,
CONSTRAINT [PK_pedido] PRIMARY KEY CLUSTERED
(
[id_pedido] 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...