Ch17 Database Design using the REA data model

Home > Preview

The flashcards below were created by user shesddeevl on FreezingBlue Flashcards.


  1. Data modeling
    Defining a database so that it faithfully represents all key components of an organization's environment. The objective is to explicitly capture and store data about every business activity the organization wishes to plan, control, or evaluate
  2. Entity-relationship (E-R) diagram
    A graphical depiction of a database's contents showing the various entities being modeled and the important relationships among them
  3. Entity
    Anything about which an organization wants to collect and store information
  4. REA data model
    A data model used to design AIS databases. It contains information about three fundamental types of entities: resources, events, and agents
  5. Resources
    Those things that have economic value to an organization such as cash, inventory, supplies, factories, and land
  6. Events
    Business activities about which management wants to collect information for planning or control purposes
  7. Agents
    The people and organizations who participate in events and about whom information is desired
  8. Cardinalities
    Describe the nature of a database relationship indicating the number of occurrences of one entity that may be associated with a single occurrence of the other entity. Three types of cardinalities are one-to-one, one-to-many, and many-to-many
  9. Minimum cardinality
    The minimum number of instances that an entity can be linked to the other entity in the relationship. Only two options: 0 and 1
  10. Maximum cardinality
    The maximum number of instances that an entity can be linked to the other entity in the relationship. Only two options: 1 or many.
  11. One-to-one (1:1) relationship
    A relationship between two entities where the maximum cardinality for each entity is 1
  12. One-to-many (1:N) relationship
    A relationship between two entities where the maximum cardinality for one of the entities is 1 but the other entity has a maximum cardinality of many
  13. Many-to-many (M:N) relationship
    A relationship between two entities where the maximum cardinality of both entities is many

Card Set Information

Author:
shesddeevl
ID:
330716
Filename:
Ch17 Database Design using the REA data model
Updated:
2017-04-24 19:27:41
Tags:
accounting terms
Folders:

Description:
ACC409
Show Answers:

Home > Flashcards > Print Preview