IS 410 Exam 1 Review Rated 100% Correct!!
Data
stored representations of meaningful objects and events
Information
data processed to increase knowledge in the person using the data
Database
organized collection of logically related data
Metadata
data that describes the properties and context of data (data about data)
Database Management System
A software system that is used to create, maintain, and provide controlled access to
user databases
External schema
The view of end users
Conceptual schema
the view of data architect/administrator
Internal schema
the underlying design and implementation
ER model
detailed logical representation of the data for an organization
ER diagram
a graphical representation of an ER model
Term
word or phrase with specific meaning for the business
Fact
a statement about an association between two or more terms
Entity
a person, a place, an object, an event or a concept in the user environment which the
organization wishes to maintain data
Attribute
property or characteristic of an entity type that is of interest
Relationship
An association representing an interaction among instances of different entities that
must be stored in the database
Business rules
Statements that define or constrain some aspect of the business logic
Subtype
A subgroup of the entities in an entity type which has attributes that are distinct from
those in other subgroups
Supertype
An generic entity type that has a relationship with one or more subtypes
Generalization
The process of defining a more general entity type from a set of more specialized entity
types. BOTTOM-UP
Specialization
Data
stored representations of meaningful objects and events
Information
data processed to increase knowledge in the person using the data
Database
organized collection of logically related data
Metadata
data that describes the properties and context of data (data about data)
Database Management System
A software system that is used to create, maintain, and provide controlled access to
user databases
External schema
The view of end users
Conceptual schema
the view of data architect/administrator
Internal schema
the underlying design and implementation
ER model
detailed logical representation of the data for an organization
ER diagram
a graphical representation of an ER model
Term
word or phrase with specific meaning for the business
Fact
a statement about an association between two or more terms
Entity
a person, a place, an object, an event or a concept in the user environment which the
organization wishes to maintain data
Attribute
property or characteristic of an entity type that is of interest
Relationship
An association representing an interaction among instances of different entities that
must be stored in the database
Business rules
Statements that define or constrain some aspect of the business logic
Subtype
A subgroup of the entities in an entity type which has attributes that are distinct from
those in other subgroups
Supertype
An generic entity type that has a relationship with one or more subtypes
Generalization
The process of defining a more general entity type from a set of more specialized entity
types. BOTTOM-UP
Specialization
