There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

Related MCQs

• 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
• Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
• The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary) This type of decomposition is called
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
• If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
• 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.
• An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
• 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.
• There are two functional dependencies with the same set of attributes on the left side of the arrow: A->BC A->B This can be combined as
• For a weak entity set to be meaningful, it must be associated with another entity set, called the