Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
charles1309
Starting Member
15 Posts |
 Posted - 2007-11-05 : 09:18:16
|
| i need urgent help sorting out my SQl please....i have 6 tablesStudentclasslecturesstudent_resultsattendancemy case study says " the system should be able to record attendance of student to any class. the system shoul also be able to automatically send out a warning to any student that misses any two lectures for the first time."can anyone help me solve this problem on SQL (oracle) please...charles |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:22:07
|
quote:
SQL (oracle)
Answer1. This is a Microsoft SQL Server forum. Any help will primary for MS SQL Server2. We don't do homework / assignment. You should at least give it a try yourself.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
charles1309
Starting Member
15 Posts |
Posted - 2007-11-05 : 09:24:05
|
| can you please help me... am trying it,, just dont know if i am doing the right thing,,,thanxcharles |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:27:23
|
what have you tried ? Post your query here
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
charles1309
Starting Member
15 Posts |
Posted - 2007-11-05 : 09:59:23
|
| i havent written any code yet..i am still doing my ER diagram. my idea is to have an assumption, every student taking 3 modules in a semister and ill take the module id into attendance table, have a true or flase statment for , student attending the lecture or not..thanxcharles |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
charles1309
Starting Member
15 Posts |
Posted - 2007-11-05 : 16:11:54
|
| thanx very much brett.. i'll check the linkcharles |
|
|
|
|
|
|
|
|
urgent help needed....pleasee help me