create two tables
exam ( ex_id, ex_subject,ex_date,ex_limit) and
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. 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?
نرجو منكم حل هذا السوال
لا توجد ردود على هذا الموضوع