Question 1

If the logical data model contains attribute values that depend on an attribute that is not the identifier,then it is in _____.

Accepted Answer

Second normal form requires that all non-key attributes are dependent on the entire key. If an attribute value depends on some part of the key, it violates second normal form. Therefore, if the attribute values depend on an attribute that is not the identifier, it is in Second normal form.

Question 2

A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in _____ normal form.

Accepted Answer

A logical data model in second normal form (2NF) does not have repeating fields and ensures that all non-key fields are dependent on the whole primary key, eliminating partial dependency.

Question 3

When normalizing data models,if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:

Accepted Answer

Moving from a state where an entity has attributes with multiple values (a non-normalized form) to a state where each attribute has a single value for a single instance of an entity is the process of achieving 1st Normal Form (1NF). This involves eliminating repeating groups or arrays in a table, ensuring that each column contains atomic values.

Question 4

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key,which step of normalization is being performed?

Accepted Answer

This is the definition of Second Normal Form (2NF), which requires that all non-prime attributes are fully functionally dependent on the primary key. This step is taken after achieving First Normal Form, where all attributes must be atomic, and it addresses the issue of partial dependency in composite primary keys.

Question 5

Omar has a model with 85 entities.He can:

Accepted Answer

Grouping the entities into related subject areas would improve the organization and clarity of the model. This would make it easier to understand and communicate about the different parts of the system being modeled. The other options (A, C, D, and E) do not address the organization or clarity of the model in the same way.

Question 6

A(n)_____ entity cannot exist without the presence of another entity and is normally on the "many" end of a relationship or has an identifier that is based on another entity's attribute.

Accepted Answer

A dependent entity cannot exist without the presence of another entity, meaning it relies on another entity to exist in a relationship. It is also typically on the "many" end of the relationship, indicating that there are multiple instances of the dependent entity related to a single instance of the other entity. Additionally, the dependent entity may have an identifier that includes an attribute from the related entity.

Question 7

Independent entities are:

Accepted Answer

Independent entities refer to those entities that can exist without the help of another entity. They have their own attributes and can sustain their livelihood without being associated with any other entity.

Question 8

The first step to building an Entity Relationship Diagram is to _____

Accepted Answer

The first step in building an Entity Relationship Diagram is to identify the entities. This involves identifying the objects or concepts about which data is being collected or stored. Once the entities are identified, the relationships between them can be determined and attributes can be identified. Data flows, processes, and data stores are elements of a higher-level diagram, such as a Data Flow Diagram.

Question 9

A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.

Accepted Answer

An independent entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity. Dependent entities are entities at the "many" end of a relationship that depend on the existence of the independent entity. Incomplete entities have missing or null values and cannot be uniquely identified. Intersection and non-identifying entities are not relevant to this definition.

Question 10

What type of process is creating an ERD?

Accepted Answer

Creating an ERD is an iterative process, as it involves refining and iterating through the steps of identifying entities, attributes, and relationships until a complete and accurate representation of the data requirements are achieved. It is not a well-defined, sequential or user-defined process, nor is it limited to a specific number of steps.

Question 11

The two methods to validate that an ERD is well formed are _____.

Accepted Answer

Normalization and balancing with process models are the two methods to validate that an ERD is well-formed. Renaming theory is not a valid method to validate an ERD, and following design guidelines created by Chen is only one of the methods to create a well-formed ERD, not to validate it.

Question 12

Andrew,an analyst for PaxMedia Inc. ,has just learned that the business rules for a system he has been working on have changed.This means that _____.

Accepted Answer

If the business rules for a system change, it is likely that the entity relationship diagram (ERD) components will also need to be changed to reflect the new rules. ERD data models are not "frozen" and can be modified as needed. It is unlikely that Andrew would be reassigned to a different project or that the project would need to be scrapped and restarted. It is also not necessary to put the ERD data model on hold while creating new data flow diagram (DFD) diagrams, as these are separate components of system design.

Question 13

Anthony is working on the cardinality of doctors and patients in a large urban hospital.With the large number of doctors with varying specialties and patients that may have more than one aliment,he thinks the relationship might be noted as:

Accepted Answer

The relationship between doctors and patients in a large urban hospital is "Many to many" because a single doctor can have multiple patients, and a single patient can have multiple doctors, especially considering varying specialties and multiple ailments.

Question 14

In adding attributes to an ERD,which of the following might NOT be a good resource for attributes?

Accepted Answer

The answer of In adding attributes to an ERD,which of...

Question 15

The last step in creating basic ERD's is to:

Accepted Answer

Identifying relationships is the final step in creating basic ERD's. This step involves analyzing the identified entities and determining how they are related to each other.

Question 16

Balance occurs between DFDs and ERDs when the data stores _____

Accepted Answer

Balance occurs between Data Flow Diagrams (DFDs) and Entity-Relationship Diagrams (ERDs) when the data stores in DFDs can be equated to entities on the ERD, and when these entities are referred to by data stores on the DFD. This ensures consistency and coherence between the process view (DFD) and the data view (ERD) of the system.

Question 17

In creating ERD's,which would most likely NOT be a source for entities?

Accepted Answer

Cost/benefit reports are financial documents and do not provide information on entities, while use cases, level 0 DFD diagrams, external entities, and data flows all provide relevant information for identifying entities in an ERD.

Question 18

If the logical data model does not contain attributes that have repeating values it is in _____.

Accepted Answer

First normal form requires that there be no repeating groups or multivalued attributes in a relation. Therefore, if the logical data model does not contain attributes with repeating values, it is in first normal form.

Question 19

Data models can be either logical or physical.

Accepted Answer

Data models can be either logical or physical, or a combination of both.

Question 20

During the analysis phase logical data models are created.

Accepted Answer

During the analysis phase of the software development life cycle, logical data models are created to represent the relationships and attributes of the data required for the system. This helps to ensure a clear understanding of the data requirements before moving onto the design phase.

Quiz 6: Data Modeling