CRar base de datos

create database tienda;
show databases;
use tienda;
create table fabricantes (Clave_fabricante int not null,
Nombre varchar(30),
Primary key(clave_fabricante));
Create table articulos(clave_fabricante int not null,
clave_articulo int not null,
nombre varchar (30),
precio int, primary key (clave_articulo),
index (clave_fabricante),
foreign key (clave_fabricante) referencesfabricantes (clave_fabricante))
ENGINE=innoDB;
show tables;
describe articulos;
insert into fabricantes values(1,'kingston');
insert into fabricantes values(2,'adata');
insert into fabricantesvalues(3,'logitech');
insert into fabricantes values(4,'lexar');
insert into fabricantes values(5,'seagate');
insert into articulos values(1,3,'teclado',100);
insert into articulos values(2,5,'Discoduro 300 Gb',500);
insert into articulos values(3,3,'Mouse',80);
insert into articulos values(4,4,'Memoria usb',140);
insert into articulos values(5,1,'Memoria ram',290);
insert into articulosvalues(6,5,'Disco duro extraible 250 Gb',650);
insert into articulos values(7,1,'Memoria USB',279);
insert into articulos values(8,2,'DVD Rom',450);
insert into articulos values(9,2,'CD ROM',200);insert into articulos values(10,3,'Targeta de red',180,);
select*from articulos;
SELECT Nombre FROM ARTICULOS;
SELECT Nombre,Precio FROM ARTICULOS;
SELECT DISTINCT Nombre FROM ARTICULOS;
SELECT* FROM ARTICULOS WHERE Clave_articulo=5;
SELECT * FROM ARTICULOS WHERE Nombre='Teclado';
SELECT * FROM ARTICULOS WHERE Nombre='Memoria ram' OR Nombre='Memoria usb';
SELECT * FROM ARTICULOS WHERENombre LIKE 'M%';
SELECT Nombre FROM ARTICULOS WHERE Precio=100;
SELECT Nombre FROM ARTICULOS WHERE Precio>200;
/*OPERADOR AND*/
SELECT * FROM ARTICULOS WHERE Precio>=100 AND Precio=250 ORDER BYPrecio DESC, Nombre;
SELECT * FROM ARTICULOS, FABRICANTES WHERE ARTICULOS.Clave_fabricantes=FABRICANTES.Clave_fabricantes;
SELECT ARTICULOS.Clave_articulo,ARTICULOS.Nombre,FABRICANTES.Nombre FROM...