正在加载图片...
Example Queries Find the names of all instructors whose department is in the Watson building (t3s e instructor (t [name ]=s [name Au∈department(u[dept_name]=s[dept_name]“ ^u [building]"Watson")) Find the set of all courses taught in the Fall 2009 semester,or in the Spring 2010 semester,or both (t3s e section (t [course_id ]=s [course_id s[semester]=“Fall"∧s [year]=2009 v 3u section(t [course_id ]=u [course_id u[semester]=“"Spring”Au[year]=2o10)} Database System Concepts-6th Edition 6.16 ©Silberschat乜,Korth and SudarshanDatabase System Concepts - 6 6.16 ©Silberschatz, Korth and Sudarshan th Edition Example Queries Find the names of all instructors whose department is in the Watson building {t | s  section (t [course_id ] = s [course_id ]  s [semester] = “Fall”  s [year] = 2009 v u  section (t [course_id ] = u [course_id ]  u [semester] = “Spring”  u [year] = 2010 )} Find the set of all courses taught in the Fall 2009 semester, or in the Spring 2010 semester, or both {t | s  instructor (t [name ] = s [name ]  u  department (u [dept_name ] = s[dept_name] “  u [building] = “Watson” ))}
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有