Data Modeling and Database Design

Data Modeling and Database Design

1. 6 Basic steps in designing a data base

   • Planning
   • Requirement Analysis
   • Design
   • Coding
   • Implementation
   • Operational and Maintenance

2. Types of Entity

   • Resource
     • Cash
     • Inventory
   • Event
     • Selling
     • Cash Receipts
   • Agent
     • Employees
     • Customer

3. 4 Steps in building an REA Diagram for a Transaction Cycle

   • Identification of Economic Exchange Activities
   • Identification Resources and Agent
   • Enter Commitments Activity
   • Set Cardinality of each Relationship
     • The minimum Cardinality
     • The Maximum Cardinality
       • One-to-one Relationship
       • One-to-many Relationship
       • Many-to-many Relationship

4. 3 Steps to implement the REA diagram in a Relational Database

   • Create a table for each entity and many-to-many Relationship
   • Assign Attributes for each table
     • Assign Primary Keys
     • Assign another attribute to the appropriate table
       • Non-key Attribute
   • Use the Foreign key to implement One-to-one Relationship and One-to-Many Relationship

5. Using REA Diagram

   • Documentation of Business Practices
   • Retrieval of information from SIA
     • Produce Journals and Ledgers
     • Provide other Financial Statement Information
     • Preparing Managerial Reports