Database/Data Model/ERD

It is a collection of distinct small unit of information.

• Dataset

• Data

• Byte

• Bit

What is the primary purpose of a database?

• Data deletion

• Data analysis

• Storing, maintaining, and accessing data

• Data encryption

Which of the following is a high-level, abstract model representing the overall structure of data?

• Physical Data Model

• Logical Data Model

• Conceptual Data Model

• ER Diagram

Which type of data model specifies the structure of data in terms of tables, columns, and keys but is independent of the actual DBMS?

• Physical Data Model

• Logical Data Model

• Conceptual Data Model

• Relational Model

What is an entity in a data model?

• A property of a data field

• A definable object or concept about which data is collected

• A rule that defines data constraints

• A relationship between two tables

Which of the following is a characteristic or property of an entity in a data model?

• Relationship

• Relationship

• Attribute

• Constraint

In an ER Diagram, what does a "Primary Key" represent?

• A relationship between two entities

• A foreign key in a table

• A unique identifier for a record in a table

• A property of an attribute

What is the purpose of a "Foreign Key" in a database table?

• To uniquely identify each record in a table

• To enforce data constraints

• To reference a primary key in another table

• To define relationships between tables

What is "Cardinality" in an ER Diagram?

• The number of tables in a database

• The rules governing data constraints

• The number of occurrences in one entity related to the number of occurrences in another

• The attributes of an entity

Which of the following describes a one-to-many relationship?

• One entity is related to only one occurrence of another entity

• One entity is related to many occurrences of another entity

• Many entities are related to one occurrence of another entity

• Many entities are related to many occurrences of another entity