Course Code: CS403 Total Marks: 15

Deadline date:

Your assignment must be uploaded / submitted before or on November 21, 2009.

Upload Instructions

Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.

Rules for Marking

Kindly note that your assignment will NOT be graded if:

§ It is submitted after due date

§ The file you uploaded does not open

§ The file you uploaded is copied from someone else

1(a). Find out the Cartesian product (A X B) of the given pair of sets. Marks: 5

A => Set of first letter of the names of countries = A = { P, U, I }

B => Set of numbers denoting University numbers = B = {010, 011}

1(b). Consider the table below:

Room Table

RoomNo	hotelNo	Type	price
10	001	A	100
15	002	B	50
20	002	C	50
25	003	A	150

Show the relation that will be produced by the following relational algebra operation:

∏_hotelNo (_{price > 50} (Room)) Marks: 10