group: ROMER
description: Tables from and for the lecture [Databases: Foundations, Data Models and System Concepts - University of Innsbruck](http://dbis-informatik.uibk.ac.at/249-0-VO-Datenbanksysteme.html) chapter 3
category@de:ROMER
category@en:University of Me

Maq =
{codMaq, nomeMaq

11, 'batedeira'
12, 'liquidificador'
13, 'forno'
14, 'peneira'
15, 'microondas'
16, 'congelador'
17, ''
18, ''
}

Produto =
{codProd, descrProd, pesoProd

21, 'geleia', 1
22, 'bolo', 3
23, 'suco', 2
24, 'fruta', 2
25, 'acucar', 5
26, 'linhaca', 1
27, 'milho', 10
28, 'pipoca', 3
29, 'curral', 2
}

MaqProd =
{
codMaq, codProd, tempo, descProcesso

13, 22, 45, 'assar o bolo'
12, 23, 3, 'bater o suco'
14, 23, 2, 'coar o suco'
11, 22, 10, 'bater o bolo'
12, 27, 5, 'liquidificar o milho'
13, 27, 3, 'cozinhar o milho'
15, 27, 1, 'estourar o milho'
}

ComposProd=
{codProdComposto, codProdComponente, quantidade, proc

23, 24, 2, 'suco/fruta'
21, 25, 7, 'geleia/açucar'
28, 27, 4, 'pipoca/milho'
29, 27, 2, 'cural/milho'
}