CREATE TABLE [dbo].[INGREDIENTE](
    [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [NOME] [varchar](20) NOT NULL,
    [CALORIA] [decimal](18, 2) NOT NULL
)

CREATE TABLE [dbo].[RECEITA](
    [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [TITULO] [varchar](20) NOT NULL,
    [DESCRICAO] [varchar](20) NOT NULL,
    [TEMPO] time NOT NULL
)

CREATE TABLE [dbo].[INGREDIENTE_RECEITA](
    [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [ID_INGREDIENTE] [int] NOT NULL FOREIGN KEY REFERENCES INGREDIENTE,
    [ID_RECEITA] [int] NOT NULL FOREIGN KEY REFERENCES RECEITA
)

------------------------------------------------------------------
--Preencher dados

INSERT INTO INGREDIENTE VALUES ('Açucar', 200)
INSERT INTO INGREDIENTE VALUES ('Farinha', 250)
INSERT INTO INGREDIENTE VALUES ('Ovo', 200)
INSERT INTO INGREDIENTE VALUES ('Cenoura', 100)

INSERT INTO RECEITA VALUES ('Bolo de Cenoura', 'blablablá', '00:25:00.000')

INSERT INTO INGREDIENTE_RECEITA VALUES (1, 1)
INSERT INTO INGREDIENTE_RECEITA VALUES (2, 1)
INSERT INTO INGREDIENTE_RECEITA VALUES (3, 1)
INSERT INTO INGREDIENTE_RECEITA VALUES (4, 1)