Question

Write SQL code to create a database called HumanResources that has a single table called Employee. The Employee table should have two columns, one to store the employee id, and another to store the employee’s last name.

Answer 1

CREATE DATABASE 'HumanResources'
CREATE TABLE 'Employee'
('id' INT(8) NOT NULL AUTO_INCREMENT,
& 'lastName' CHAR(30) NOT NULL
& )