正在加载图片...
Safety of Expressions(Cont.) Consider again that query to find all students who have taken all courses offered in the Biology department {t3re student (t [ID]=r[ID]) (Hu∈course(u[dept_name]=“Biology”→ 3s E takes (t [ID]=s [ID s [course_id]=u [course_id)))} Without the existential quantification on student,the above query would be unsafe if the Biology department has not offered any courses. Database System Concepts-6th Edition 6.20 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 6.20 ©Silberschatz, Korth and Sudarshan th Edition Safety of Expressions (Cont.) Consider again that query to find all students who have taken all courses offered in the Biology department {t |  r  student (t [ID] = r [ID])  ( u  course (u [dept_name]=“Biology”   s  takes (t [ID] = s [ID ]  s [course_id] = u [course_id]))} Without the existential quantification on student, the above query would be unsafe if the Biology department has not offered any courses
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有