Database Concepts Flashcards
organized collection of logically
related data
Database
stored representations of meaningful
objects and events
Data
data processed to increase
knowledge in the person using the data
Information
data that describes the properties
and context of user data
Metadata
Graphical system capturing nature and relationship of data
Data Models
Database technology involving tables (relations) representing
entities and primary/foreign keys representing relationships
Relational Databases
Networks and telecommunications, distributed databases, client-server, and 3-tier architectures
Use of Internet Technology
Application programs used to perform database activities
(create, read, update, and delete) for database users
Database Applications
computer-aided software engineering
CASE Tools
centralized storehouse of metadata
Repository
software
for managing the database
Database Management System
storehouse of the data
Database
software using the data
Application Programs
text and graphical displays to users
User Interface
personnel responsible for maintaining the database
Data/Database Administrators
personnel responsible for designing databases and software
System Developers
people who use the applications and databases
End Users
The Range of Database Applications
Personal databases
Workgroup databases
Departmental/divisional databases
Enterprise database
Integrate all enterprise functions
(manufacturing, finance, sales, marketing,
inventory, accounting, human resources)
Enterprise Resource Planning(ERP)
Integrated decision support system derived
from various operational databases
Data Warehouse
