Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
26 Cards in this Set
- Front
- Back
Define Supertype and give an example
|
a generic entity that has a relationship with one or more subtypes
(example: Employee) |
|
Define Subtype and give an example
|
a subgrouping of a supertype entity that is meaningful to an organization
(example: Hourly Employee) |
|
What are the Two Processes to Develop Supertype/Subtypes
|
Generalization
The process of defining a more general entity type from a set of more specialized entity types A “bottom-up” approach Specialization The process of defining one or more subtypes of a general entity based on distinguishing attri-butes or relationships A “top-down” approach |
|
What are Business rules
|
A statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence the behavior of the business.
|
|
Why are business rules good
|
Allow faster application development
Reduce system maintenance Provide faster response to business changes Promote ease of use of database applications |
|
A Good Data Name Is
|
Related to business, not technical, characteristics
Meaningful and self-documenting Unique Readable Composed of words from an approved list Repeatable Follows standard syntax |
|
What Should an Entity Be and not be?
|
SHOULD BE:
An object that will have many instances in the database An object that will be composed of multiple attributes An object that we are trying to model SHOULD NOT BE: A user of the database system An output of the database system (e.g., a report) |
|
What is an attribute
|
property or characteristic of an entity or relationship type
|
|
What is an Identifier (Key)
|
an attribute (or combination of attributes) that uniquely identifies individual instances of an entity type
|
|
What is an Associative Entity
|
combination of relationship and entity
|
|
What are Strong entities
|
exist independently of other types of entities
has its own unique identifier identifier underlined with single line |
|
What are Weak entities
|
dependent on a strong entity (identifying owner)…cannot exist on its own
does not have a unique identifier (only a partial identifier) partial identifier underlined with double line entity box has double line |
|
When should a relationship with attributes instead be an associative entity?
|
All relationships for the associative entity should be many
The associative entity could have meaning independent of the other entities The associative entity preferably has a unique identifier, and should also have other attributes The associative entity may participate in other relationships other than the entities of the associated relationship Ternary relationships should be converted to associative entities |
|
What is an Enterprise Data Model
|
an integrated view of the data produced and consumed across an entire organization. It incorporates an appropriate industry perspective.
|
|
What is Top-Down Planning
|
A methodology that attempts to gain a broad understanding of the information system needs of the entire organization
|
|
What is Bottom-Up Planning
|
A methodology that identifies and defines IS development projects based upon solving operational business problems or taking advantage of business opportunities
|
|
What is an entity
|
a person, place, object, event or concept about which an organization wishes to maintain data.
|
|
What is an association
|
a relationship between entities whose naming and notation capture fundamental business rules
|
|
What is a database
|
an organized collection of logically related data.
|
|
What is data
|
facts, text, images, sound, and video segments that have meaning in the users’ environment.
Structured: Unstructured: |
|
What is metadata data
|
data about data
|
|
What are Disadvantages of File Processing
|
Program-Data Dependence
All programs maintain metadata for each file they use Duplication of Data Different systems/programs have separate copies of the same data Limited Data Sharing No centralized control of data Lengthy Development Times Programmers must design their own file formats Excessive Program Maintenance 80% of information systems budget |
|
What is good about the DATABASE Approach
|
Central repository of shared data
Data is managed by a controlling agent Stored in a standardized, convenient form Requires a Database Management System (DBMS) form. |
|
What is a Database Management system
|
A software system that is used to create, maintain, and provide controlled access to user databases
|
|
What is a Repository
|
centralized storehouse of metadata
|
|
What is master data management
|
An approach to dealing with data duplication.
|