
CREATE SCHEMA HW_FACULTY;
/* Or 
CREATE DATABASE HW_FACUTLY;
*/

CREATE TABLE HW_FACULTY.PROF(
    Fname VARCHAR(15), -- No String!
    Room INT, -- shorthand for INTEGER, are also available: SMALLINT, FLOAT, REAL, DEC
    Title CHAR(3), -- fixed-length string, padded with blanks if needed
    Tenured BIT(1),
    Nice BOOLEAN, -- True / False (= 0) / Unknown
    Hiring DATE,
    Last_seen TIME,
    FavoriteFruit ENUM('apple','orange','pear'),
    PRIMARY KEY(Fname, Hiring)
);

/* Or
USE HW_FACULTY;
CREATE TABLE PROF(...)
*/

USE HW_FACULTY;

INSERT INTO PROF VALUES (
    "Clément" -- Or 'Clément', ' " ' and "'" are valid
    , 290
    , 'PhD'
    , 0
    , NULL
    , '19940101' -- Or '940101',  '1994-01-01',  '94/01/01'
    , '090500' -- Or '09:05:00', '9:05:0',  '9:5:0',  '090500'
    -- Note also the existence of DATETIME, with 'YYYY-MM-DD HH:MM:SS'
    , 'apple'
);