Page 30 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE
P. 30
Unit 2: Database Relational Model
Notes
Department
Dname D.No Manager-id D.no DLocation
Administration 7 12345261 7 New York
Research 8 12345265 8 Detroit
Head quarters 9 12345267 9 Chicago
Project
Eid Pno Pname Plocation Dno
12345261 21 Computerization New York 7
12345265 31 Product A Detroit 8
12345267 41 New benefits Chicago 9
12345263 51 Soft drinks New Jersey 7
12345264 61 Reorganization Chicago 8
12345262 71 Product B New Jersey 7
Dependent
Eid Dep-Name Sex Relationship
12354261 Nivedita F Mother
12354262 Alan M Brother
12354263 Lizzzi F Sister
12354267 Roven F Daughter
12354265 Peter M Father
12354266 Kumar M Brother
12345267 Sunny M son
The different operations of relational algebra are:
Select ( )
The symbol for the select operation is . This operation is used to select particular rows from
the two relations, which satisfy the given condition.
The syntax for select operations (table name) <condition>
Example:
1. (DEPENDENT)
Sex = F
This can be read as “select from table DEPENDENT where Sex = F”. The following table
will be displayed.
LOVELY PROFESSIONAL UNIVERSITY 23
