Design a database for employee information

Problem

Design a database to store information on a company's employees.
Example input:
EmployeeID,FirstName,LastName,Position,Department,HireDate
1,John,Smith,Developer,IT,1/1/2000
2,Jane,Doe,Accountant,Finance,2/2/2001
3,Joe,Shmo,Sales,Sales,3/3/2002
Example output:
Employee table:
+-------------+--------------+-------------+----------+-------------+------------+
| EmployeeID | FirstName | LastName | Position | Department | HireDate |
+-------------+--------------+-------------+----------+-------------+------------+
| 1 | John | Smith | Developer | IT | 1/1/2000 |
| 2 | Jane | Doe | Accountant | Finance | 2/2/2001 |
| 3 | Joe | Shmo | Sales | Sales | 3/3/2002 |
+-------------+--------------+-------------+----------+-------------+------------+

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

Solution:

CREATE TABLE Employee (
  EmployeeID INT NOT NULL,
  FirstName VARCHAR(255) NOT NULL,
  LastName VARCHAR(255) NOT NULL,
  Position VARCHAR(255) NOT NULL,
  Department VARCHAR(255) NOT NULL,
  HireDate DATE NOT NULL,
  PRIMARY KEY (EmployeeID)
);

This solution is optimal because it is the most normalized form of the table.

*/