2. 从业资格
  3. During the systems analysis phase ，you m

During the systems analysis phase ，you m

最全题库2022-08-02  84
问题 During the systems analysis phase ，you must decide how data will be organized，stored，and managed. A（  ）is a framework for organizing，storing，and managing data. Each file or table contains data about people，places，things，or events. One of the potential problems existing in a file processing environment is（  ）,which means that data common to two or more information systems is stored in several places.In a DBMS，the linked tables form a unified data structure that greatly improves dataquality and access. A(n)（  ）is a model that shows the logical relationships and interaction among system entities . It provides an overall view of the system and a blueprint for creating the physical data structures.（  ）is the process of creating table designs by assigning specific fields or attributes to each table in the database. A table design specifies the fields and identifies the primary key in a particular table or file. The three normal forms constitute a progression in which（  ）represents the best design. Most business-related databases must be designed in that form.问题1 A.data entity B.data structure C.file collection D.data definition问题2 A.data integrity B.the rigid data structure C.data redundancy D.the many-to-many relationship问题3 A.entity-relationship diagram B.data dictionary C.database schema D.physical database model问题4 A.Normalization B.Replication C.Partitioning D.Optimization问题5 A.standard notation form B.first normal form C.second normal form D.third normal form
选项
答案 BCAAD
解析 在系统分析阶段，需要确定数据如何组织、存储和管理。数据结构是用于组织、存储和管理数据的一个框架。每个文件或表包含了关于人物、地点、事物和事件的数据。文件处理场景中存在的潜在问题之一是数据冗余，意味着两个或多个信息系统中相同数据存储在多个不同位置。

    在关系数据库管理系统（DBMS）中，相互链接的表格形成了一个统一的数据解耦股，可以大大提升数据质量和访问。实体联系图是一个模型，显示了系统实体之间的逻辑关系和交互。它提供了一个系统的全局视图和用于创建物理数据结构的蓝图。规范化是通过为数据库中的每个表分配特定的字段或属性来创建表设计的过程。表设计是在特定表或文件中确定字段并标识主键。三种范式构成了一个序列，其中第三范式代表了最好的设计，大部分与业务相关的数据库必须设计成这种形式。
转载请注明原文地址:https://www.tihaiku.com/congyezige/2398042.html
本试题收录于： 高级系统架构设计师题库软件水平考试初中高级分类

高级系统架构设计师

软件水平考试初中高级

相关试题推荐
随机试题
最新回复(0)