IS 410 Exam 1 Study Guide Questions With Correct
Answers.
Database
An organized collection of logically related data
Data
Stored representations of objects
and events that have meaning
and importance in the user's
environment
Information
Data that have been processed
in such a way as to increase the
knowledge of the person who uses
the data.
Metadata
Data that describe the properties of other data
Raw Data
Not structured, won't make sense when you look at it.
Raw data into meta data
Happens when you identify properties.
Data model
Graphical systems used to capture the nature and relationships among data.
DBMS (Database Management System)
A software system that is used to create, maintain, and provide controlled access to
user databases.
RDBMS (Relational Database Management System)
manages data as a collection
of tables in which all data
relationships are represented by
common values in related tables
Flat file
A single, two-dimensional table of data elements
DR
disaster recovery options
Project manager
oversees assigned projects, includin g
Business analyst
nontechnical, go out to market, collect business requirements, ask for size of data,
#apply #size info #Repost/use of information #confidentiality info #types reg
Components of the DB Project
- Database admin
- Database developer
- Database architect
- Database tech
, Software Development Life Cycle (SDLC)
- Planning
- Analysis
- Design
- Implementation
- Maintenance
Spiral
SDLC goes and repeats itself over and over again
Waterfall
Step by step method of SDLC
Agile
overlapping of one step into another step
ERD
Entity Relationship Diagram, and is a graphical representation
Actual data is an entity, not a user
Entities
- Noun form describing a person, place, object, event, or concept
- Composed of attributes
Relationships
- Between entities
- Usually one-to-many or many-to-many, but can also be one-to-one
Data models
- Graphical diagram capturing nature and relationship of data
- Enterprise Data Model - high-level entities and relationships for the organization
- Project Data Model - more detailed view, matching data structure in database or data
warehouse
Planning
Preliminary understanding of business situation. Enterprise model and conceptual data
modeling
Analysis
Thorough analysis of business situation, leading to functional requirements. Detailed
conceptual data modeling.
Design
Logical and physical database design, to develop technology and organization
Implementation
Writing programs, building databases, testing, installing, training, and documenting
Maintenance
Monitoring, repairing, and enhancing
Attributes
Properties or characteristics of an entity or relationship type (often corresponds to a field
in a table)
A good business rule is:
Declarative-what, not how
Precise-clear, agreed-upon meaning
Atomic-one statement
Consistent-internally and externally
Answers.
Database
An organized collection of logically related data
Data
Stored representations of objects
and events that have meaning
and importance in the user's
environment
Information
Data that have been processed
in such a way as to increase the
knowledge of the person who uses
the data.
Metadata
Data that describe the properties of other data
Raw Data
Not structured, won't make sense when you look at it.
Raw data into meta data
Happens when you identify properties.
Data model
Graphical systems used to capture the nature and relationships among data.
DBMS (Database Management System)
A software system that is used to create, maintain, and provide controlled access to
user databases.
RDBMS (Relational Database Management System)
manages data as a collection
of tables in which all data
relationships are represented by
common values in related tables
Flat file
A single, two-dimensional table of data elements
DR
disaster recovery options
Project manager
oversees assigned projects, includin g
Business analyst
nontechnical, go out to market, collect business requirements, ask for size of data,
#apply #size info #Repost/use of information #confidentiality info #types reg
Components of the DB Project
- Database admin
- Database developer
- Database architect
- Database tech
, Software Development Life Cycle (SDLC)
- Planning
- Analysis
- Design
- Implementation
- Maintenance
Spiral
SDLC goes and repeats itself over and over again
Waterfall
Step by step method of SDLC
Agile
overlapping of one step into another step
ERD
Entity Relationship Diagram, and is a graphical representation
Actual data is an entity, not a user
Entities
- Noun form describing a person, place, object, event, or concept
- Composed of attributes
Relationships
- Between entities
- Usually one-to-many or many-to-many, but can also be one-to-one
Data models
- Graphical diagram capturing nature and relationship of data
- Enterprise Data Model - high-level entities and relationships for the organization
- Project Data Model - more detailed view, matching data structure in database or data
warehouse
Planning
Preliminary understanding of business situation. Enterprise model and conceptual data
modeling
Analysis
Thorough analysis of business situation, leading to functional requirements. Detailed
conceptual data modeling.
Design
Logical and physical database design, to develop technology and organization
Implementation
Writing programs, building databases, testing, installing, training, and documenting
Maintenance
Monitoring, repairing, and enhancing
Attributes
Properties or characteristics of an entity or relationship type (often corresponds to a field
in a table)
A good business rule is:
Declarative-what, not how
Precise-clear, agreed-upon meaning
Atomic-one statement
Consistent-internally and externally
