A major advantage of the REA data model is that it integrates non-financial and financial data in the AIS and makes both types of data easily accessible to management.

ER diagram contains only one class of entities and the proximity to another entities are determined by the cardinality and also by what is visually pleasing to make diagrams readable. But REA contains 3 classes of entities, Resource, Agents and Events are organized into group or constellations by class in the diagram.

The REA framework provides a method for organization and critically analyzing ER diagrams. The REA framework provides guidance for database design by identifying which entities should be included in the AIS database and by identifying how to structure relations among the entities in that database.

An REA diagram is an E-R diagram that is designed using the REA data model to identity the three basic kinds of entities relevant to transaction processing systems: the resources controlled by the organizations, the events (business activities) that managers want to plan, control, and evaluate, and the agents who …

lockout

What are the four primary elements of the database environment? the users, the database management system, the database administrator, and the physical database structures.

There are three levels in the data hierarchy. These levels include attribute, record and file.

Least likely attribute in a normalized database Attributes in the employee table are Employee name, Address, Number and Supervisor’s name. When the database table is getting normalized then the least attribute is Supervisor’s name as there are separate numbers, name and address for the supervisors.

ITEM NUMBER

A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table). Informally, a primary key is “which attributes identify a record”, and in simple cases are simply a single attribute: a unique id.

Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data. Purpose of the data. Time and date of creation.

A stakeholder is a party that has an interest in a company and can either affect or be affected by the business. The primary stakeholders in a typical corporation are its investors, employees, customers, and suppliers.

6 ways to effectively communicate with stakeholders

1. Schedule a meeting.
2. Send out a newsletter.
3. Separate online “screen to screen” meetings.
4. Project summary report.
5. Schedule a conference call.
6. Lunch meetings.