Entity Relationship Quiz

. There is a bank, which has several departments, like IT department, finance, HR, etc. There are a lot of employees and each of them belongs to only one department. What type of relationship is between department entity and employees entity?

• one-to-many

• one-to-one

• many-to-many   

A teacher may be assigned with exactly one position, like tutor, lecturer or professor. A position must be assigned to one or more teachers. A teacher is recorded with teacher identity code, name, address and date of birth. A position is associated with name of the position and the identity code for the position. Identify a type of the relationship between TEACHERS and POSITIONS entities.

• one (teachers)-to-one (positions)

• one (positions)-to-many (teachers)

• many (teachers)-to-many (positions)

• one (teachers)-to-many (positions)

A teacher may be assigned with exactly one position, like tutor, lecturer or professor. A position must be assigned to one or more

teachers. A teacher is recorded with teacher identity code, name, address and date of birth. A position is associated with name of the

position and the identity code for the position. Identify a table with a Foreign Key(s) for the relationship between TEACHERS and

POSITIONS.

• TEACHERS

• in the TEACHER'S table or in the POSITIONS table-both options are correct

• POSITIONS

• associative table between TEACHERS and POSITIONS tables

here is a company that specializes in repairing various equipment. This company takes orders from customers every day. They have a team of specialists, each of whom can perform various orders, however one order is related to only one specialist. Based on this description, determine the type of relationship between specialists entity and orders entity?

• many-to-many

• one-to-many

• one-to-one

There is a bank that serves many customers, each of which can have one / several accounts, for example, a savings account, a salary

account, etc. Determine the type of relationship between the customers entity and the accounts entity?

• many-to-many

• one-to-one

• one-to-many

A teacher teaches one or more groups, each of which is taught by one or more teachers. A teacher is associated with teacher's ID and teacher's name. A group is associated with group code. Identify a type of the relationship between TEACHERS and GROUPS.

• (teachers)-to-one (groups)

• Attributes(groups)-to-many (teachers)

• (teachers)-to-many (groups)

A teacher teaches one or more groups, each of which is taught by one or more teachers. A teacher is associated with teacher's ID and teacher's name. A group is associated with group code. Identify a table with a Foreign Key(s) for the relationship between TEACHERS and GROUPS.

• TEACHERS

• associative table between TEACHERS and GROUPS tables

• GROUPS

• in the TEACHER'S table or in the GROUPS table-both options are correct

Appointment of patients is carried out by doctors of different specialties (surgeon, cardiologist, ophthalmologist, etc.). And patients can choose to visit various doctors. Based on this description, determine the type of relationship between patients entity and doctors entity?

• one-to-many

• many-to-many

• one-to-one

. What type of relationship is described by the following rule? For one instance of entity A, there exists one or many instances of entity B; and for one instance of entity B, there exists one or many instances of entity A.

• one-to-one

• many-to-many

• one-to-many

What type of relationship is described by this rule? For one instance of entity A, there exists one or many instances of entity B; but for one instance of entity B, there exists one instance of entity A.

• many-to-many

• one-to-many

• one-to-one