12.3 SQL LAB 3 - Create Song tables with constraints

Create an Song table with the following columns, data types, and constraints:

• ID - integer with range 0 to 65 thousand, auto increment, primary key

• artistID - integer with range 0 to 65 thousand, not NULL, foreign key to Artist

• albumID - integer with range 0 to 65 thousand, not NULL, foreign key to Album

• title - variable-length string with max 50 chars, not NULL

• leadVocals - variable-length string with max 40 chars, not NULL

Note: Not all constraints can be tested due to current limitations of MySQL.

12.3 SQL LAB 3 - Create Song tables with constraints Create an Song table with the following columns, data types, and constraints: ID - integer with range 0 to 65 thousand, auto increment, primary key artistID - integer with range 0 to 65 thousand, not NULL, foreign key to Artist albumID - integer with range 0 to 65 thousand, not NULL, foreign key to Album title - variable-length string with max 50 chars, not NULL lead Vocals - variable-length string with max 40 chars, not NULL Note: Not all constraints can be tested due to current limitations of MySQL