adplus-dvertising
frame-decoration

Question

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.

a.

Attributes of common

b.

Tuple of common

c.

Tuple of distinct

d.

Attributes of distinct

Posted under DBMS

Answer: (c).Tuple of distinct

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.

Q. The tuples of the relations can be of ________ order.

Q. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

Q. Using which language can a user request information from a database ?

Q. Student(ID, name, dept name, tot_cred)
In this query which attribute form the primary key?

Q. Which one of the following is a procedural language ?

Q. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

Q. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

Q. The _______operation performs a set union of two “similarly structured” tables

Q. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

Q. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

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.

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