DROP TABLE IF EXISTS DBMSes;
CREATE TABLE DBMSes (
       DBMS_name VARCHAR(30) PRIMARY KEY,
       DBMS_available_as_FLOSS BOOLEAN NOT NULL,
       language_name VARCHAR(30)
);

INSERT INTO DBMSes VALUES('IndexedDB', TRUE, 'JavaScript');
INSERT INTO DBMSes VALUES('Mnesia', TRUE, 'Erlang');
INSERT INTO DBMSes VALUES('MySQL', TRUE, NULL);
INSERT INTO DBMSes VALUES('SQL Server', FALSE, NULL);

DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
       language_name VARCHAR(30) PRIMARY KEY
);

INSERT INTO languages VALUES('C');
INSERT INTO languages VALUES('Erlang');
INSERT INTO languages VALUES('Java');
INSERT INTO languages VALUES('JavaScript');
INSERT INTO languages VALUES('Python');
