exam 2 Flashcards
traditional file systems
stores groups of records used by a particular software application together
problems with traditional file systems
inability to share data,
inadequate security,
allows data duplication (redundancy)
database
a set of logically related stored data in a shared repository
database management system (DBMS)
program that creates, processes, and administers databases
the four DBMS operations
read, insert, modify, delete
how do database applications make databases more useful?
forms, reporting, queries, application programs
hierarchy of data elements
bytes - fields - records - tables - databases
bytes grouped into…
columns/fields
columns grouped into…
rows/records
rows grouped into…
tables/files
metadata
data that describes data, makes databases more useful and easier to use
the three relationships among records
primary keys, foreign keys, relational databases
primary keys
column(s) that identify UNIQUE rows in a table
foreign keys
when primary keys exist in another table (NOT unique here)
relational databases
databases using tables, keys, and foreign keys
three functions of DBMS
- creating the database & structure
- processing the database
- administering the database
business process
network of activities that generate value by transforming inputs into outputs
structured business processes
very formal, standardized process, usually in day-to-day operations
examples structured business processes
customer returns, order entry, purchasing, payroll
dynamic business processes
informal, flexible, adaptive, involves strategic/less structured managerial decisions and activities
examples of dynamic business processes
collaboration; social networking; ill-defined, ambiguous situations
common workgroup processes
exist to enable workgroups to fulfill the goals or purposes of their department
examples of workgroups
sales & marketing, operations, manufacturing, customer service, etc.
three variations of scope
workgroup (smallest),
enterprise,
inter-enterprise (largest)
work groups
10-100 individuals, formalized procedures, change is difficult
enterprise
100-1000 users, spans a whole organization, very formal, highly documented, formal training
inter-enterprise
1000+ users, mandatory training, formalized procedures
two ways to improve process quality
efficiency and effectiveness
process efficiency
measure of the ratio of outputs into inputs
process effectiveness
measure of how well a process achieves organizational strategy