I need help with an assignment due today. The Assignment is:

The following assignment is based on the database environment designed in the Week Three Individual Assignment.

Your MySQL database project must meet the following assessment requirements:

• A database in MySQL using professional principles and standards.  
• Use MySQL database to create the normalized physical database implementing the logical design into a physical design including tables, columns with data types, primary keys, constraints, etc.

Create a single sql script file that executes in MySQL containing a minimum of ten rows of test data inserted in each table, along with the sql statements needed to create tables with keys and to insert test rows, etc., into the tables.

 

I am having problems getting my test data to work at all and do not think I am going about it the right way. This is MySql work so far --

CREATE TABLE art (

  art_id int,

  artist_id int,

  location_id int,

  employee_id varchar(25),

  art_received varchar(25),

  carat int, 

  primary key (art_id)

foreign key (artisit_id) references artist(artist_id),

  foreign key (location_id) references location(location_id),

  foreign key (employee_id) references employee(employee_id)

 

); 

 

CREATE TABLE employee (

  employee_userid int,

  employee_fname varchar(50),

  employee_lname varchar(50),

  employee_phone int,

  

  primary key (employee_id)

 

  

); 

 

CREATE TABLE artist(

  art_id int,

  artist_fname varchar(50),

  artist_lame varchar(50),

artiwork_title varchar(75),

   

  primary key (art_id)

   

); 

 

CREATE TABLE location(

  location_id int,

  location_name varchar(50),

  start_date date,

end_date date,

   

  primary key (location_id)

   

); 

 

 

I have also attached my Visio file too. Any help would be appreciated. Thank you.