Accounting information system Essay Example for Free

Accounting information system EssayAn entity relationship (ER) diagram is a accompaniment technique used to represent the relationship between entities. Entities are physical resources (automobiles, cash, or in-ventory), events (ordering inventory, receiving cash, shipping goods), and agents (sales-person, customer, or vendor) about which the organization wishes to capture data. One common use for ER diagrams is to model an organizations database, which we examine in detail in Chapter 9. Figure 2-14 shows the symbol set used in an ER diagram. The square symbol represents entities in the system. The labeled connecting line represents the nature of the relationship between two entities. The layer of the relationship, called cardinality, is the numerical mapping between entity instances. A relationship can be one-to-one (11), one-to-many (1M), or many-to-many (MM). 2 If we think of entities in the ER diagram as loads of records, cardinality is the maximum number of records in on e file that are related to a hit record in the other file and vice versa. Cardinality reflects common business rules as well as organizational policy. For instance, the 11 cardinality in the first vitrine in Figure 2-14 suggests that each salesperson in the organization is assigned one automobile.See much Unemployment problems and solutions essayIf instead the organizations policy were to assign a single automobile to one or more salespersons who share it, this policy would be reflected by a 1M relationship. Similarly, the MM relationship between vendor and inventory in Figure 2-14 implies that the organization buys the same lawsuit of products from one or more vendors. A company policy to buy particular items from a single vendor would be reflected by a 1M cardinality. System designers identify entities and prepare a model of them, similar to the one presented in Figure 2-15. This data model is the blueprint for what ultimately willa