How to check time conflict in student course system using sql server

See more:

C#

ASP.NET

SQL-Server

, +

i want to check time conflict in student course system using sql server so that student can't add course to his plan if it con conflicts in time with another course for that student.

i try the following sql statments and it works correctly in the same table (CouseSection) and it gives me that course (system analysis) conflict with (hardware) But not for the same student.

i want to get the same result for the same student (student_id)
i don't know how to get the same result using student_id

here is sql statement

SELECT     
    t1.crs_sec_id, 
    t1.start_time, 
    t1.end_time, 
    t2.crs_sec_id AS overlapid
FROM         
    CourseSection AS t1 
    INNER JOIN CourseSection AS t2 
    ON t1.start_time < t2.end_time AND t1.end_time > t2.start_time 
    AND t1.date = t2.date
    AND t1.crs_sec_id <> t2.crs_sec_id
WHERE     
    (t1.Course_id = 4)

it gives me this result:

crs_sec_id	- start_time	   -      end_time	 -       overlapid
5	       -  10:00:00.0000000 - 	12:00:00.0000000  -	1

i want to get the same result for the same student (student_id)
i don't know how to get the same result using student_id?
where i can put the (student_id) in the previous statement to get the same result?

here is the relationships in my database
http://www.4shared.com/photo/ice8bR9Qba/db_online.html[^]

and student page
http://www.4shared.com/photo/BxqqgUcCba/page.html[^]

my try in sql server
http://www.4shared.com/photo/7dJyXY0Mce/dbconflict.html[^]