Base de datos de un reproductor de música.

create database ReproductorMusica

use ReproductorMusica

create table cancion(IdCancion int primary key,

cancion varchar(20) not null,

duracion varchar(10) not null,

IdGenero int not null,

IdAlbum int not null)

insert into cancion values(1,'La Malora','2:30',1,1)

insert into cancion values(2,'El Viejo','3:20',1,1)

insert into cancion values(3,'Nena','1:40',1,2)

insert into cancion values(4,'Fuera De Peligro','2:22',1,2)

insert into cancion values(5,'No se','3:30',1,3)

insert into cancion values(6,'El Borrachito','1:30',1,3)

insert into cancion values(7,'La Maria','2:20',1,4)

insert into cancion values(8,'Ni lo intentes','3:11',1,4)

insert into cancion values(9,'Solo con verte','2:12',1,5)

insert into cancion values(10,'Que bendicion','3:00',1,5)

insert into cancion values(11,'Dos Mujeres','1:00',1,6)

insert into cancion values(12,'Sigue','2:40',1,6)

insert into cancion values(13,'Big Jack','4:20',2,7)

insert into cancion values(14,'War Machine','3:30',2,7)

insert into cancion values(15,'Play Ball','5:00',2,8)

insert into cancion values(16,'Dogs of War','4:10',2,8)

insert into cancion values(17,'About A Girl','3:50',2,9)

insert into cancion values(18,'Lithium','2:12',2,9)

insert into cancion values(19,'Breed','1:40',2,10)

insert into cancion values(20,'School','2:44',2,10)

insert into cancion values(21,'Frantic','3:00',2,11)

insert into cancion values(22,'St Anger','2:05',2,11)

insert into cancion values(23,'Fuel','2:36',2,12)

insert into cancion values(24,'Master of Puppets','2:25',2,12)

insert into cancion values(25,'Quise Ser','3:15',3,13)

insert into cancion values(26,'10:00 PM','2:51',3,13)

create table artista(IdArtista int primary key,

NombreArtista varchar(15) not null,

IdPais int not null)

Insert into artista values(1,'Recodo',1)

Insert into artista values(2,'Julion',1)

Insert into artista values(3,'Banda MS',1)

Insert into artista values(4,'AC/DC',2)

Insert into artista values(5,'Nirvana',2)

Insert into artista values(6,'Metallica',2)

Insert into artista values(7,'Neztor Mvl',1)

Insert into artista values(8,'Meño',1)

...