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.

Related MCQs

• 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.
• Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?
• 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 .
• Representations such as the in the dept year relation, with one column for each value of an attribute, are called                they are widely used in spreadsheets and reports and in data analysis tools.
• Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.