Alternative Energy Options

Create Table SQL

CREATE TABLE tblEnergyOpts(
    pmkOptionId INT AUTO_INCREMENT PRIMARY KEY,
    fldOption VARCHAR(20),
    fldCost FLOAT,
    fldEfficiency VARCHAR(10)
)

INSERT INTO tblEnergyOpts
(fldOption, fldCost, fldEfficiency)
VALUES
('Coal', 4.8, '32%-45%'),
('Hydroelectric', 5.1, "90%-100%"),
('Nuclear', 4.3, '30%-36%')

SELECT fldOption, fldCost, fldEfficiency
FROM tblEnergyOpts


CREATE TABLE tblOptionPreference (
    pmkPreferenceId INT AUTO_INCREMENT PRIMARY KEY,
    fldPreference VARCHAR(15),
    fldConfidence VARCHAR(10),
    fldWhy TEXT,
    fldBio BOOLEAN,
    fldHydro BOOLEAN,
    fldNuclear BOOLEAN,
    fldSolar BOOLEAN,
    fldWind BOOLEAN,
    fldFirstName VARCHAR(50),
    fldLastName VARCHAR(50),
    fldEmail VARCHAR(50)
)

INSERT INTO tblOptionPreference 
    (fldPreference, fldConfidence, fldWhy, fldBio, fldHydro, fldNuclear, fldSolar, 
    fldWind, fldFirstName, fldLastName, fldEmail)
VALUES
    ('Wind', 'Sure', 'whoosh power', '0', '1', '0', '1', '1', 'Skye', 
    'Smith', 'mvsmith@uvm.edu')