لا توجد ردود على هذا الموضوع

[kamal6666]

create two tables
exam ( ex_id, ex_subject,ex_date,ex_limit) and
student_exam(examid,student_id).
insert the following row into the exam table:
1, 'database design', '06/06/2003', 3
insert into the student_exam table the following two records:
1, 111
2, 222

1. create a stored procedure for registering student for an exam.the stored procedure has to guarantee that more students cannot register for a certain exam than given limit in the exam table . the input parameters of the stored procedure are the exam id and the student id.
2. open tow windows . and try to execute the stored procedure with two different input parameters : try to register both the student with id 333 and with 444 for the exam 1.what is happening ? why?
3. insert a new condition into the stored procedure it's not allowed to register for an exam after the beginning of the exam?