The Database Development Process Questions

Schema mapping reality check: Evaluate the statement: "There is one physical schema for each logical schema."

Lifecycle methods awareness: Consider the following statement: "One of the most popular systems development life cycle methods is prototyping."

Physical database design scope: Evaluate the claim: "The physical database design identifies data integrity and security requirements."

Lifecycle duration reality: Assess the statement: "The longest step of database development is database maintenance."

Logical vs. physical design distinction: Evaluate the claim: "During logical database design, the conceptual data model is transformed into a logical data model that describes the data in terms of a specific data management technology."

In systems analysis, is the following statement accurate? “Functional decomposition is the process of breaking down the functions of an organization into greater and greater levels of detail.” State whether this characterization is correct or incorrect and consider its purpose in requirements analysis and design.

Conceptual schema representation — assess the statement: “A conceptual schema is usually depicted in a graphical format using Entity–Relationship (E-R) or object-modeling notations.” Indicate whether this is correct or incorrect.

Project initiation analysis — judge the claim: “There are three stages involved when analyzing the initiation of an information systems project.” Decide whether this generalization is correct or incorrect and consider typical stage breakdowns.

Strategic alignment — evaluate the statement: “The goal of information systems planning is to align information technology with the business strategies of the organization.” Choose whether this is correct or incorrect.

Primary driver for data architecture — judge the statement: “The most important reason for data architecture is reliability.” Indicate correct or incorrect and consider competing primary drivers such as integration, quality, and business alignment.