Introduction to Information Management Flashcards
A computerize record keeping system
Database
A collection of logically related data
Database
Raw facts concerning people, objects, events or other entities.
Data
Data that have been processed and presented
Information
Data that describe the properties or characteristics of other data.
Meta-data
Computers were used almost exclusively for scientific engineering calculations.
Traditional File Processing
Program-data dependence, data redundancy, limited data sharing, lengthy development time, and excessive program maintenance are examples of what disadvantage?
Traditional File Processing
Simply uses database to manage all data and information (as a whole).
Database Approach
Integration and sharing of data throughout the organization.
Database Approach
Software system that facilitates the processes of defining, constructing, manipulating, and sharing databases
Database Management System (DBMS)
Stores data in such a way that it becomes easier to retrieve, manipulate, and produce information
Database Management System (DBMS)
What are the elements of database approach?
Enterprise Data Model
Enterprise Resource Planning
Relational Databases
Database Applications
A map or graphical model that shows the entities and the relationship among them
Enterprise Data Model
Company-wide computer software system used to manage and coordinate all the resources, information, and functions of a business from shared data stores.
Enterprise Resource Planning
Handle the manufacturing, logistics, distribution, inventory, shipping, invoicing, and accounting for a company.
Enterprise Resource Planning
Database technology involving tables (relations) representing entities and primary/foreign keys representing relationships
Relational Databases
An application program (or set of related programs) that is used to perform a series of activities on behalf of database users
Database Applications
Range of Database Applications
Personal Databases Workgroup Databases Department Databases Enterprise Databases Internet, Intranet, and Extranet Databases
These are designed to support one user. They have long resided on personal computers (PCs), including laptops
Personal Databases
A workgroup is a relatively small team of people who collaborate on the similar project or application
Workgroup Databases
It is typically comprises fewer than 25 persons
Workgroup
Larger than a workgroup (typically 25-100 persons) and is more responsible for a more diverse range of functions.
Department Databases
A functional unit within an organization
Department
A database whose scope is the entire organization or enterprise (or, at least many different departments).
Enterprise Databases
These databases are intended to support organization wide operations and decision making.
Enterprise Databases
It enables us to access information from nearly anywhere in the world directly and conveniently.
Internet
A network connection to non-company entities that are not accessed via an internet connection.
Extranet
It is the use of Internet protocols to establish access to company data and information limited to the organization.
Intranet
CASE Tools
Computer-Aided Software Engineering Tools
DBMS
Database Management System
Components of Database Environment
CASE Tools Repository DBMS Database Application Programs User Interface Database Administration System Developers End-Users
Automated tools use to design databases and application programs.
Computer-Aided Software Engineering (CASE) Tools
A technology for automating software and database development and maintenance tasks.
CASE Tools
Centralized knowledge base containing all data definitions, screen reports and report formats and definition of other organizations and system components.
Repository
Commercial software system use to provide access to the database and also the repository.
DBMS
Software system that allows users to define, create, maintain and control access to the database.
DBMS
Contains occurrences of data while repository contains all definition of programs.
Database
Computer programs that are used to create and maintain the database and provide information to users.
Application Programs
Languages, menus, and other facilities by which users interact with various system components such as case tools, application programs, the DBMS, and the repository.
User Interface
Persons who are responsible of designing database and for developing policies regarding database security and integrity.
Database Administrators
Persons such as system analysts and programmers who design new programs.
System Developers
Persons through the organization who add, delete, and modify data in the database and who request or receive information from the database. All user interactions with the database must be routed through the DBMS.
End-Users
It is the preferred method of storage for large multiuser applications, where coordination between many users is needed.
Database
