MODELO
ENTIDAD-RELACION
MODELO
RELACIONAL
Proveedor
|
|||||||
nombre
|
código
|
f_pedido
|
f_entrega
|
No_producto
|
gastos
|
Tip producto
|
#
producto
|
Nike
|
12345
|
1/05/12
|
1/06/12
|
Mercurial
|
$2000
|
Tenis
|
300
|
Abercrombie & fitch
|
54321
|
2/05/12
|
2/06/12
|
A&F
|
$1000
|
Camisa
|
200
|
Adidas Original
|
67890
|
3/05/12
|
3/06/12
|
AdiColors
|
$4000
|
Tenis
|
500
|
Hollister Co
|
09876
|
4/05/12
|
4/06/12
|
Hollister
|
$2000
|
Playera
|
150
|
Converse all Star
|
36240
|
5/05/12
|
5/06/12
|
Converse
|
$1000
|
Bota
|
100
|
Producto
|
|||||||
nombre
|
N producto
|
color
|
$ compra
|
$ venta
|
Talla núm
|
código
|
tela
|
Mercurial
|
300
|
Morado
|
$800
|
$900
|
10-28
|
78910
|
Latex
|
A&F
|
200
|
Azul
|
$400
|
$500
|
CH-G
|
01987
|
Poliéster
|
AdiColors
|
500
|
Blanco
|
$300
|
$400
|
12-29
|
24681
|
Polímero
|
Hollister
|
150
|
Rosa
|
$200
|
$300
|
CH-M
|
18642
|
Algodón
|
Converse
|
100
|
negro
|
$400
|
$500
|
20-25
|
11115
|
Latex
|
Empleado
|
|||||||
nombre
|
domicilio
|
salario
|
comisión
|
H trabajadas
|
edad
|
A laborados
|
DNI
|
Hugo
|
Naucalpan
|
$1000
|
$200
|
10
|
18
|
5
|
11112
|
Fernanda
|
Tlalnepantla
|
$1500
|
$250
|
8
|
17
|
4
|
22223
|
Ángel
|
Barrientos
|
$1000
|
$200
|
10
|
17
|
3
|
33334
|
Mayra
|
Atizapán
|
$1500
|
$250
|
9
|
17
|
4
|
44445
|
Efrén
|
Naucalpan
|
$500
|
$100
|
12
|
20
|
2
|
55556
|
Enter
password: ***
Welcome to
the MySQL monitor. Commands end with ;
or \g.
Your MySQL
connection id is 4
Server
version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type
'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use tienda_deportiva;
Database changed
mysql> create table tienda_deportiva(nombre
varchar(20), codigo integer, fecha_p
edido date, fecha date, nombre_producto
varchar(30), gastor integer, tipo_produc
to
varchar(30), productos integer);
Query OK, 0
rows affected (0.04 sec)
mysql>
insert into tienda_deportiva values('nike',1234,'13/05/2012','01/06/2012'
,'mercurial',2000,'tenis',300);
Query OK, 1
row affected, 2 warnings (0.02 sec)
mysql>
insert into tienda_deportiva values('abercombi',54321,'14/05/2012','02/06
/2012','abercombe',1000,'camisa',200);
Query OK, 1
row affected, 2 warnings (0.00 sec)
mysql>
insert into tienda_deportiva values('adidas',67890,'15/05/2012','03/06/20
12','adicolor',4000,'tenis',500);
Query OK, 1
row affected, 2 warnings (0.00 sec)
mysql>
insert into tienda_deportiva values('holister',09876,'16/05/2012','04/06/
2012','holister',2000,'playera',150);
Query OK, 1
row affected, 2 warnings (0.00 sec)
mysql>
insert into tienda_deportiva values('comverce',36240,'17/05/2012','05/06/
2012','converce',1000,'bota',100);
Query OK, 1
row affected, 2 warnings (0.00 sec)
mysql> create table producto(nombre
varchar(20),num_producto integer, color varc
har(30), precio_compra integer,precio_venta
integer,talla_num integer, codigo in
teger, tela
varchar(30));
Query OK, 0
rows affected (0.06 sec)
mysql>
insert into producto values('mercurial',300,'morado',800,900,28,78910,'la
tex');
Query OK, 1
row affected (0.00 sec)
mysql>
insert into producto values('abercombi',200,'azul',400,500,12,01987,'poli
ester');
Query OK, 1
row affected (0.00 sec)
mysql>
insert into producto values('adicolor',500,'blanco',500,400,14,24681,'pol
imero');
Query OK, 1
row affected (0.00 sec)
mysql>
insert into producto values('holister',150,'rosa',200,400,16,18642,'algod
on');
Query OK, 1
row affected (0.00 sec)
mysql>
insert into producto values('converce',100,'negro',400,500,22,11115,'late
x');
Query OK, 1
row affected (0.00 sec)
mysql> create table empleado(nombre
varchar(30), domicilio varchar(30), salario
integer, comision integer, horas_trabajadas integer,
edad integer,anos_laborados
integer, dni integer);
Query OK, 0
rows affected (0.08 sec)
mysql>
Insert into empleado values('Hugo','Naucalpan',1000,200,10,18,5,11112);
Query OK, 1
row affected (0.00 sec)
mysql>
Insert into empleado values('Fernanda','Tlalnepantla',1500,250,8,17,4,222
23);
Query OK, 1
row affected (0.00 sec)
mysql>
Insert into empleado values('Angel','Barrientos',1000,200,10,17,3,33334);
Query OK, 1
row affected (0.00 sec)
mysql>
Insert into empleado values('Mayra','Atizapan',1500,250,9,17,4,44445);
Query OK, 1
row affected (0.00 sec)
mysql>
Insert into empleado values('Efren','Naucalpan',500,100,12,20,2,55556);
Query OK, 1
row affected (0.00 sec)
mysql>
select*from produto where nombre='nike';
ERROR 1146
(42S02): Table 'tienda_deportiva.produto' doesn't exist
mysql>
select*from tienda deportiva where nombre='nike';_
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
| nombre | codigo | fecha_pedido | fecha | nombre_producto | gastor | tipo_
producto | productos |
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
| nike
| 1234 | 0000-00-00 | 0000-00-00 | mercurial |
2000 | tenis
| 300 |
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
1 row in
set (0.50 sec)
mysql>
provedor
where precio>300' at line 1
mysql>
select*from producto where nombre like'a%';
+-----------+--------------+--------+---------------+--------------+-----------
--------+-----------+
| nombre
| num_producto | color |
precio_compra | precio_venta | talla_num
codigo
| tela |
+-----------+--------------+--------+---------------+--------------+-----------
--------+-----------+
| abercombi | 200 | azul |
400 | 500 | 12
1987
| poliester |
| adicolor
| 500 | blanco | 500 | 400 | 14
24681
| polimero |
+-----------+--------------+--------+---------------+--------------+-----------
--------+-----------+
2 rows in set (0.06 sec)
mysql>
--------+-----------+
2 rows in set (0.06 sec)
mysql> select*from producto;
+-----------+--------------+--------+---------------+--------------+-----------+
--------+-----------+
| nombre | num_producto |
color | precio_compra | precio_venta |
talla_num |
codigo | tela |
+-----------+--------------+--------+---------------+--------------+-----------+
--------+-----------+
| mercurial | 300 | morado
| 800 | 900 | 28 |
78910 | latex |
| abercombi | 200 |
azul | 400 | 500 | 12 |
1987 | poliester |
| adicolor | 500 | blanco | 500 | 400 | 14 |
24681 | polimero |
| holister | 150 | rosa |
200 | 400 | 16 |
18642 | algodon |
| converce | 100 | negro |
400 | 500 | 22 |
11115
| latex |
+-----------+--------------+--------+---------------+--------------+-----------+
--------+-----------+
5 rows in set (0.00 sec)
--------+-----------+
2 rows in
set (0.06 sec)
mysql>
select*from empleado;
+----------+--------------+---------+----------+------------------+------+------
----------+-------+
| nombre
| domicilio | salario |
comision | horas_trabajadas | edad | anos_
laborados | dni |
+----------+--------------+---------+----------+------------------+------+------
----------+-------+
| Hugo
| Naucalpan | 1000 |
200 | 10 | 18 |
5 | 11112 |
| Fernanda | Tlalnepantla | 1500 |
250 | 8 | 17 |
4 | 22223 |
| Angel
| Barrientos | 1000 |
200 | 10 | 17 |
3 | 33334 |
| Angel
| Barrientos | 1000 |
200 | 10 | 17 |
3 | 33334 |
| Mayra
| Atizapan | 1500 |
250 | 9 | 17 |
4 | 44445 |
|
Efren | Naucalpan |
500 | 100 | 12 | 20 |
2 | 55556 |
+----------+--------------+---------+----------+------------------+------+------
----------+-------+
6 rows in
set (0.00 sec)
mysql> select*from tienda_deportiva where
nombre='adidas';
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
| nombre | codigo | fecha_pedido | fecha | nombre_producto | gastor | tipo_
producto | productos |
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
| adidas |
67890 | 0000-00-00 | 0000-00-00
| adicolor | 4000 | tenis
| 500 |
+--------+--------+--------------+------------+-----------------+--------+------
---------+-----------+
1 row in
set (0.00 sec)
ahhh bueno
ResponderEliminar