Carlosdl
29795 pts. | Nov 4 2009 8:16PM GMT
So, the question is about database design, syntax of the CREATE TABLE statement, the SELECT statements that would get your answers, or the complete solution ?
I would recommend:
Ak1bo78
30 pts. | Nov 4 2009 8:34PM GMT
Thanks…Well design. Because I know once the design is perfect then the querys will be too…Im trying this now:
creat table budget (dname char (30) not null,courseno int null,budget float);
It works!! I used the budget float because Department C manages courseno 5,6,7,8 and courseno 5 is on £200 budget and the rest £300….
BUT when im inserting values as so: insert into budget values (’Department A’,1,2,200) it doesnt work :|… :(….
Thanks for the link but I dont think i can learn that fast and there too much info…its not specific etc…
I appreciate much you help though.
Ak1bo78
30 pts. | Nov 4 2009 8:36PM GMT
Oh and I inserted values like this: ….(’Department A’,1,2,200) because Department A manages courseno 1 and 2…. ![]()
Carlosdl
29795 pts. | Nov 4 2009 10:11PM GMT
You really need that course.
And this:
Learning requires some effort.






