Shared Flashcard Set

Details

Chapter 1 - The Database Environment and Development Process
Environment and Development Process
26
Other
Undergraduate 3
02/26/2018

Additional Other Flashcards

 


 

Cards

Term
Database
Definition
An organized collection of logically related data
Term
Data
Definition
Stored representations of objects and events that have meaning and importance in the user's environment.
Term
Information
Definition
Data that have been processed in such a way as to increase the knowledge of the person who uses the data
Term
Metadata
Definition
Data that describes the properties or characteristics of end-user data and the context of those data.
Term
Database Application
Definition
An application program (or set of related programs) that is used to perform a series of data activities (create, read, update, and delete) on behalf of the database users.
Term
Data Model
Definition
Graphical systems used to capture the nature and relationships among data.
Term
Entity
Definition
A person, a place, an object, and event, or a concept in the user environment about which the organization wishes to maintain data.
Term
Relational Database
Definition
A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables.
Term
Database Management System (DBMS)
Definition
A software system that is used to create, maintain, and provide controlled access to user databases
Term
Data Independence
Definition
The separation of data descriptions from the application programs that use the data.
Term
User View
Definition
A logical description of some portion of the database that is require by a user to perform some task.
Term
Database Administration
Definition
A technical function that is responsible for physical database design and for dealing with technical issues, such as security enforcement, database performance, and backup and recovery.
Term
Data Administration
Definition
A high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate-wide definition and standards.
Term
Contraint
Definition
A rule that cannot be violated by database users.
Term
Computer-aided Software Engineering (CASE) Tools
Definition
Software tools that provide automated support for some position or the systems development process.
Term
Repository
Definition
A centralized knowledge base for all data definitions, data relationships, screen and report formats, and other system components.
Term
Enterprise Data Modeling
Definition
The first step in database development, in which the scope and general contents of organization database are specified.
Term
System Development Life Cycle (SDLC)
Definition
The traditional methodology used to develop, maintain, and replace information systems.
Term
Conceptual Schema
Definition
A detailed, technology-independent specification of the overall structure of organizational data.
Term
Logical Schema
Definition
The representation of a database for a particular data management technology.
Term
Physical Schema
Definition
Specifications for how data from a logical schema are stored in a computer's secondary memory by a database management system
Term
Prototyping
Definition
An iterative process of systems development in which requirements are converted to a working system that is continually revised through close work between analysis and users.
Term
Agile Software Development
Definition
An approach to data base and software development that emphasizes "individuals and interactions over processes and tools, working software over comprehensive documentation, customer collaboration over contract negotiation, and response to change over following a plan."
Term
Enterprise Resource Planning (ERP)
Definition
A business management system that integrates all functions of the enterprise, such as manufacturing, sales, finance, marketing, inventory, accounting, and human resources. ERP systems are software applications that provide the data necessary for the enterprise to examine and manage its activities.
Term
Data Warehouse
Definition
An integrated decision support database whose content is derived from the various operational databases.
Term
Attribute
Definition
A property or characteristic of an entity or relationship type that is of interest to the organization
Supporting users have an ad free experience!