DATA-MANAGEMENT-FOUNDATIONS practice question 2 of 15

What is the first step of the analysis phase for designing a database?

Full set: 60 questions

Domain Data Modeling

Answer options
A: Determine cardinality
B: Identify entities Correct answer
C: Draw an entity-relationship (ER) diagram
D: Implement attributes
Correct Answer:
B. Identify entities
Explanation

The analysis phase of database design, also known as conceptual design, begins with understanding and modeling the data requirements. The first and most fundamental step is to identify the principal objects, concepts, or "things" about which the organization needs to store data. These are known as entities. Before defining their properties (attributes), establishing connections between them (relationships), or creating a visual model (ER diagram), the designer must first determine what these core entities are based on the system's requirements. This initial identification forms the foundation for the entire database structure.

Why Incorrect

A. Determine cardinality: Cardinality defines the numerical relationship between entities. This step can only occur after the entities and their relationships have first been identified.
C. Draw an entity-relationship (ER) diagram: The ER diagram is a visual artifact created after its core components—entities, attributes, and relationships—have been identified and defined.
D. Implement attributes: Attributes are characteristics that describe an entity. Logically, an entity must be identified before its descriptive properties can be defined. ---

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 7, Section 7.2, "Initial Conceptual Design of the COMPANY Database," the text states, "The first step is to identify the entity types and relationship types... Based on the requirements specification, the initial set of entity types for the COMPANY database are DEPARTMENT, PROJECT, and EMPLOYEE." (p. 221).

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. Chapter 7, Section 7.2, "The Entity-Relationship Model," introduces the core concepts, stating, "The E-R model employs three basic concepts: entity sets, relationship sets, attributes." The process of design logically begins by identifying these, starting with the entity sets. (p. 269).

3. Ramakrishnan, R., & Gehrke, J. (2003). Database Management Systems (3rd ed.). McGraw-Hill. In Chapter 2, Section 2.2, "Conceptual Database Design with the ER Model," the authors explain the design process: "The very first step in designing a database is to understand the real-world domain... and to identify the main entities to be modeled." (p. 28).

Scroll to Top