What type of keys should never be included in the Conceptual Level Model?

Question

BlackTom AI · Accepted Answer

When evaluating what type of keys should never be included in the Conceptual Level Model, it helps to recall the purpose of each key type in database design and how the conceptual model differs from the logical and physical levels.
Option 1: Foreign Keys. In the conceptual model, foreign keys are generally not specified because this level focuses on the data entities and their relationships abstractly, without tying them to specific table-level implementation details. The inclusion of foreign keys is more appropriate for the logical or physical models where table-to-table relationships are defined.
Option 2: Composite Keys. A composite key is a key composed of multiple attributes. While the conceptual model can discuss the existence of relationships that require unique identification, it typically avoids enforcing multi-attribute key constraints at the conceptual level. The explicit definition of a composite key is more aligned with the logical data model when mapping entities to relational tables.
Option 3: Primary Keys. Primary keys identify records within a table, which is a Level more concrete than the conceptual model. Since the conceptual model abstracts away table structures, showing primary keys is generally avoided. They are introduced later when moving to the logical/physical design where tables and keys are defined.
Option 4: Surrogate Keys. Surrogate keys are artificial keys introduced to uniquely identify records, and they are a design choice associated with the logical or physical design layers rather than the conceptual schema. The conceptual model emphasizes natural relationships and attributes rather than surrogate identifiers, so surrogate keys are not part of the conceptual level.
In summary, all of these options reflect constraints or identifiers that are typically defined beyond the conceptual level, but surrogate keys are particularly characteristic of the logical/physical design decisions rather than the high-level conceptual model, which is why they are the ones highlighted as not belonging in the Conceptual Level Model.

IDBF001 Tutorial Quiz 3 |LA003 - Requires Respondus LockDown Browser

What type of keys should never be included in the Conceptual Level Model?

查看解析

登录即可查看完整答案

类似问题

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

Under the assumptions used in cost-volume-profit analysis, as the activity increases:

The CVP and break-even analysis are supported by a range of important assumptions. Which of the following is not an assumption of the CVP:

The break-even point is that at which:

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单