正在加载图片...
Example Queries Find the set of all courses taught in the Fall 2009 semester,and in the Spring 2010 semester (t |3s e section (t [course_id]=s [course_id s [semester]="Fall"^s [year]2009 A3u∈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,but not in the Spring 2010 semester {t |3s e section (t [course_id]=s [course_id s [semester]="Falls [year]2009 3ue section (t [course_id ]=u [course_id] u[semester]=“Spring”Au[year]=2010)} Database System Concepts-7th Edition 27.8 ©Silberscha乜,Korth and SudarshanDatabase System Concepts - 7 27.8 ©Silberschatz, Korth and Sudarshan th Edition Example Queries {t | s  section (t [course_id ] = s [course_id ]  s [semester] = “Fall”  s [year] = 2009  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, and in the Spring 2010 semester ▪ Find the set of all courses taught in the Fall 2009 semester, but not in the Spring 2010 semester {t | s  section (t [course_id ] = s [course_id ]  s [semester] = “Fall”  s [year] = 2009   u  section (t [course_id ] = u [course_id ]  u [semester] = “Spring”  u [year] = 2010 )}
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有