#### Table Constraints Exercise Solution

Defining The employees table:

    CREATE TABLE employees (
        id INT AUTO_INCREMENT NOT NULL,
        first_name VARCHAR(255) NOT NULL,
        last_name VARCHAR(255) NOT NULL,
        middle_name VARCHAR(255),
        age INT NOT NULL,
        current_status VARCHAR(255) NOT NULL DEFAULT 'employed',
        PRIMARY KEY(id)
    );

Another way of defining a primary key:

    CREATE TABLE employees (
        id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
        first_name VARCHAR(255) NOT NULL,
        last_name VARCHAR(255) NOT NULL,
        middle_name VARCHAR(255),
        age INT NOT NULL,
        current_status VARCHAR(255) NOT NULL DEFAULT 'employed'
    );

A test INSERT:

    INSERT INTO employees(first_name, last_name, age) VALUES
    ('Dora', 'Smith', 58);