Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?A) The value of the key must uniquely identify every row in the relation.
B) The key should serve as a foreign key in at least two other relations.
C) The key must be a composite of a primary key and a secondary key.
D) The key should be an intelligent key.
E) The key should allow for null values.
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.
Q:
The goal of conceptual data modeling is to capture as much of the meaning of data as possible.
Q:
Relationships are labeled with verb phrases.
Q:
A repeating group is a set of two or more multivalued attributes that are logically related.
Q:
Analysts should consider substituting single-attribute surrogate keys for large composite keys.
Q:
When selecting an identifier, one should choose a candidate key that will not change its value over the life of each instance of the entity type.
Q:
A faculty identification number could be used as an identifier.
Q:
An entity instance is a single occurrence of an entity type.
Q:
In order to determine the integrity rules, minimum and maximum cardinality, and time dimensions of data, an analyst might ask, "Are values for data characteristics limited in any way?"
Q:
In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"
Q:
The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship (E-R) diagrams.
Q:
Data on a customer form could be represented on a data-flow diagram as a data flow.
Q:
A primitive level data-flow diagram is the first deliverable produced during requirements structuring.
Q:
Structured analysis techniques, such as data-flow diagramming, can help companies avoid misunderstanding how existing systems will have to work with the new system and incorrect specifications for necessary data, forms, and reports.
Q:
When you believe that you have shown each business form or transaction, computer screen, and report as a single data flow, you have probably reached the:
A) level-0 diagrams.
B) ternary-level diagrams.
C) primitive data-flow diagrams.
D) secondary-level diagrams.
E) context-level diagrams.
Q:
If an input from a source appears on a level-0 diagram, it must:
A) appear on the context diagram.
B) be connected to a data flow.
C) be connected to a sink.
D) be connected to a data store.
E) be connected to two entities.
Q:
Which of the following is a true statement regarding data flows?
A) A data flow to a data store means retrieve or use.
B) A data flow from a data store means update.
C) A data flow may have double-ended arrows.
D) A data flow represents data at rest.
E) A join in a data flow means that exactly the same data come from any of two or more different processes, data stores, or sources/sinks to a common location.
Q:
Which of the following is true regarding the context diagram?
A) The process symbol is labeled "0."
B) The context diagram contains two processes.
C) Data stores must be shown on the context diagram.
D) The internal workings of the system are shown on the context diagram.
E) The context diagram organizes the processes in a tree-like structure.
Q:
A square on a data-flow diagram represents a sink or a:
A) data flow.
B) data store.
C) process.
D) predecessor.
E) source.
Q:
The shape of a data-flow (DFD) diagramming process is a(n):
A) arrow.
B) square.
C) rectangle.
D) rounded rectangle.
E) open box.
Q:
A supplier of auto parts to your company would be represented on a data-flow diagram as a:
A) process.
B) source.
C) data flow.
D) data store.
E) relationship.
Q:
Data contained on a customer order form would be represented on a data-flow diagram as a:
A) process.
B) data flow.
C) source.
D) sink.
E) relationship.
Q:
One of the primary purposes of a DFD is to represent time, giving a good indication of whether data flows occur constantly in real time, once a day, or once a year.
Q:
A data flow repository entry would include the composition or list of data elements contained in the data flow.
Q:
DFD cohesion means your DFDs include all of the necessary components for the system you are modeling.
Q:
A process has a verb label.
Q:
More than one data flow noun phrase can appear on a single arrow as long as all of the flows on the same arrow move together as one package.
Q:
On a data-flow diagram, a rectangle with the right vertical line missing represents a data store.
Q:
On a data-flow diagram, a diamond represents a process.
Q:
Briefly identify and describe the participants of a JAD session.