CREATE TABLE Funcionario(
id INT PRIMARY KEY,
nome VARCHAR (10) ,
idade INT,
salario FLOAT
);
CREATE TABLE Carro(
id INT PRIMARY KEY,
placa TEXT,
modelo VARCHAR (15),
funcionario_fk INT,
FOREIGN KEY (funcionario_fk) REFERENCES funcionarios(id)
);
INSERT INTO Funcionario VALUES (4,'anna laura',15,30.000);
INSERT INTO Funcionario VALUES (8, 'feson',16, 100.000);
INSERT INTO Funcionario VALUES (12,'laura',17,15.000);
INSERT INTO Carro VALUES(4,'ALMPMM','porshe',12);
INSERT INTO Carro VALUES(2,'AJSUNP','bmw',8);
INSERT INTO Carro VALUES(10,'HDINS','ferrari',4);
SELECT * FROM Carro;
SELECT * FROM Funcionario;
To embed this project on your website, copy the following code and paste it into your website's HTML: