What should i do here:

Convert your E-R diagram (I have E-R diagram) to logical database model . You are to design the table structure, including all needed attributes for each table. You must submit the relational database schema, which consists of the description of all tables, constraints in your database. For each table, please specify the primary key and foreign keys.

Is this answer below cover 'logical database model' and 'relational database schema' or I should add something else. Thanks a lot for your help.

CREATE TABLE ALBUM

(ALBUM_ID VARCHAR (5),

ALBUM_TITLE VARCHAR (50), NOT NULL

Number_of_tracks numeric (3,0),

ALBUM_YEAR NUMERIC (4,0),

ARTIST_ID VARCHAR (8),

RECORD_ID VARCHAR (8),

PRIMARY KEY (ALBUM_ID),

FOREIGN KEY (ARTIST_ID) REFERENCES ARTIST,

FOREIGN KEY (RECORD_ID) REFERENCES RECORD LABEL ;

CREATE TABLE SONG

(SONG_ID VARCHAR (8),

SONG_NAME VARCHAR (50), NOT NULL

SONG_LENGTH NUMERIC (5,2),

ALBUM_ID VARCHAR (8),

ARTISIT_ID VARCHAR (8),

PRIMARY KEY (ALBUM_ID)

FOREIGN KEY (ARTIST_ID) REFERENCES ARTIST );

CREATE TABLE RECORD LABEL

(RECORD_ID VARCHAR (8) ,

RECORD_NAME VARCHAR (50), NOT NULL,

CITY VARCHAR (100),

STATE VARCHAR (10),

COUNTRY VARCHAR (10),

WEBSITE VARCHAR (25),

PRIMARY KEY (RECORD_ID);

CREATE TABLE ARTIST

(ARTIST_ID VARCHAR (8) NOT NULL,

ARTIST_BAND VARCHAR (50)

ARTIST_FNAME VARCHAR (50),

ARTIST_LNAME VARCHAR (50),

PRIMARY KEY (ARTIST _ID);