IS 410 Exam 1 Study Guide Questions With Correct Answers.
1 view 0 purchase
Course
IS 410
Institution
IS 410
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...
is 410 exam 1 study guide questions with correct a
Written for
IS 410
All documents for this subject (47)
Seller
Follow
LectDan
Reviews received
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LectDan. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
