Feedback?

PARTICIPATION ACTIVITY

The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show information about the Album and Song table columns.

Modify the two CREATETABLE statements

$1$ Add a primary key constraint to the Album tables $10$ column

$2$ Add a primary key constraint to the Song table's ID column

$3.$ Add a foreign key constraint to the Song table so the AlbumID column refers to the Album tables ID column.

$1...$ Add a primary key.

$2$ CREATE TABLE Album?

II$)$ IVI,

Title VARCHAR $(68),$

Releaseyear INT

$\%$

$..$ Add primary and foreign keys

CREATE TABLE Song $($

II$)$ INT,

Title VARCHAR $(6e),$

Artist VARCHAR$(68),$

AIbumID INT

is

SHON COLUMW

From Album;

SHOW COLUHINS

FROM Song;

Reset code

Vierv solution