Question
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
a.
Attributes of common
b.
Tuple of common
c.
Tuple of distinct
d.
Attributes of distinct
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. 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...
Similar Questions
Discover Related MCQs
Q. A domain is atomic if elements of the domain are considered to be ____________ units.
View solution
Q. The tuples of the relations can be of ________ order.
View solution
Q. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.
View solution
Q. Using which language can a user request information from a database ?
View solution
Q. Student(ID, name, dept name, tot_cred)
In this query which attribute form the primary key?
View solution
Q. Which one of the following is a procedural language ?
View solution
Q. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
View solution
Q. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
View solution
Q. The _______operation performs a set union of two “similarly structured” tables
View solution
Q. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
View solution
Q. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
View solution
Q. A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
View solution
Q. The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!