![]() ![]() It includes all tuples that are in tables A or in B. Ρ (a/b)R will rename the attribute ‘b’ of relation by ‘a’. Rename is a unary operation used for renaming attributes of a relation. Here, the projection of CustomerName and status will give Π CustomerName, Status (Customers) This operator helps you to keep specific columns from a relation and discards the other columns. (pi) symbol is used to choose attributes from a relation. This helps to extract the values of specified attributes to eliminates duplicate values. The projection method defines a relation that contains a vertical subset of Relation. The projection eliminates all attributes of the input relation but those mentioned in the projection list. ![]() Output – Selects tuples from Customers where sales is greater than 50000 Projection(π) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |