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 data quality 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
第1题:B
第2题:C
第3题:A
第4题:A
第5题:D
第1题:
在系统分析阶段,需要确定数据如何组织、存储和管理。数据结构是用于组织、存储和管理数据的一个框架。每个文件或表包含了关于人物、地点、事物和事件的数据。文件处理场景中存在的潜在问题之一是数据冗余,意味着两个或多个信息系统中相同数据存储在多个不同位置。
在关系数据库管理系统(DBMS)中,相互链接的表格形成了一个统一的数据结构,可以大大提升数据质量和访问。实体联系图是一个模型,显示了系统实体之间的逻辑关系和交互。它提供了一个系统的全局视图和用于创建物理数据结构的蓝图。规范化是通过为数据库中的每个表分配特定的字段或属性来创建表设计的过程。表设计是在特定表或文件中确定字段并标识主键。三种范式构成了一个序列,其中第三范式代表了最好的设计,大部分与业务相关的数据库必须设计成这种形式。
A:data entity(数据实体)
B:data structure(数据结构)
C:file collection(文件收集)
D:data definition(数据定义)
A:data integrity(数据完整性)
B:the rigid data structure(刚性数据结构)
C:data redundancy(数据冗余)
D:the many-to-many relationship(多对多关系)
A:entity-relationship diagram(实体联系图)
B:data dictionary(数据字典)
C:database schema(数据库架构)
D:physical database model(物理数据库模型)
A:Normalization(规范化)
B:Replication(复制)
C:Partitioning(分区)
D:Optimization(优化)
A:standard notation form(标准表示形式)
B:first normal form(第一范式)
C:second normal form(第二范式)
D:third normal form(第三范式)
第2题:
第3题:
第4题:
第5题: