Shared Flashcard Set

Details

DBMS
midterm
15
Accounting
Undergraduate 4
03/02/2013

Additional Accounting Flashcards

 


 

Cards

Term
Database
Definition
organized collection of logically related data
Term
Data
Definition
stored representation of meaningful objects.
Ex. Structured: numbers, txt, dates.
Unstructured: images, video, documents
Term
Information
Definition
data processed to increase knowledge in the person using the data
Term
metadata
Definition
data the describes the properties and context of user data
Term
What are drawbacks of using file systems to store data
Definition
data redundancy and inconsistency, multiple file formats, duplication of information in different files.
Term
Whats the percentage cost for maintanace
Definition
80% of information system budget is for maintenance
Term
What are some problems with data storage
Definition
data changes in one file could cause inconsistencies.
compromises in data integrity
Term
What is the solution for database problems
Definition
Central repository of shared data.

Data is managed by a controlling agent.

Stored in a standardized, convenient form.
Term
Enterprise Data Model
Definition
high level entities and relationships for the organization
Term
Project Data Model
Definition
more detailed view, matching data structure in database or data warehouse.
Term
Entities
Definition
noun form describing a person, place, object, event, or concept.

Composed of attributes.
Term
Relational Databases
Definition
database technology involving tables (relations) representing entities and primary/foreign keys representing relationships.
Term
Case tools
Definition
Computer aided software engeneering
Term
repository
Definition
centralized storehouse of metadata
Term
database management system
Definition
software for managing the database
Supporting users have an ad free experience!