WorksheetsFINAL EXAM - Info Mgt 2022
Total questions: 50
Worksheet time: 38mins
What is the organized collection of logically related data?
Database
Information
Metadata
What are stored representations of meaningful objects and events?
Information
Database
Data
Which of these is processed data to increase knowledge in the person using the data?
Database
Information
Metadata
What is the data that describes the properties and context of the user data?
Information
Database
Metadata
The process to turn data into useful information that managers can use for decision making and interpretation.
Graphical Display
Graphics
Charts
Point of which different system/programs have separate copies of the same data
Repeatable
Dataredundancy
Duplication
An attribute combination of attributes that uniquely identify individual instances of an entity
Primary Key
Foreign Key
Identifier
Which relationship is modeled as lines between?
Relationship
Relation Type
Cardinality
What is the combination of relationship and entity?
Associative Entity
Associative Attribute
Associative Cluster
What entity in the relationship will have exactly one related entity?
Mandatory One
Many to Many
Optional One
An entity on one side of the relationship can have many related entities, but an entity on the other side will have a maximum of one related entity.
One to Many
Many to Many
Mandatory Many
Entities on both sides of the relationship can have many related entities on the other side are:
Optional Many
Many to Many
Mandatory Many
Which identifiers underlined with a single line
Strong Entity
Weak Entity
Associate Entity
What is the other term for a partial identifier that underlined with double line?
Weak Entity
Strong Entity
Associative Entity
Iterative process breaking system description into finer and finer detail is a __________
Functional Decomposed
Planning Matrix
ER Model
Detailed, the well-planned development process
Data Gathering
Prototyping
SDLC
A cursory attempt at conceptual data modeling
Data Gathering
Prototyping
SDLC
Software tools providing automated support for systems development
CASE
MySQL
Oracle
Model components that can be purchased, customized and assembled info full-scale data models
Package Data Model
Data Model
Enterprise Data Model
Which of these can be determined from business-function/data entity matrices
External Schema
Internal Schema
Conceptual Schema
In this schema diagrams and ER-models are described.
External Schema
Internal Schema
Conceptual Schema
Logical & Physical structure is well defined in this schema
Internal Schema
External Schema
Conceptual Schema
What statement that defines or constrain some aspect of the business
Cardinality
Business Rule
Relationship
Which of these are NOT characteristics of a good business rule
Redundant
Precise
Declarative
Which of these is a good characteristic of a business rule
Consistent
Redundant
Inexpressible
This is understood by business people
Business Oriented
Business Rule
Business Guide
Which of these is NOT an example of a good Data Name?
Readable
Technique
Unique
This is a word or phrase with a specific meaning:
Term
Fact
Data Name
This is the association between two or more terms:
Fact
Term
Data Name
What database term is defined as a person, people, palace, object or event?
Entity
Cardinality
Relation
What rule states that any foreign key value must match a primary key value in the relation of the one side?
Referential Integrity
Overlapping
Disjoint
What kind of business rule is comes from another knowledge, often in the form of a formula using attribute values?
Derivation
Assertion
Action Assertion
Set of one or more entity types and associated relationships grouped into a single abstract entity type is called _______
Subtype
Supertype
Entity Cluster
What is an example of a composite attribute whose subparts pertain to different subtypes? Each subpart contains a Boolean value to indicate whether or not the instance belongs to the associated subtype.
Disjoint
Overlapping
Clustering
Which of these is a simple attribute with alternative values to indicate the possible subtypes
Discriminator
Overlapping
Disjoint
Which rule expresses a static structure includes attributes, relationships, and definitions
Structural Assertion
Action Assertion
Assertion
These are identifiers that enable a dependent relation to refer to its parent relation
Enterprise Key
Primary Key
Foreign Key
Which of the following is the unique identifier of the relation?
Primary Key
Foreign Key
Enterprise Key
What is a two-dimensional table of data that consists of rows (records) and columns (attribute or field)
Relationship
Relation
Entity
What kind of rule express constraints/control of organizational actions
Derivation
Structural Assertion
Action Assertion
What attribute of the supertype determine the target subtypes
Disjoint
Discriminator
Clustering
What is a process of defining a more general entity from a set of more specialized entity types?
Generalization
Specialization
Total
What is a process of defining one or more subtypes of the supertype and forming a supertype/subtype relationships
Generalization
Specialization
Partial
Which of these generic entity type has a relationship with one or more subtypes
Supertype
Subtype
Subgrouping
Whether an instance of a supertype must also be a member of at least one subtype
Disjointness
Completeness
Overlapping
What is the instance of a subtype and also an instance of the supertype?
Overlap
Disjoint
Discriminator
Whether an instance of a supertype may simultaneously be a member of two (or more) supertype
Overlapping
Completeness
Disjointness
An instance of the supertype can be only one of the subtypes
Disjointness
Completeness
Overlapping
What kind of subgrouping of entities in an entity type has attributes distinct from those in other subgroupings?
Subtype
Supertype
Disjoint
An instance of the supertype could be more than one of the subtypes
Overlap
Disjoint
Discriminator
