Tutorial 3 - 1200 213 BK150 1500 304 DK250 1800 210...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Tutorial 3 STUDENT table SID Name Major GradeLevel Age S100 Ismail Information Science GR 21 S150 Muthusamy Artificial Intelligence SO 19 S200 Maniam Software Engineering GR 50 S250 Abu Bakar Information Science SR 50 S300 Mariam Artificial Intelligence SR 41 S350 Mary Software Engineering JR 20 S400 Jessica Artificial Intelligence FR 18 S450 Lim Information Science SO 24 ENROLLMENT table StudentNumber ClassName PositionNumber S100 BK445 1 S150 BK200 1 S200 DK445 2 S250 BK250 1 S300 BK150 1 S400 BK200 2 S400 BK410 1 S400 DK250 2 S450 DK200 3 CLASS table Name Time Room BK200 0800 110 DK445 0900 213 BK410
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1200 213 BK150 1500 304 DK250 1800 210 Relational Algebra Exercise How do you get the following? (1) What are the names of all students? (2) What are the student numbers of all students enrolled in a class? (3) What are the student numbers of all students enrolled in class DK445? (4) What are the names of the students enrolled in class DK445? (5) What are the names and meeting times of Abu Bakars classes?...
View Full Document

This note was uploaded on 02/06/2012 for the course FACULTY OF WXGE6320 taught by Professor Noraini during the Winter '09 term at University of Malaya.

Page1 / 2

Tutorial 3 - 1200 213 BK150 1500 304 DK250 1800 210...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online