إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

نرجو منكم حل هذا السوال


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

#1 kamal6666

kamal6666

    عضو

  • الأعضــاء
  • 14 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 14 May 2009 - 10:13 PM

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?