Relationships between database tables (relational database)

Question 1

What is a One to One Relationship Type?

Answer 1

Visual representation in database design that shows the relationship between two entities, where each entity is uniquely paired with exactly one instance of the other entity.

Question 2

What is an example of a One to One Relationship Type?

Answer 2

A person can have only one passport

Question 3

What does a One to One Relationship Type look like?

Answer 3

A straight line with two small lines perpendicular to the straight line at the end of it

Question 4

What is a One to Many Relationship Type?

Answer 4

Illustrates a scenario where one instance of an entity is associated with multiple instances of another entity, but each instance of the second entity is related to only one instance of the first.

Question 5

What is an example of a One to Many Relationship Type?

Answer 5

One teacher many students

Question 6

What does a One to Many Relationship Type look like?

Answer 6

A straight line with one small line perpendicular to the straight line at the end of it and two lines at a 45 degree angle coming out of the perpendicular line on each side of the longest line

Question 7

What is a Many to Many Relationship Type?

Answer 7

Multiple instances of one entity are associated with multiple instances of another entity.

Question 8

What is an example of a Many to Many Relationship Type?

Answer 8

A student can enroll into many courses and a course can have multiple students enrolled into it

Question 9

What does a One to Many Relationship Type look like?

Answer 9

A straight line with two lines at a 45 degree angle coming out of the line at the end of it