SQL

DROP DATABASE IF EXISTS FN1; CREATE DATABASE FN1; USE FN1; DROP TABLE IF EXISTS VoterData; CREATE TABLE VoterData ( ID int NOT NULL AUTO_INCREMENT, fName VARCHAR(128), lName VARCHAR(128), address VARCHAR(255), email VARCHAR(128), PRIMARY KEY (ID) ); INSERT INTO VoterData (fName, lName, address, email) VALUES ("Mary", "Smith", "123 Main Street, Waltham, MA", "marys@gmail.com, marys@example.com"); INSERT INTO VoterData (fName, lName, address, email) VALUES ("Franz", "Kafka", "PO Box 13, Red Knuckle, MT", "Franzk@gmail.com, SadCockroach@example.com"); INSERT INTO VoterData (fName, lName, address, email) VALUES ("Primo", "Levy", "123 Elm Street, Milford, NH", "chemist@gmail.com, periodictable@example.com");