Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE DATABASE SPOTIFY;
- CREATE TABLE MUSICA(
- ID INT NOT NULL IDENTITY PRIMARY KEY,
- NOME VARCHAR(50) NOT NULL,
- DURACAO TIME NOT NULL,
- ANO INT
- );
- CREATE TABLE CANTOR(
- ID INT NOT NULL IDENTITY PRIMARY KEY,
- NOME VARCHAR(100) NOT NULL,
- NACIONALIDADE VARCHAR(20) NOT NULL
- );
- CREATE TABLE MUSICA_CANTOR(
- MUSICA_ID INT NOT NULL,
- CANTOR_ID INT NOT NULL,
- PRIMARY KEY(MUSICA_ID, CANTOR_ID)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement