Create database table for each relation below. While doing so, you need to:

• Identify the sequence/order in which the tables shall be created
• Identify the primary key for each table, and include that as constraint in the table structure
• Identify the foreign key (if any) for each table, and include that as constraint in the table structure
• Put a constraint on score: the value entered must not be less than 0 or more than 10
• Put a constraint on songName: there must be value entered for this attribute
• Set the default value for totscore as 0.

SINGER (singerID, singerName, singerAge)

SONG (songID, songName, songLength)

PERFORM (perfID, singerID, songID, totscore)

JUDGE (judgeID, judgeName)

JUDGING (judgeID, perfID, score)

Given the following 3NF relational schema regarding art exhibitions, lecaticnName. lecatisnAddress) ARTIST (artistID, artistName, artistCountuv) EXHIBITION (exbibitionCode exbibitionEndDate, lesationSode) ARTOBJECT (artObiectID, artobiestName, artobiestType, artistUp) ARTOBJECTEXHIBITED(exhibitionCode,arobiectID, booth) Note: Underlined attributes are primary/composite keys of the relations & italicized attributes are foreign keys)