Materia: Base de dato 1
Facilitador: Anthony Ovalles
Estudiante: Emanuel De la Cruz
Matrícula: 1-19-9808.
Fecha: 31-3-2025.
Gaspar Hernández, Espaillat. República Dominicana.
BASE DATOS PROYECTO FINAL
MOTOREPUESTOS YAEL
USE [DBProyecto]
GO
ALTER TABLE [dbo].[empleado] DROP CONSTRAINT
[DF__empleado__FechaR__7BE56230]
GO
/****** Object: Table [dbo].[empleado] Script Date: 31/03/2025 13:02:23 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[empleado]') AND type in (N'U'))
DROP TABLE [dbo].[empleado]
GO
/****** Object: Table [dbo].[empleado] Script Date: 31/03/2025 13:02:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[empleado](
[EmpleadoID] [int] IDENTITY(1,1) NOT NULL,
[Nombre] [varchar](25) NOT NULL,
[Apellido] [varchar](25) NOT NULL,
[Cedula] [varchar](11) NOT NULL,
[NumeroTelefono] [varchar](15) NOT NULL,
[CodigoEmpleado] [varchar](10) NOT NULL,
[Direccion] [varchar](25) NOT NULL,
[Email] [varchar](50) NOT NULL,
[FechaRegistro] [datetime] NOT NULL,
[Estado] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[EmpleadoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[CodigoEmpleado] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[empleado] ADD DEFAULT (getdate()) FOR [FechaRegistro]
GO
CREATE TABLE [dbo].[producto](
[ProductoID] [int] IDENTITY(1,1) NOT NULL,
[Nombre] [varchar](25) NOT NULL,
[Marca] [varchar](25) NOT NULL,
[Cantidad] [float] NOT NULL,
[PrecioVenta] [float] NOT NULL,
[PrecioDescuento] [float] NOT NULL,
[PrecioCosto] [float] NOT NULL,
[CodigoProducto] [varchar](10) NOT NULL,
[Estado] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ProductoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[CodigoProducto] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[suplidor](
[SuplidorID] [int] IDENTITY(1,1) NOT NULL,
[NombreSuplidor] [varchar](25) NOT NULL,
[Vendedor] [varchar](25) NOT NULL,
[RNC] [varchar](15) NOT NULL,
[Telefono] [varchar](15) NULL,
[Codigo] [varchar](15) NOT NULL,
[Direccion] [varchar](25) NOT NULL,
[Estado] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[SuplidorID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
[RNC] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[venta](
[VentaID] [int] IDENTITY(1,1) NOT NULL,
[Codigo] [varchar](10) NOT NULL,
[TipoVenta] [varchar](25) NOT NULL,
[Fecha] [datetime] NOT NULL,
[TotalItebis] [float] NOT NULL,
[TotalDescuento] [float] NULL,
[TotalVenta] [float] NOT NULL,
[IdEmpleado] [int] NOT NULL,
[IdCliente] [int] NOT NULL,
CONSTRAINT [PK__venta__5B41514C827717B5] PRIMARY KEY CLUSTERED
(
[VentaID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UQ__venta__06370DAC2B835C30] UNIQUE NONCLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[venta] ADD CONSTRAINT [DF__venta__Fecha__4EDDB18F]
DEFAULT (getdate()) FOR [Fecha]
GO
CREATE TABLE [dbo].[ventadetalle](
[VentaDetalleID] [int] IDENTITY(1,1) NOT NULL,
[IdVenta] [int] NOT NULL,
[IdProducto] [int] NOT NULL,
[Cantidad] [float] NOT NULL,
[Precio] [float] NOT NULL,
[Itebis] [float] NOT NULL,
[Descuento] [float] NULL,
[SubTotal] [float] NOT NULL,
[Total] [float] NOT NULL,
PRIMARY KEY CLUSTERED
(
[VentaDetalleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
