DATA-MANAGEMENT-FOUNDATIONS practice question 2 of 15
What is the first step of the analysis phase for designing a database?
Full set: 60 questionsDomain Data Modeling
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.
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. ---
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).
Keep practicing
Take the free DATA-MANAGEMENT-FOUNDATIONS practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-MANAGEMENT-FOUNDATIONS practice questions
- Question 1Which clause is used to specify the join columns when performing a join in MySQL?
- Question 3Which expression can be used to create a temporary name for a table?
- Question 4Which object relates an entity to itself in an entity-relationship model?
- Question 5Which action does the % operator accomplish in MySQL?
- Question 6Which description defines a data type?
- Question 7What is the second step in the implement relationships stage of database design?
