|
Creación de la tabla de la base de datos
TABLA CUSTOMER_ZIP_T DE REATE (Zip_Code VARCHAR (9), Customer_City VARCHAR (25), Customer_State VARCHAR (2), LLAVE PRIMARIA del CONSTREÑIMIENTO CUSTOMER_ZIP_PK (Zip_Code));
CREE LA TABLA CUSTOMER_T (NÚMERO de Customer_Id NO NULO, Customer_Name VARCHAR (25), Customer_Email VARCHAR (40), FECHA DE DOB, Customer_Address VARCHAR (30), Zip_Code VARCHAR (9), LLAVE PRIMARIA del CONSTREÑIMIENTO CUSTOMER_PK (Customer_Id), REFERENCIAS EXTRANJERAS CUSTOMER_ZIP_T (Zip_Code) de la LLAVE del CONSTREÑIMIENTO CUSTOMER_FK (Zip_Code));
CREE LA TABLA ORDER_T (Order_ID VARCHAR (25) NO NULOS, FECHA de Order_Date, Número de Customer_ID, LLAVE PRIMARIA del CONSTREÑIMIENTO ORDER_PK (Order_ID), REFERENCIAS EXTRANJERAS CUSTOMER_T (Customer_ID) de la LLAVE del CONSTREÑIMIENTO ORDER_FK (Customer_ID));
CREE LA TABLA PRODUCT_T (Número de Bar_Code NO NULO, Número de Product_Quantity, VARCHAR Varietal (30), Product_name VARCHAR (30), Descripción VARCHAR (300), Número del precio, Número del alcohol, Denominación VARCHAR (50), Número de la vendimia, LLAVE PRIMARIA DEL CONSTREÑIMIENTO PRODUCT_PK (BAR_CODE));
CREE LA TABLA ORDER_LINE_T (Número de Order_Line_ID NO NULO, Número de Bar_Code, order_ID VARCHAR (25), número del order_quantity, LLAVE PRIMARIA DEL CONSTREÑIMIENTO ORDER_LINE_PK (ORDER_LINE_ID), REFERENCIAS EXTRANJERAS ORDER_t (Order_Id) de la LLAVE del CONSTREÑIMIENTO Order_line_FK1 (Order_Id), REFERENCIAS EXTRANJERAS PRODUCT_t (BAR_CODE) de la LLAVE del CONSTREÑIMIENTO Order_line_FK2 (BAR_CODE));
CREE LA TABLA PRODUCT_RATING_T (NÚMERO DE BAR_CODE NO NULO, NÚMERO DEL GRADO, LLAVE PRIMARIA DEL CONSTREÑIMIENTO PRODUCT_RATING_PK (BAR_CODE), REFERENCIAS EXTRANJERAS PRODUCT_T (BAR_CODE) DE LA LLAVE DEL CONSTREÑIMIENTO PRODUCT_RATING_FK (BAR_CODE));
CREE LA TABLA SUPPLIER_ZIP_T (Zip_Code VARCHAR (9), SUPPLIER_City VARCHAR (25), SUPPLIER_State VARCHAR (2), LLAVE PRIMARIA del CONSTREÑIMIENTO SUPPLIER_ZIP_PK (Zip_Code));
CREE LA TABLA SUPPLIER_T (Número de SUPPLIER_Id NO NULO, SUPPLIER_Name VARCHAR (25), SUPPLIER_Email VARCHAR (40), SUPPLIER_Address VARCHAR (30), Zip_Code VARCHAR (9), LLAVE PRIMARIA del CONSTREÑIMIENTO SUPPLIER_PK (SUPPLIER_Id), REFERENCIAS EXTRANJERAS SUPPLIER_ZIP_T (Zip_Code) de la LLAVE del CONSTREÑIMIENTO SUPPLIER_FK (Zip_Code));
CREE LA TABLA SHIPMENT_T (NÚMERO DE SHIPMENT_ID NO NULO, FECHA DE SHIPMENT_DATE, NÚMERO DE SUPPLIER_ID, LLAVE PRIMARIA DEL CONSTREÑIMIENTO SHIPMENT_PK (SHIPMENT_ID), REFERENCIAS EXTRANJERAS SUPPLIER_T (SUPPLIER_ID) DE LA LLAVE DEL CONSTREÑIMIENTO SHIPMENT_FK (SUPPLIER_ID));
CREE LA TABLA INCLUDES_T (NÚMERO DE BAR_CODE NO NULO, NÚMERO DE SHIPMENT_ID, LLAVE PRIMARIA DEL CONSTREÑIMIENTO INCLUDES_PK (BAR_CODE, SHIPMENT_ID), REFERENCIAS EXTRANJERAS PRODUCT_RATING_T (BAR_CODE) DE LA LLAVE DEL CONSTREÑIMIENTO INCLUDES_FK1 (BAR_CODE), REFERENCIAS EXTRANJERAS SHIPMENT_T (SHIPMENT_ID) DE LA LLAVE DEL CONSTREÑIMIENTO INCLUDES_FK2 (SHIPMENT_ID));
Inserción de los datos de la base de datos
RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (32601, “St. Paul”, “VA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (94574, “Hampton”, “NY”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (92115, “San Diego”, “CA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (26559, “Los Ángeles”, “CA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (46887, “Detroit”, “MI”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (33668, “Cleveland”, “OH”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (11254, “Sacramento”, “CA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (53421, “Washington”, “WA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (23445, “Fairfield”, “CA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (19854, “Maui”, “ha”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (56448, “Springfield”, “mA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (61237, “Boston”, “mA”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (62738, “ciudad natal”, “WI”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (92345, “Houston”, “TX”); RELLENO EN CUSTOMER_ZIP_T (Zip_Code, Customer_City, Customer_State) VALORES (23465, “Ashland”, “O”);
RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (1, “Greg ejerce la actividad bancaria”, “gbanks@spamail.com”, “12/OCT/1972”, “2078 St. del W. 17mo”, 32601); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (2, “pizarrero del Kelly”, “kslater@spamail.com”, “02/NOV/1948”, “4ta avenida 1955.”, 94574); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (3, “ciervos”, “jdeer@spamail.com”, “10/DEC/1939”, de “St.”, 92115 de Juan 2665 palomas); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (4, “Mohammad Oskoorouchi”, “moskoorouchi@spamail.com”, “03/SEPT/1954”, “1514 St. de Castelar”, 26559); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (5, “Monique Johnson”, “mjohnson@spamail.com”, “07/FEBRERO/1978”, “EL 2054 Cajon Blvd.”, 46887); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (6, “Kimihiko Nakamura”, “knakamura@spamail.com”, “05/MAYO/1974”, de “avenida 188 universidades.”, 33668); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code)
VALORES (7, “Mason Dixon”, “mdixon@spamail.com”, “03/OCT/1767”, de “avenida 6542 cazas.”, 11254);
RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (8, “Fred Cummings”, “fcummings@spamail.com”, “10/FEBRERO/1981”, “avenida 1955 de Allyn.”, 53421); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (9, “sol”, “ysun@spamail.com”, “14/AGOSTO/1962” de Yi, “1744 St. de Jason”, 23445); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (10, “Ernest Wendt”, “ewendt@spamail.com”, “03/SEPT/1958”, de “St.”, 19854 85 resortes); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (11, “Shaoyi él”, “she@spamail.com”, “19/ENERO/1962”, “85 Hwy del este.”, 56448); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (12, “Guillermo se quema”, “wburns@spamail.com”, “17/JULIO/1955”, de “St.”, 61237 2233 espacios); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (13, “Leu de Gato”, “jleu@spamail.com”, “28/JUNIO/1960”, “4652 masón Blvd.”, 62738); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (14, “Jim Hamerly”, “jhamerly@spamail.com”, “29/MARCHA/1959”, “2386 primer St.”, 92345); RELLENO EN CUSTOMER_t (Customer_Id, Customer_Name, Customer_Email, DOB, Customer_Address, Zip_Code) VALORES (15, “Roberto Aboolian”, “raboolian@spamail.com”, “01/ABRIL/1955”, “segundo avenida 6687.”, 23465);
RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1001, “21/AGOSTO/2004”, 1); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1002, “16/SEPT/2004”, 8); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1003, “20/SEPT/04”, 15); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1004, “04/oct/04”, 5); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1005, “10/oct/04”, 3); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1006, “13/oct/04”, 2); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1007, “25/oct/04”, 11); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1008, “30/oct/04”, 12); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1009, “03/nov/04”, 4); RELLENO EN ORDER_t (Order_Id, Order_Date, Customer_Id) VALORES (1010, “06/nov/04”, 9);
RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (12113, 48, “Merlot”, “Merlot de los viñedos de la dinamita”, “sabores explosivos de la fruta y aromas intrigantes de ciruelos, cerezas negras y especia.”, 15.99, 13.5, “California”, 2001); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (23445, 24, “Sangiovese”, “Louis Martini Sangiovese 1999”, “nariz madura, dulce, plummy que mezcla con la especia varietal y un ramo del roble de maderas europeas del este. Fruta profunda de la fresa/de la frambuesa con los bordes de la fruta cítrica y del anacardo.”, 14.99, 13.5, “California”, 1999); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (36748, 48, “pinot negro”, “pinot negro de Beckstoffer del acacia”, “obscuridad, rojo sano. Aromas de Superripe de la cereza, de flores y de la cola amargas, con una sugerencia del filete envejecido.”, 18.99, 12.5, “Carneros, California”, 2002); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (46247, 48, “Chardonnay”, “Amberhill Chardonnay 2002”, “sabores maravillosos de la fruta del melocotón, pera, y manzana. Balanceado por acidez quebradiza y el roble suave en el final.”, 8.99, 13.3, “California”, 2002); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (53125, 12, “Cabernet-Sauvignon”, el “valle de Alexander Cabernet 2002”, “oscuro y rico, esto es una botella que entrega.”, 13.99, 13.4, “California”, 2002); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (66498, 96, “Rosso”, “Coppola Rosso 2002”, “de lujo y con sabor a fruta, oh un qué gran vino es.”, 7.99, 11.2, “California”, 2002); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) VALORES (71347, 24, “Sauvignon Blanc”, “Kenwood 2002 Sauvignon Blanc”, “brillante y vibrante, fresco y patata a la inglesa, sabores tropicales de jactancia de la fruta, de la pera y de la fruta cítrica.”, 7.99, 13.1, “valle”, 2002 de Napa); RELLENO EN PRODUCT_t (Bar_Code, Product_Quantity, Varietal, Product_name, descripción, precio, alcohol, denominación, vendimia) ¡VALORES (83225, 12, “Zinfandel”, “Buehler Zinfandel 2001 Napa”, “Zincredible! Esto mediados de al zin full-bodied tiene un poco de especia agradable a él y se apareará bien con los alimentos asados a la parilla.”, 9.59, 13.8, “Napa”, 2001);
RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (001, 12113, “1001”, 2); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (002, 23445, “1001”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (003, 36748, “1002”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (004, 12113, “1003”, 3); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (005, 46247, “1004”, 6); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (006, 12113, “1004”, 2); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (007, 23445, “1004”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (008, 46247, “1005”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (009, 83225, “1006”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (010, 83225, “1007”, 4); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (011, 12113, “1007”, 6); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (012, 12113, “1007”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (013, 46247, “1008”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (014, 23445, “1008”, 2); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (015, 71347, “1009”, 3); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (016, 36748, “1009”, 3); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (017, 53125, “1010”, 1); RELLENO EN Order_line_t (Order_Line_ID, Bar_Code, Order_ID, Order_Quantity) VALORES (018, 71347, “1010”, 2);
RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (12113, 3); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (23445, 5); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (36748, 3); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (46247, 5); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (53125, 4); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (66498, 4); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (71347, 5); RELLENO EN PRODUCT_RATING_t (Bar_Code, clasificando) VALORES (83225, 5); RELLENO EN SUPPLIER_ZIP_t (Zip_Code, Supplier_City, Supplier_State) VALORES (“91111”, “ciudad nacional”, “CA”); RELLENO EN SUPPLIER_ZIP_t (Zip_Code, Supplier_City, Supplier_State) VALORES (“91911”, “Chula Vista”, “CA”); RELLENO EN SUPPLIER_ZIP_t (Zip_Code, Supplier_City, Supplier_State) VALORES (“92107”, “EL Cajon”, “CA”); RELLENO EN SUPPLIER_ZIP_t (Zip_Code, Supplier_City, Supplier_State) VALORES (“99210”, “San Diego”, “CA”); RELLENO EN SUPPLIER_ZIP_t (Zip_Code, Supplier_City, Supplier_State) VALORES (“99213”, “San Diego”, “CA”);
RELLENO EN SUPPLIER_t (Supplier_ID, Supplier_Name, Supplier_Email, Supplier_Address, Zip_Code) VALORES (1, “Steve Wentzel”, “steve@hotmail.com”, “St.”, 99213 de 3375 Naple); RELLENO EN SUPPLIER_t (Supplier_ID, Supplier_Name, Supplier_Email, Supplier_Address, Zip_Code) VALORES (2, “madejas”, “jh@hotmail.com”, “1125 St. de la palma”, 99210 de Jeff); RELLENO EN SUPPLIER_t (Supplier_ID, Supplier_Name, Supplier_Email, Supplier_Address, Zip_Code) VALORES (3, “Mike Metroyanis”, “mike@yahoo.com”, “556 L St.”, 92107); RELLENO EN SUPPLIER_t (Supplier_ID, Supplier_Name, Supplier_Email, Supplier_Address, Zip_Code) VALORES (4, “Wilman ejerce la actividad bancaria”, “wilman@gmail.com”, el “Dr.”, 91911 de 25116 Fletcher); RELLENO EN SUPPLIER_t (Supplier_ID, Supplier_Name, Supplier_Email, Supplier_Address, Zip_Code) VALORES (5, “Peter Chestfield”, “Peter@hotmail.com”, “4213 Broadway”, 91111);
RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (01, “05/AGOSTO/2004”, 3); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (02, “26/AGOSTO/2004”, 1); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (03, “01/SEPT/2004”, 5); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (04, “15/SEPT/2004”, 2); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (05, “20/sept/2004”, 1); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (06, “08/OCT/2004”, 4); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (07, “11/OCT/2004”, 5); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (08, “12/OCT/2004”, 2); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (09, “08/NOV/2004”, 1); RELLENO EN SHIPMENT_t (Shipment_ID, Shipment_Date, Supplier_ID) VALORES (10, “30/NOV/2004”, 3);
RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (12113, 01); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (12113, 04); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (23445, 10); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (36748, 09); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (46247, 08); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (53125, 05); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (66498, 02); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (71347, 07); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (83225, 03); RELLENO EN INCLUDES_t (Bar_Code, Shipment_ID) VALORES (83225, 06);
< siguiente anterior >
Relacionado
[ Software del carro de compras de Ecommerce ] [ Tecnología casera elegante ] [ Salto y Powertouch ] [ Creación de radio del Internet ] [ Presión - basura sensible de la etiqueta ]
Asuntos
[ Negocio del Tech ] [ ingeniería de computadora ] [ ingeniería eléctrica ] [ asuntos seleccionados ]
|
|