Management has requested that you build an employee database. You start with the employee table. What is the correct syntax?
CREATE TABLE IF EXISTS employee ( employeeID char(10), firstName varchar(50), lastName varchar(50), phone varchar(20), address varchar(50), PRIMARY KEY (employeeID) );
CREATE TABLE IF NOT EXISTS employee ( employeeID char(10), firstName varchar(50), lastName varchar(50), phone varchar(20), address varchar(50), PRIMARY KEY (employeeID) );
CREATE TABLE employee ( employeeID char(10), firstName varchar(50), lastName varchar(50), phone varchar(20), address varchar(50), PRIMARY KEY ON employeeID );
CREATE TABLE employee ( employeeID char(10), firstName varchar(50), lastName varchar(50), phone varchar(20), address varchar(50), PRIMARY KEY employeeID );