· 9 years ago · Oct 19, 2016, 04:30 AM
1-- Empresa : FastFood Restaurant
2-- Producto : Servicio de Comida Rápida
3-- Software : Sistema de Atención al Público (SAP)
4-- DBMS : SQL Server
5-- Base de Datos : FastFood
6-- Script : Crea los objetos de la base de datos
7
8
9
10
11-- =============================================
12-- Creación de la Base de Datos
13-- =============================================
14
15USE MASTER;
16go
17
18IF( EXISTS ( SELECT name FROM master.sys.databases WHERE name = 'FASTFOOD' ) )
19BEGIN
20 DROP DATABASE FASTFOOD;
21END;
22go
23
24CREATE DATABASE FASTFOOD;
25go
26
27
28-- =============================================
29-- Seleccionar la Base de Datos
30-- =============================================
31
32USE FASTFOOD;
33go
34
35-- Si las tablas existen, hay que eliminarlas
36---------------------------------------------
37
38IF EXISTS ( SELECT name FROM sysobjects
39 WHERE type = 'U' AND name = 'Promocion' )
40 DROP TABLE Promocion
41go
42
43IF EXISTS ( SELECT name FROM sysobjects
44 WHERE type = 'U' AND name = 'Parametro' )
45 DROP TABLE Parametro
46go
47
48IF EXISTS ( SELECT name FROM sysobjects
49 WHERE type = 'U' AND name = 'DetallePedido' )
50 DROP TABLE DetallePedido
51go
52
53IF EXISTS ( SELECT name FROM sysobjects
54 WHERE type = 'U' AND name = 'Pedido' )
55 DROP TABLE Pedido
56go
57
58IF EXISTS ( SELECT name FROM sysobjects
59 WHERE type = 'U' AND name = 'Empleado' )
60 DROP TABLE Empleado
61go
62
63IF EXISTS ( SELECT name FROM sysobjects
64 WHERE type = 'U' AND name = 'Articulo' )
65 DROP TABLE Articulo
66go
67
68IF EXISTS ( SELECT name FROM sysobjects
69 WHERE type = 'U' AND name = 'Categoria' )
70 DROP TABLE Categoria
71go
72
73IF EXISTS ( SELECT name FROM sysobjects
74 WHERE type = 'U' AND name = 'Cliente' )
75 DROP TABLE Cliente
76go
77
78IF EXISTS ( SELECT name FROM sysobjects
79 WHERE type = 'U' AND name = 'Documento' )
80 DROP TABLE Documento
81go
82
83
84-- Creación de Tablas
85---------------------
86
87CREATE TABLE DetallePedido (
88 IdPedido int NOT NULL,
89 IdArticulo varchar(8) NOT NULL,
90 Cantidad int NOT NULL,
91 PreVenta money NOT NULL,
92 SubTotal money NOT NULL
93)
94go
95
96CREATE TABLE Pedido (
97 idPedido int NOT NULL,
98 IdDocumento int NOT NULL,
99 IdEmpleado char(6) NOT NULL,
100 NumDocumento varchar(15) NOT NULL,
101 Fecha datetime NOT NULL,
102 IdCliente char(6) NULL,
103 NomCliente varchar(35) NULL,
104 Monto money NOT NULL,
105 Descuento money NOT NULL,
106 IGV money NOT NULL,
107 Total money NOT NULL,
108 Delivery bit,
109 Estado smallint NOT NULL
110)
111go
112
113CREATE TABLE Cliente (
114 IdCliente char(6) NOT NULL,
115 NomCliente varchar(50) NOT NULL,
116 RUC char(11) NOT NULL,
117 DirCliente varchar(60) NOT NULL,
118 TelCliente char(8) NULL,
119 Clave varchar(10) NULL
120)
121go
122
123CREATE TABLE Documento (
124 IdDocumento int IDENTITY,
125 NomDocumento varchar(10) NULL,
126 Serie int NOT NULL,
127 ConDocumento int NOT NULL
128)
129go
130
131CREATE TABLE Articulo (
132 IdArticulo varchar(8) NOT NULL,
133 IdCategoria int NOT NULL,
134 NomArticulo varchar(35) NOT NULL,
135 PreArticulo money NOT NULL
136)
137go
138
139CREATE TABLE Categoria (
140 IdCategoria int IDENTITY,
141 NomCategoria varchar(25) NOT NULL,
142 Prefijo char(3) NOT NULL,
143 ConCategoria int NOT NULL
144)
145go
146
147CREATE TABLE Empleado (
148 idEmpleado char(6) NOT NULL,
149 ApeEmpleado varchar(20) NOT NULL,
150 NomEmpleado varchar(20) NOT NULL,
151 DirEmpleado varchar(60) NULL,
152 TelEmpleado char(8) NULL,
153 Contraseña varchar(10) NOT NULL
154)
155go