Cardinality Relationships in Databases

What is cardinality?

• The connection between attributes in a database.

• The relationship between entities in a database.

• The process of creating new entities.

• The method of storing data in a database.

What symbol is used to represent a relationship in a database diagram?

• Rectangle

• Oval

• Rhombus

• Circle

Which of the following best describes a "One to One" relationship?

• A relationship where one entity is connected to multiple other entities.

• A relationship where multiple entities are connected to a single entity.

• A relationship where one entity is connected to exactly one other entity.

• A relationship where entities are not connected.

In the example "A principal will manage a school and a school will only have one principal", what are the two entities?

• Principal and manages

• School and manages

• Principal and School

• Manages and has

What is the cardinality of the relationship between a principal and a school, where one principal manages one school, and one school is managed by one principal?

• One-to-Many

• Many-to-Many

• One-to-One

• Many-to-One

In a database, how is a one-to-one relationship typically enforced between two tables, such as 'PENGUETUA' (Principal) and 'SEKOLAH' (School)?

• By allowing multiple matching records in both tables.

• By ensuring that each record in one table corresponds to exactly one record in the other table through a shared unique identifier.

• By creating a separate linking table to connect records from both tables.

• By allowing one record in the 'PENGUETUA' table to link to many records in the 'SEKOLAH' table.

What is the definition of a One-to-Many relationship and how is it typically symbolized?

• A relationship where one entity relates to one other entity, symbolized as 1:1.

• A relationship where one entity relates to one or more other entities, symbolized as 1:M.

• A relationship where many entities relate to many other entities, symbolized as M:M.

• A relationship where many entities relate to one other entity, symbolized as M:1.

In a database system, if one student can borrow multiple books, but each book can only be borrowed by one student, what type of relationship exists between the 'Student' and 'Book' entities?

• One-to-One (1:1)

• One-to-Many (1:M)

• Many-to-One (M:1)

• Many-to-Many (M:M)

A national identification system states that each citizen possesses only one identity card. What is the cardinality of the relationship between 'Citizen' and 'Identity Card'?

• One-to-One (1:1)

• One-to-Many (1:M)

• Many-to-One (M:1)

• Many-to-Many (M:M)

In a school's database, a student can enroll in one or more subjects. What type of relationship exists between the 'Student' and 'Subject' entities?

• One-to-One (1:1)

• One-to-Many (1:M)

• Many-to-One (M:1)

• Many-to-Many (M:M)