Database Design & Development Design 1

In an ER diagram, what does a diamond shape represent?

• Entity

• Attribute

• Relationship

• Cardinality

Which of the following best describes the term "cardinality" in an ER diagram?

• The number of entities involved in a relationship

• The number of attributes an entity can have

• The uniqueness of an attribute

• The number of relationships an entity can have

What does a "crow's foot" symbol represent in an ER diagram?

• One-to-one relationship

• One-to-many relationship

• Many-to-many relationship

• Attribute of an entity

In a data dictionary, what is the purpose of a "constraint"?

• To define the tables in the database

• To limit the type of data that can go into a table

• To describe the attributes of an entity

• To document the relationships between entities

Which of the following is NOT typically included in a data dictionary?

• Data types

• Data relationships

• Data constraints

• Data values

In an ER diagram, what does a rectangle represent?

• Entity

• Attribute

• Relationship

• Cardinality

Which of the following is a characteristic of a composite key?

• It is made up of a single attribute

• It consists of multiple foreign keys

• It is used to uniquely identify a record using multiple attributes

• It is always a primary key

In an ER diagram, which symbol typically represents an attribute?

• Rectangle

• Diamond

• Ellipse

• Line

What is the purpose of a foreign key in a database?

• To uniquely identify records

• To establish a relationship between tables

• To store foreign data

• To enforce unique constraints

What does the term "referential integrity" ensure in a database?

• Data redundancy

• Consistency of data across relationships

• Data normalisation

• Data encryption