39 NESMA 具有编号名称开始结束日期的表 案例

39 TABLE WITH CODE, NAME, START- AND END-DATE（具有编号名称开始结束日期的表）

问题描述

对于物品使用颜色的登记，系统具有包含以下信息的表格：

• 颜色编号
• 颜色名称
• 开始日期
• 结束日期
  该表通过屏幕进行维护，用户可以在其中添加、删除或修改新颜色。
  这个表是如何归类？

讨论

这里有两种可能：

1. 这个实体识别为一个FPA表
2. 这个实体识别为一个内部或外部逻辑文件（可能与其他实体类型一起使用）

具有颜色编号、颜色名称、开始日期和结束日期的表似乎不属于FPA表，因为属性不相似。在这种情况下，这将导致表成为逻辑文件（可能与其他实体类型一起）。

然而，需要回答的问题是：开始日期和结束日期是技术性的（例如，时间戳）还是功能性的（比如，将来可以更改颜色）。

答案

如果添加开始日期和结束日期纯粹是技术性的，则该表将作为FPA表（作为FPA表格ILF的一部分）进行估价。

如果开始日期和结束日期的添加是功能性的，则该表应作为内部或外部逻辑文件（或作为其一部分）进行评估。在这种情况下，维护功能也必须单独评估。

Problem description

For the registration of used colors for articles, a system has a table containing the following information:

• Color number
• Color name
• Start date
• End date

The table is maintained through a screen in which the user can add, delete, or modify new colors.

How is this table classified?

Discussion

There are two possibilities:

1. The entity is recognized as an FPA-table
2. The entity is recognized as internal or external Logical File (possibly with other entity types)

The table with color number, color name, start and end date does not appear to fall under the FPA-tables because the attributes are not similar. This would give rise to the table as Logical File (possibly along with other entity types) in this case.

However, the question that needs to be answered is: are the start- and end-dates technical in nature (for example, a time-stamp) or are these functional in nature (for example, colors can be changed in the future).

Solution

If the addition of the start and end dates are purely technical in nature, the table will then be valued as an FPA-table (as part of the FPA-tables-ILF).

If the addition of the start and end dates is functional, the table should be valued as internal or external Logical File (or as part of). In this case, the maintenance functions must also be valued separately.