IS 410 TEST 1 VERIFIED STUDY GUIDE
Database - Answers - organized collection of logically related data
Data - Answers - stored representations of meaningful objects and events
Structured: numbers, text, dates
Unstructured: images, video, documents
Information - Answers - data processed to increase knowledge in the person using the
data
Metadata - Answers - Data that describes the properties (name, type, length,
description, source) and context of user data. Stored in structured or unstructured data.
For example, Class Roster: Name (Type/Length/Min/Max/Description/Source), ID
(Type/Length/Min/Max/Description/Source), Major
(Type/Length/Min/Max/Description/Source), GPA.
Entities (E-R)/Relationships/Relational Databases - Answers - Entities: Noun form
describing a person, place, object, event, or concept (Ex. UMBC: Student, courses,
teachers, classes). Composed of attributes.
Should be an object that has many instances and multiple attributes.
Relationships: Between entities; Usually one-to-many (1:M) or many-to-many (M:N)
Relational Databases: Database technology involving tables (relations) representing
entities and primary/foreign keys representing relationships.
*Data Driven vs. Process Driven Design - Answers - Data Driven is much more flexible,
adaptable and less expensive to maintain.
Business Rules - Answers - Are statements that define or constrain some aspect of the
business
Are derived from policies, procedures, events, functions
Assert business structure
Control/influence business behavior
Are expressed in terms familiar to end users
Are automated through DBMS software
A Good Business Rule is: - Answers - Declarative-what, not how
Precise-clear, agreed-upon meaning
Atomic-one statement
Consistent-internally and externally
Expressible-structured, natural language
Distinct-non-redundant
Business-oriented-understood by business people
A Good Data Name is - Answers - Related to business, not technical, characteristics
, Meaningful and self-documenting
Unique
Readable
Composed of words from an approved list
Repeatable
Written in standard syntax
E-R Model Constructs - Answers - Entities:
Entity instance-person, place, object, event, concept (often corresponds to a row in a
table)
Entity Type-collection of entities (often corresponds to a table)
SHOULD BE:
An object that has many instances, and multiple attributes.
SHOULD NO1T BE:
A user of the database system
An output of the database system (e.g., a report)
Relationships:
Relationship instance-link between entities (corresponds to primary key-foreign key
equivalencies in related tables)
Relationship type-category of relationship...link between entity types
Attribute-property or characteristic of an entity or relationship type (often corresponds to
a field in a table)
Attributes - Answers - Attribute-property or characteristic of an entity or relationship type
Classifications of attributes:
*Required* versus Optional
Simple versus (Composite) Attribute
Single-Valued versus {Multivalued Attribute}
Stored versus [Derived] Attributes
Identifier Attributes
Identifiers (Keys): - Answers - Identifier (Key)-an attribute (or combination of attributes)
that uniquely identifies individual instances of an entity type
Simple versus Composite Identifier
Candidate Identifier-an attribute that could be a key...satisfies the requirements for
being an identifier
Choose Identifiers that
Will not change in value
Will not be null
Avoid intelligent identifiers (e.g., containing locations or people that might change)
Substitute new, simple keys for long, composite keys
Relationships can have attributes - Answers - These describe features pertaining to the
association between the entities in the relationship
Database - Answers - organized collection of logically related data
Data - Answers - stored representations of meaningful objects and events
Structured: numbers, text, dates
Unstructured: images, video, documents
Information - Answers - data processed to increase knowledge in the person using the
data
Metadata - Answers - Data that describes the properties (name, type, length,
description, source) and context of user data. Stored in structured or unstructured data.
For example, Class Roster: Name (Type/Length/Min/Max/Description/Source), ID
(Type/Length/Min/Max/Description/Source), Major
(Type/Length/Min/Max/Description/Source), GPA.
Entities (E-R)/Relationships/Relational Databases - Answers - Entities: Noun form
describing a person, place, object, event, or concept (Ex. UMBC: Student, courses,
teachers, classes). Composed of attributes.
Should be an object that has many instances and multiple attributes.
Relationships: Between entities; Usually one-to-many (1:M) or many-to-many (M:N)
Relational Databases: Database technology involving tables (relations) representing
entities and primary/foreign keys representing relationships.
*Data Driven vs. Process Driven Design - Answers - Data Driven is much more flexible,
adaptable and less expensive to maintain.
Business Rules - Answers - Are statements that define or constrain some aspect of the
business
Are derived from policies, procedures, events, functions
Assert business structure
Control/influence business behavior
Are expressed in terms familiar to end users
Are automated through DBMS software
A Good Business Rule is: - Answers - Declarative-what, not how
Precise-clear, agreed-upon meaning
Atomic-one statement
Consistent-internally and externally
Expressible-structured, natural language
Distinct-non-redundant
Business-oriented-understood by business people
A Good Data Name is - Answers - Related to business, not technical, characteristics
, Meaningful and self-documenting
Unique
Readable
Composed of words from an approved list
Repeatable
Written in standard syntax
E-R Model Constructs - Answers - Entities:
Entity instance-person, place, object, event, concept (often corresponds to a row in a
table)
Entity Type-collection of entities (often corresponds to a table)
SHOULD BE:
An object that has many instances, and multiple attributes.
SHOULD NO1T BE:
A user of the database system
An output of the database system (e.g., a report)
Relationships:
Relationship instance-link between entities (corresponds to primary key-foreign key
equivalencies in related tables)
Relationship type-category of relationship...link between entity types
Attribute-property or characteristic of an entity or relationship type (often corresponds to
a field in a table)
Attributes - Answers - Attribute-property or characteristic of an entity or relationship type
Classifications of attributes:
*Required* versus Optional
Simple versus (Composite) Attribute
Single-Valued versus {Multivalued Attribute}
Stored versus [Derived] Attributes
Identifier Attributes
Identifiers (Keys): - Answers - Identifier (Key)-an attribute (or combination of attributes)
that uniquely identifies individual instances of an entity type
Simple versus Composite Identifier
Candidate Identifier-an attribute that could be a key...satisfies the requirements for
being an identifier
Choose Identifiers that
Will not change in value
Will not be null
Avoid intelligent identifiers (e.g., containing locations or people that might change)
Substitute new, simple keys for long, composite keys
Relationships can have attributes - Answers - These describe features pertaining to the
association between the entities in the relationship