首页
登录
从业资格
During the systems analysis phase ,you m
During the systems analysis phase ,you m
最全题库
2022-08-02
81
问题
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://tihaiku.com/congyezige/2398042.html
本试题收录于:
高级系统架构设计师题库软件水平考试初中高级分类
高级系统架构设计师
软件水平考试初中高级
相关试题推荐
Traditionalstructuredanalysistechniqu
Traditionalstructuredanalysistechniqu
Systemanalysisistraditionallydoneto
Systemanalysisistraditionallydoneto
结构化分析(StructuredAnalysis,SA.是面向数据流的需求分析
Systemanalysisistraditionallydoneto
CDMAforcellularsystemscanbedescrib
CDMAforcellularsystemscanbedescrib
CDMAforcellularsystemscanbedescrib
CDMAforcellularsystemscanbedescrib
随机试题
Childrenhavetheirown【C1】______inplayinggames.Theyseldomneeda【C2】___
Nobigdevelopedcountryhascomeoutoftheglobalrecessionlookingstrong
[originaltext]W:2millionhighschoolseniorsaregearingupthisfalltoappl
对于长期销售增长企业,()对于销售收入增长显得非常重要。A.科学技术 B
下列属于“竹”类乐器的是( )。A.磬 B.骨笛 C.箫 D.轧筝
关于董事会席位条款,以下表述错误的是A.董事会席位条款会约定董事会的席位构成
正常人精液中的异常精子应小于A.20%B.30%C.40%D.50%E.60%
2016年,A市旅游服务价值年值比农林牧渔业总产值年值多:A.494.46亿
医疗保健机构依法开展产前诊断的,必须符合卫生部规定的条件和技术标准,并经县级以上
某甲委托某乙去采购劣质钢材用于工程建设,则对于这种代理行为,说法正确的是()。A
最新回复
(
0
)