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;
35 Cards in this Set
- Front
- Back
What is a database
|
A database is an organized collection of logically related data.
|
|
What is data and the 2 types
|
Data are facts, text, images, sound, and video segments that have meaning in the users’ environment.
Structured: Unstructured: |
|
What do database skills allow IT professionals to do
|
Database skills enable IT professionals to know which data are logically related and how to best organize them.
|
|
What is metadata
|
Data about data or Descriptions of the properties or characteristics of the data, including data types, field sizes, allowable values, and data context
|
|
What are the cons of traditional file processing?
|
program-data dependence
duplication of data limited data sharing lengthy development time excessive program maintenance a lot of experienced programmers and developers |
|
What are the pros of database technology
|
program-data independence
minimal data redundancy improved data consistency, quality, accessibility, and sharing increased productivity and less maintenance ` |
|
What are the 3 things about the database approach
|
Central repository of shared data
Data is managed by a controlling agent Stored in a standardized, convenient form It also Requires a Database Management System (DBMS) |
|
What are the functions of a DBMS
|
Create databases
Create tables Create supporting structures Read database data Modify database data (insert, update, delete) Maintain database structures Enforce rules Control concurrency Provide security Perform backup and recovery |
|
Define data models
|
Graphical system capturing nature and relationship of data
|
|
Define Enterprise Data Model
|
high-level entities and relationships for the organization
|
|
Define Project Data Model
|
more detailed view, matching data structure in database or data warehouse
|
|
What are relational databases
|
Database technology involving tables (relations) representing entities and primary/foreign keys representing relationships
|
|
How do databases use Internet technology
|
Networks and telecommunications, distributed databases, client-server, and 3-tier architectures
|
|
What are database applications
|
Application programs used to perform database activities (create, read, update, and delete) for database users
|
|
What are the Cost and risks associated with database technology
|
new, specialized personnel
installation and management costs and complexity conversion costs need for explicit backup and recovery organizational conflict |
|
What is the first step in the database approach
|
Creating an enterprise data model
|
|
What goes into an enterprise data model
|
First step in database development
Specifies scope and general content Overall picture of organizational data at high level of abstraction Entity-relationship diagram Descriptions of entity types Relationships between entities Business rules |
|
What is an entity
|
An entity is a person, place, object, event or concept about which an organization wishes to maintain data.
|
|
What is an association
|
An association is a relationship between entities whose naming and notation capture fundamental business rules
|
|
What is functional decomposition
|
Iterative process breaking system description into finer and finer detail
|
|
What are Planning matrixes
|
Describe interrelationships between planning objects in the organization
|
|
What are the types of matrixes
|
Location-to-function
Unit-to-function IS-to-data entity Supporting function-to-data entity IS-to-business objective |
|
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 are the 7 processes in the SDLC
|
Identify Project
Initiate and plan Analyze Logical design Physical design Implementation Maintenance |
|
What are the database development activities as they relate to the SDLC
|
Identify Project (Enterprise
Modeling) Initiate and plan(Conceptual Data Modeling) Analyze (Conceptual Data Modeling) Logical design (Logical DB Design) Physical design (Physical DB Design/Creation) Implementation (DB Implementation) Maintenance (DB Maintenance) |
|
What are the components of the DB enviorment?
|
CASE Tools
Repository DBMS Database Application programs User interface Data and database administrators System developers End Users |
|
What are the different types of databases
|
Personal
Workgroup Department/Division Enterprise Web-enables |
|
What are the six key components of an information systems architecture
|
Data
Processes Networks People Events and points in time Reasons |
|
What are business functions
|
A related group of business processes that support some aspects of the mission of the enterprise.
|
|
What are 3 reasons to use a function to data entity matrix
|
identify orphans
spot missing entities prioritize development |
|
What are the 2 benefits to using packaged data models
|
Dramatically reduced implementation times and costs
Higher quality models |
|
Who are the members of the DB development team
|
Business Analysts
Systems analysts DB analysts and data models Users Programmers Database architects Database administrators Project managers Other technical experts |
|
What are the three schema components
|
External Schema
Conceptual Schema Internal Schema pg 55 |
|
What are the three tiers commonly used in DB location architecture
|
Client tier
Application/Web server tier Enterprise Server tier pg 60 |