Good people, I have a bank as described in the image below:
I have some questions:
A) Uma geladeira da marca Brastemp 220 V que custa R$ 700.
B) Três cadeiras de madeira em cores diferentes, cada uma custando R$ 53,40.
Response: INSERT INTO Produtos (descricao,marca,preco) VALUES ('Geladeira','BrasTemp',700)
INSERT INTO Eletrodomesticos(voltagem) VALUES (220)
But this error is appearing in question A:
Msg 515, Level 16, State 2, Line 8 Can not insert the value NULL into column 'Type', table 'LOJAMIX.dbo.Products'; column does not allow nulls. INSERT fails. The statement has been terminated. Msg 515, Level 16, State 2, Line 9 Can not insert the value NULL into column 'CodBarra', table 'LOJAMIX.dbo.Eletrodomesticos'; column does not allow nulls. INSERT fails. The statement has been terminated.
How do I resolve these errors?