Database Design Using the REA Data Model

Database Design Using the REA Data Model

Database Design Using the REA Data Model Chapter 17 Copyright 2015 Pearson Education, Inc. 17-1 Learning Objectives Discuss the steps for designing and implementing a database system. Use the REA data model to design an AIS database. Draw an REA diagram of an AIS database.

Read an REA diagram and explain what it reveals about the business activities and policies of the organization being modeled. Copyright 2015 Pearson Education, Inc. 17-2 Database Design Process Copyright 2015 Pearson Education, Inc. 17-3

Data Modeling Process of defining a database so that it faithfully represents all aspects of the organization, including its interactions with the external environment. Entity-relationship (E-R) diagrams REA data model Copyright 2015 Pearson Education, Inc. 17-4 REA Modeling

Resources Things that have economic value to the organization (e.g., inventory, cash) Events Various business activities that management wants to collect information on Agents People and organizations that participate in events (both internal (e.g., employees) and external (e.g., customers/vendors) to the organization) Copyright 2015 Pearson Education, Inc.

17-5 REA Basic Template Copyright 2015 Pearson Education, Inc. 17-6 Creating an REA Model Identify relevant events Give-get exchange (economic duality) Identify resources and agents

Resource reduced in give event Resource acquired in get event Determine cardinalities of relationships Nature of the relationship between the two entities Copyright 2015 Pearson Education, Inc. 17-7 Cardinality Notation Methods Graphical symbols Graphical symbols represent minimum maximum cardinalities

(Min, Max) notation Pairs representing the minimummaximum cardinalities UML notation Pairs representing the minimummaximum cardinalities Maximums only (Microsoft Access) Copyright 2015 Pearson Education, Inc. 17-8

Key Terms Data modeling Entity-relationship (E-R) diagram REA data model Resources Events Agents Cardinalities Copyright 2015 Pearson Education, Inc. Minimum cardinality Maximum cardinality

One-to-One (1:1) relationship One-to-Many (1:N) relationship Many-Many (M:N) relationship 17-9

Recently Viewed Presentations

  • Lesson 9 - Gerald Croft - WordPress.com

    Lesson 9 - Gerald Croft - WordPress.com

    Objectives: understand the characterisation of Gerald Croft by creating presentations. A* To make perceptive and detailed evaluation of the writers use of themes and how these are used through Gerald. Links are made to the effect on the audience and...
  • Chapter 1

    Chapter 1

    Defensive Strategy Fortify firm's present position Help sustain any competitive advantage held Lessen risk of being attacked Blunt impact of any attack that occurs Influence challengers to aim attacks at other rivals Defensive Strategies: Approaches Block avenues open to challengers...
  • Metaphors and Similes - PC\|MAC

    Metaphors and Similes - PC\|MAC

    * * * Professor Pen Professor Pen Playing with Words Believe it or not, you use metaphors and similes every day of your life! Some words are metaphors all by themselves. She was a bright student. We all know that...
  • Carbon Disclosure Project Website address www.cdp.net https://www.cdproject.net/en-US/Pages/guidance-supply-chain.aspx Sustainability

    Carbon Disclosure Project Website address www.cdp.net https://www.cdproject.net/en-US/Pages/guidance-supply-chain.aspx Sustainability

    Activate Your Online Account. 1. A link will be provided in the original e-mail from CDP on April 1, 2013 to activate your account. This link is personal to your company and gives you access to your CDP portal. 2....
  • Author's Purpose P (persuade) I (inform) E (entertain) S ...

    Author's Purpose P (persuade) I (inform) E (entertain) S ...

    Author's Purpose P (persuade) I (inform) E (entertain) S (share feelings) Reading Intervention Mrs. Orso P (persuade) Persuade means to try to get someone to think the same way you do Examples Advertisements, newspaper editorials, posters I (inform) Inform means...
  • To Kill a Mockingbird - Announcements

    To Kill a Mockingbird - Announcements

    To Kill a Mockingbird is told in first person point of view, through the eyes of Scout Finch. The entire book is a flashback. She is looking back at the events leading up to her brother Jem breaking his arm...
  • Commercialisation - Weebly

    Commercialisation - Weebly

    Commercialisation 'the treating of sport as a _____, involving the _____ and _____ of assets, with the market as the driving force behind sport' With the mass use of sport as an entertainment package came the realisation that sport could...
  • Venus Mass = 0.82 MEarth Radius = 0.95

    Venus Mass = 0.82 MEarth Radius = 0.95

    Alternatively, volcanic outgassing may never have produced oceans, like on Earth, because too hot. All gases stayed in atmosphere. Missions to Venus. Soviet Venera 4 -18 (1967 - 1983) Mariner 2, 5 and 10 (1962, 1967 and 1974) Pioneer Venus...