The relationship between DEPARTMENT and EMPLOYEE is a

Related MCQs

• 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                            
• 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.
• Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.
• In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
• Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
• Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
• What is a relationship called when it is maintained between two entities?
• Key to represent relationship between tables is called
• Which is a bottom-up approach to database design that design by examining the relationship between attributes: