Chapter 1 Vocab Flashcards
Structured Data
- numeric, character, and dates
2. stored in tabular form (tables, relations, arrays, spreadsheets)
Unstructured Data
multimedia data
Database
an organized collection of logically related data
Data
stored representations of objects and events that have meaning and importance in the user’s enviornment
Information
data that has been processed in a way to increase the knowledge of the person who uses the data
increases knowledge
Metadata
data that describes the properties or characteristics of end-user data and the context of that data
Database Application
an application program that is used to perform a series of database activities
ex. create, read, update, and delete
Data Model
graphical systems used to capture the nature and relationships among data
Entity
A person, a place, an object, an event, or a concept in the user enviornment about which the organization wishes to maintain data
Relational Database
A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables
Database Management System (DBMS)
a software system that is used to create, maintain, and provide controlled access to used databases
Data Independence
the separation of data descriptions from the application programs that use the data
User View
a logical description of some portion of the database that is required by a user to perform some task
Constraint
a rule that cannot be violated by database users
Computer-aided Software Engineering (CASE) tools
software tools that provide automated support for some portion of the systems development process
Repository
a centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components
Enterprise Data Modeling
the first step in database development, in which the scope and general contents of organizational databases are specified
Systems Development Life Cycle (SDLC)
the traditional methodology used to develop, maintain, and replace information systems
Conceptual Design
a detailed, technology independent specification of the overall structure of organizational data
Logical Schema
the representation of a database for a particular data management technology
Physical Schema
specifications for how data from a logical schema are stored in a computer’s secondary memory by a database management system
Prototyping
an iterative process of systems development in which requirements are converted to a working system that is continually revised through close work between analysts and users
Agile Software Development
an approach to database 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
Project
a planned undertaking of related activities to reach an objective that has a beginning and an end
