Question 1

An ________ model is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.
A)E-D
B)E-O
C)E-R
D)E-A

Accepted Answer

The Entity-Relationship (E-R) model is a logical representation of the entities, associations, and data elements for an organization or business area. The other answer choices are not commonly used modeling techniques in information systems.

Question 2

Each entity type in an E-R model is given a ________ because it represents a class or set,it is singular.
A)Class
B)Type
C)Name
D)Degree

Accepted Answer

Entities in an E-R model are named according to the class or set they represent. The name is typically singular and descriptive of the entity's characteristics. For example, a "customer" entity represents a class or set of individuals who purchase goods or services from a business.

Question 3

An entity ________ is described just once in a data model,whereas many ________ of that may be represented by data stored in the database.
A)Type; instances
B)Type; classes
C)Instance; types
D)Class; objects

Accepted Answer

In a data model, an entity type is described only once and it represents a collection of similar entities or instances that can be stored in the database. Therefore, the correct answer is A) Type; instances.

Question 4

Conceptual data modeling is not done in parallel with other requirements analysis and structuring steps during systems analysis.

Accepted Answer

Conceptual data modeling is typically an early step in the systems analysis process, often performed in parallel with other requirements analysis and structuring steps. It involves identifying and defining the high-level entities, relationships, and attributes relevant to the organization's information needs.

Question 5

The other deliverable from conceptual data modeling is a full set of entries about data objects that will be stored in the project dictionary,repository,or data modeling software.

Accepted Answer

Conceptual data modeling results in a full set of entries about data objects that will be stored in the project dictionary, repository, or data modeling software.

Question 6

A(n)________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.
A)Dimension
B)Attribute
C)Object
D)Entity

Accepted Answer

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. Dimensions refer to the ways in which entities are described or measured, attributes are characteristics of an entity, and objects are instances of entities.

Question 7

Event entity types should be named for the result of the ________,not the activity or process of the event.
A)Event
B)Class
C)Entity
D)Object

Accepted Answer

The entity type name should reflect the result of the event, such as "Order" for an event that results in a purchase order, rather than the activity or process of the event, such as "Purchase" or "Buying". Therefore, option A (Event) is the best choice.

Question 8

The process of conceptual data modeling begins with developing a conceptual data model for the system being replaced,if a system already exists.This is essential for planning the conversion of the current files or database into the database of the new system.

Accepted Answer

Developing a conceptual data model for the existing system is important for planning the conversion process.

Question 9

A common mistake many people make when they are just learning to draw E-R diagrams,especially if they already know how to do data flow diagramming,is to confuse data entities with ________ and relationships with data flows.
A)Classes
B)Sinks
C)Relationships
D)Attributes

Accepted Answer

In data flow diagrams, "sinks" refer to external entities or destinations for data, which can be confused with data entities in E-R diagrams.

Question 10

During requirements structuring,a ________ model represents conceptual data requirements for a particular system.
A)Business
B)Project
C)Data
D)Relationship

Accepted Answer

During requirements structuring, a data model is used to represent the conceptual data requirements for a particular system. This includes understanding the data entities needed, the relationships between them, and the attributes associated with each entity. A business model focuses more on the overall goals and processes of the organization, while a project model is more focused on timelines, budgets, and resources. A relationship model may be used to represent specific types of relationships between data entities, but it would not necessarily cover all conceptual data requirements for the system.

Question 11

The most common format used for data modeling is ________ diagramming.
A)Entity-class
B)Entity-object
C)Entity-subject
D)Entity-relationship

Accepted Answer

Entity-relationship diagramming is the most common format used for data modeling. It is used to visually represent the entities, attributes, and relationships between them in a database. Other options, such as entity-class or entity-object, may also be used, but they are not as prevalent as entity-relationship diagramming. Entity-subject is not a valid format for data modeling.

Question 12

The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.

Accepted Answer

The primary deliverable from the physical data modeling step is a detailed database schema, not an E-R (Entity-Relationship) diagram, which is a result of the conceptual data modeling step.

Question 13

Describe conceptual data modeling.How is it used? Describe the process.

Accepted Answer

The answer of Describe conceptual data modeling.How is it used?...

Question 14

Why do some systems developers believe the data model is the most important part of IS requirements?

Accepted Answer

The answer of Why do some systems developers believe the...

Question 15

A physical data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

Accepted Answer

A physical data model is specific to the database management system and includes details such as how data is stored, including paths, indexes, and constraints, making it dependent on implementation considerations.

Question 16

An entity ________ is a collection of entities that share common properties or characteristics.
A)Object
B)Type
C)Subject
D)Relationship

Accepted Answer

A type is a collection of entities that share common properties or characteristics. An object refers to a single instance of an entity. Subject and relationship are not related to this concept.

Question 17

An entity ________ is a single occurrence of an entity type.
A)Instance
B)Object
C)Attribute
D)Class

Accepted Answer

An entity instance is a single occurrence of an entity type. In database design, an entity represents a person, place, thing or event that exists in the real world and is relevant to the business. An entity instance is a specific occurrence of that entity. For example, a "customer" entity type could have instances such as "John Smith" or "Jane Doe".

Question 18

On what basis are objects referenced,selected,qualified,sorted,and categorized?
A)Attributes and secondary keys
B)Entities
C)Primary keys
D)Index

Accepted Answer

Objects are typically referenced, selected, qualified, sorted, and categorized based on their attributes, which can be used as criteria for filtering and organizing data. Secondary keys are also a useful tool for searching and sorting objects in a database. Entities and primary keys are important concepts within database design, but they are not directly relevant to the process of referencing and sorting objects. An index is a data structure used to optimize searches and speed up queries, but it is not itself a basis for referencing or selecting objects.

Question 19

What unique characteristic(s)distinguish(es)each object from other objects of the same type?
A)Secondary key
B)Primary key
C)Composite key
D)Index

Accepted Answer

Primary key is a unique identifier for each record in a table, distinguishing it from other records. The other options (secondary key, composite key, index) may also help distinguish records, but they are not as fundamental as the primary key.

Question 20

A(n)________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.
A)Conceptual
B)Physical
C)Logical
D)Entity

Accepted Answer

A conceptual data model captures the overall structure of an organization's data, independent of any specific technology or implementation considerations. It focuses on the high-level entities and relationships between them, and is typically used to communicate with stakeholders and business users about the data requirements of a system. Physical data models, on the other hand, are specific to a particular database management system and include details like data types, storage structures, and indexing strategies. Logical data models bridge the gap between conceptual and physical models by defining the data at a more detailed level than a conceptual model, but without the implementation-specific details of a physical model. Entity models are a type of conceptual data model that focuses specifically on the entities and relationships between them.

Quiz 8: Structuring System Data Requirements

An ________ model is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.

Each entity type in an E-R model is given a ________ because it represents a class or set,it is singular.

An entity is described just once in a data model,whereas many of that may be represented by data stored in the database.

Conceptual data modeling is not done in parallel with other requirements analysis and structuring steps during systems analysis.

The other deliverable from conceptual data modeling is a full set of entries about data objects that will be stored in the project dictionary,repository,or data modeling software.

A(n) ________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.

Event entity types should be named for the result of the ________,not the activity or process of the event.

The process of conceptual data modeling begins with developing a conceptual data model for the system being replaced,if a system already exists.This is essential for planning the conversion of the current files or database into the database of the new system.

A common mistake many people make when they are just learning to draw E-R diagrams,especially if they already know how to do data flow diagramming,is to confuse data entities with ________ and relationships with data flows.

During requirements structuring,a ________ model represents conceptual data requirements for a particular system.

The most common format used for data modeling is ________ diagramming.

The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.

Describe conceptual data modeling.How is it used? Describe the process.

Why do some systems developers believe the data model is the most important part of IS requirements?

A physical data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

An entity ________ is a collection of entities that share common properties or characteristics.

An entity ________ is a single occurrence of an entity type.

On what basis are objects referenced,selected,qualified,sorted,and categorized?

What unique characteristic(s) distinguish(es) each object from other objects of the same type?

A(n) ________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.