Question: You need to make a database design in mysql with column names of client, contact, sales person, email.
The instrutions are given below: MySQL Server and MySQL Workbench. In this schema, create all the necessary tables, columns, and relationships to complete your database.
Do you need to put in the sql code to create a table? Can you provide example.
'client_id' smallint(5) unsigned NOT NULL AUTO_INCREMENT,
'first_name' varchar(45) NOT NULL,
'last_name' varchar(45) NOT NULL,
'last_update' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY ('client_id'),
KEY 'idx_client_last_name' ('last_name')
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8;
You need to give answer as soon as possible.