quote:

---

Originally posted by nigelrivett

Homework?
I guess this is grading the professor that takes a class.

you only need classes and grades for the first part. I take it you know how to join the tables. Do you know about the group by clause?

For the second part you just need professors and classes.
Get the professorID for professors that teach 1 class - just needs the classes table
Use that result to get the last name from the professor table


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

quote:

---

Originally posted by nigelrivett

then - your design is a bit odd - why do you have a grades table?
select g.grade, count(*)
from classes c
join grades g
on g.classid = c.classid
group by g.grade

select lastname
from professors p
where professorid in (select professorid from classes group by professorid having count(*) = 1)


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

quote:

---

Originally posted by nigelrivett

>> This is keeping track of my personal classes and personal grades
>> I was required to make three tables

Sounds even more like homework.
The requirement was for 3 tables, what would be a better design?

If the requirement was just for 3 tables then it's not a good design. If the requirement gave the design then it's not a good course. Decide whether you want to follow these requirements or keep track of your classes and grades - a sql server database probably isn't a good choice for that.


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---