Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

DBMS Previous Year Question Paper for Fifth Semester BTech Computer Science and IT

Here i have uploaded the previous year (2014 November) question paper of Database management systems (C S, IT) for Fifth semester for Computer science and engineering (CS or CSE) and information technology (IT) branches under MG university BTech course.

Course : B.Tech Engineering (degree)
University: MG university (Mahatma Gandhi university) Kottayam, Kerala
Department or branch: Computer science and engineering (CS or CSE) and Information Technology (IT)

Relational Algebra - Selection, Projection, Joins etc

The relational algebra defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction etc which operate on numbers.The relational algebra operations take one or two relations (tables) as input and return a relation as output. This post we discuss the following relational operations:
  1. Selection (σ)
  2. Projection (π)
  3. Cartesian product
  4. Joins

Selection Operation (σ)