Entities, Attribute, and Relationships

Relationships in a data model define how entities are unrelated.

• True

• False

Which of the following describes a "data model"?

• A list of all entities ordered by their names in database

• A visual representation of the structure of a database

• A unique identifier for every entity in the database

• All attributes in each entity in the database

Which of the following are attributes of a "Patient" entity in a pharmacy database? (Select all that apply)

• Patient ID

• Patient Name

• Favorite Color

• Patient Address

• Supermarket Address

Which of the following should be considered when building relationships between entities? (Select all that apply)

• A. The primary key should be unique in each table.

• B. Each entity should have one foreign key.

• C. A foreign key links a table to another table’s primary key.

• D. A primary key should always be placed at the end of the table.

• E. Relationships help organize and connect data across tables.

In your own words, explain what an entity is in the context of a database. Provide an example of an entity that could be used in a hospital database.