create table recipe (
	id		int,
	course		char(1),
	calories	int,
	name		char(30),
	description	char(254)
);

create table ingredients (
	rec_id		int,
	quantity	char(20),
	name		char(20)
);

create table prep (
	rec_id		int,
	step_num	int,
	description	char(254)
);

insert into recipe values (
1,
'dessert',
325,
'Carrot Cake',
'A favorite classic.  Carrots are inexpensive and are always on hand.  Stays moist and freezes well.'
);

insert into ingredients values (1, '1 1/2 cups', 'sugar');
insert into ingredients values (1, '1 cup','vegetable oil');
insert into ingredients values (1, '3','eggs');
insert into ingredients values (1, '2 cups','all-purpose flour');
insert into ingredients values (1, '1 1/2 teaspoons','ground cinnamon');
insert into ingredients values (1, '1 teaspoon','baking soda');
insert into ingredients values (1, '1 teaspoon','vanilla');
insert into ingredients values (1, '1/2 teaspoon','salt');
insert into ingredients values (1, '1/4 teaspoon','ground nutmeg');
insert into ingredients values (1, '3 cups','shredded carrots');
insert into ingredients values (1, '1 cup','coarsely chopped nuts');

insert into prep values (1, 1, 'Heat oven to 350 degrees');
insert into prep values (1, 2, 'Grease and flour rectangular pan, 13 x 9 x 2 inches');
insert into prep values (1, 3, 'Mix sugar, oil and eggs in large bowl until blended; beat 1 minute');
insert into prep values (1, 4, 'Stir in remaining ingredients except carrots and nuts; beat 1 minute');
insert into prep values (1, 5, 'Stir in carrots and nuts');
insert into prep values (1, 6, 'Pour into pan');
insert into prep values (1, 7, 'Bake 35 to 45 minutes or until wooden pick inserted in center comes out clean.');
insert into prep values (1, 8, 'Cool on wire rack');
insert into prep values (1, 9, 'Frost with cream cheese frosting if desired');
