National 5 - Databases - ER Diagrams

What is the purpose of an entity relationship diagram (ER diagram) in database design?

• To visually describe the type of relationship between tables

• To store large amounts of data

• To create complex mathematical calculations

• To design user interfaces

In a one-to-many relationship, which side is indicated by a straight line in an ER diagram?

• Neither side

• Both sides

• The many side

• The one side

What does the crow's feet symbol indicate in an ER diagram?

• The one side of a relationship

• A one-to-one relationship

• The many side of a relationship

• A circular relationship

What is the purpose of including the name of the relationship in an ER diagram?

• To provide a small description of the relationship between entities

• To indicate the primary key of the entity

• To define the foreign key constraints

• To specify the data type of the attributes

What are attributes in the context of an ER diagram?

• Relationship names between entities

• Fields related to an entity

• Foreign keys of the entities

• Primary keys of the entities

In the context of ER diagrams, what does a primary key indicate?

• A one-to-many relationship

• A description of the relationship between entities

• A field related to another entity

• A unique identifier for each record in the entity

What is the purpose of foreign keys in an ER diagram?

• To establish a link between two entities

• To provide a small description of the relationship between entities

• To indicate the primary key of an entity

• To define the data type of the attributes

In a many-to-many relationship, what does the asterisk next to a foreign key indicate?

• It indicates a circular relationship

• It represents a one-to-one relationship

• It is the primary key of the related entity

• It is the foreign key of the related entity