The                    provides a set of operations that take one or more relations as input and return a relation as an output.

Related MCQs

• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
• Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
• Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
• An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
• An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
• A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called