View the step-by-step solution to:

Assignment No. 01 Total Marks: 15 (5+10) Semester Spring 2010 Database Management Systems-CS403 Due Date: 21/05/2010 Objective: To learn and...

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 = { R, S, T }
B => Set of numbers denoting Postal codes = B = { 0001, 1001}

1(b). Consider the table below:
Room Table
RoomNo Hotel_ Name Ranking Rate(Rs.)
10 Holiday Inn A 17000
15 Avari B 17000
20 Pearl Continental A 20000
25 Sunfort C 16000

Show the relation that will be produced by the following relational algebra operation:
∏Hotel_Name ( Rate > 16000 (Room)) Marks: 10


Assignment No. 01 Semester Spring 2010 Database Management Systems-CS403 Total Marks: 15 (5+10) Due Date: 21/05/2010 Objective: To learn and understand basic concepts of different levels of Data Flow Diagrams (DFD’s). Instructions: Please read the following instructions carefully before solving & submitting assignment: Assignment should be in your own wordings not copied from net, handouts or books. It should be clear that your assignment will not get any credit (zero marks) if: o The assignment is submitted after due date. o The submitted assignment does not open or file corrupt. o The assignment is copied (from other student or copy from handouts or internet). o Student ID is not mentioned in the assignment File or name of file is other than student ID. o Assignment is not submitted in DOC file. For any query about the assignment, contact at [email protected] GOOD LUCK 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 = { R, S, T } B => Set of numbers denoting Postal codes = B = { 0001, 1001} 1(b). Consider the table below: Room Table RoomNo Hotel_ Name Ranking Rate(Rs.) 10 Holiday Inn A 17000 15 Avari B 17000 20 Pearl Continental A 20000 25 Sunfort C 16000 Show the relation that will be produced by the following relational algebra operation: Hotel_Name ( Rate > 16000 ( Room )) Marks: 10
Background image of page 1
Upload Instructions: Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.
Background image of page 2

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question