{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# Tutorial 3Ans - (3 What are the student numbers of all...

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

Relational Algebra Exercises 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 1200 213 BK150 1500 304 DK250 1800 210

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

View Full Document
Relational Algebra Exercise How do you get the following? (1) What are the names of all students? ANSWER π Name ( STUDENT) (2) What are the student numbers of all students enrolled in a class? ANSWER π STUDENTNUMBER ( ENROLLMENT)
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (3) What are the student numbers of all students enrolled in class ‘DK445’? ANSWER π STUDENTNUMBER ( δ CLASSNAME = ‘DK445’ ( ENROLLMENT)) (4) What are the names of the students enrolled in class ‘DK445’? ANSWER π Name ( δ CLASSNAME = ‘DK445’ (STUDENT ∝ SID = STUDENTNUMBER ENROLLMENT)) (5) What are the names and meeting times of “Abu Bakar’s” classes? ANSWER π NAME, TIME (CLASS Name = CLASSNAME ∝ ( π CLASSNAME ( δ STUDENTNAME = ‘ Abu Bakar’ ’ (STUDENT ∝ SID = STUDENTNUMBER ENROLLMENT)))) or π NAME, TIME (CLASS Name = CLASSNAME ∝ ( δ STUDENTNAME = ‘ Abu Bakar’ ’ (STUDENT ∝ SID = STUDENTNUMBER ENROLLMENT)))...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Tutorial 3Ans - (3 What are the student numbers of all...

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

View Full Document
Ask a homework question - tutors are online