mis exam two questions

in a data flow diagram a _____ is modeled using two horizontal lines

• data store

a ___ shows the scope of the system indicating which elements are inside and which are outside of the system 

• context diagram

a ___ is a DFD that represents a system major processes, data flows, and data store at a high level of detail

• level 0 diagram

true / false :  a data flow to a data store means retrieve and a data flow from a data store means change (rules)

• false

the concept of DFD ____ refers to whether or not the depiction of the system shown at one level of a nested set of DFDs is compatible with the depictions of the system shown, at other levels

• DFD consistency 

the most common format used for data modeling is ___ diagraming

• entity relationship diagram (er diagram)

an entity type (sometimes called an entity class) is a collection of ___ that share common properties or characters

• entities

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

sinks

a ternary relationship is a simultaneous relations among instances of ____ entity types 

• three

true / false : in an er diagram data entities are the same as source/sinks from data flow diagrams

• false

true / false : a super type is a generic entity type that has a relationship one or more types

• true

logical and _____ database design is typically performed in parallel with other system design steps

• physical 

a ____ is a an attribute or a combination of attributes whose value is unique across all occurrences of a relation

• primary key

a well-structured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies and is also known as a ____

• table 

what is the result of normalization ?

• every nonprimary key attribute depends on the whole primary key and nothing but the primary key

what areas of the sdlc cycle did theranos fail in

• planning | design | testing 

a source/sink in a DFD is represented by

• rectangle shape

what shows the system’s scope?

• context diagram

true / false : DFD’s evolve from general to detailed

• true

which is not a DFD component

• data program

data in motion is called

• data flow

a level-0 diagram represents

• major processes

true / false : a process can have only outputs

• false

a data flow can have

• one direction

a level-n diagram is generated from

• level-0 diagram

true / false : an associative entity contains attributes peculiar to the relationship

• true

a domain refers to

• attributes

which is an advanced DFD rule?

• inputs must product outputs

a binary relationship involves

• two entity types

a calculated field is derived from other fields

• true

the concept of DFD consistency refers to

• consistency

an advanced rule states

• inputs must produce outputs

true / false : data flow to a store means change

• true

a detailed logical representation is called

• e-r model

a ternary relationship involves

• three entity types

in a business process model, an event is modeled with

• oval

in a business process model, an activity is modeled with

• rectangle

business process diagram, participants who are external are modeled in different swimlanes but in the same pool

• false

true / false : an entity instance is a single occurance 

• true

a unary relationship involves

• one entity type