CREATE TABLE Customers (
    CustomerID INT NOT NULL PRIMARY KEY,
    Name       VARCHAR(100) NOT NULL
);

CREATE TABLE Orders (
    OrderID    INT NOT NULL PRIMARY KEY,
    OrderDate  DATE NOT NULL,
    CustomerID INT,
    CONSTRAINT fk_customer FOREIGN KEY (CustomerID)
        REFERENCES Customers (CustomerID)
);