In this assignment you will create a database model in MySQL Workbench. For this assignment you will create and upload a database model in accordance with the following guidelines:

Create a database model to store information for a database that stores information about Music CD's.

The database must have at least the structure to store the following:

CD name

Track name

Track length

Artist(s) who made the track

Artist(s) who made the CD

Genre for the track

As always the goal is to design this database structure so that there is noredundancy.

Use appropriate column Datatype for information being stored

All tables must have a primary key Relationships are defined

City id INT(11) name CHAR(35 untry CHAR(3) district CHAR(20) 1 more Indexes Country id NT code CHAR(3) Name CHAR(52) Continent ENUM Surface Area FLOAT(10,2) Indep Year SMALLINT(6) Population INT(11) LifeExpectancy FLOAT (3,1) GNP FLOAT(10,2) I GNPOld FLOAT 10,2) LocalName CHAR (45 Government Form CHAR(45 I HeadOfState CHAR (60) Code 2 CHAR(2) L capital INT region id NT Region id NT I name VARCHAR(150 continent id NT Indexes Continent v id NT name VARCHAR(45) info VARCHAR(255)