Business Analysis. Introduction to data modeling

Before you sit down In front of the keyboard and bring forth creating a in tenorationbase application, it is critical that you take a step back and acquire your profession problem-?in this case, the kitchen bestow scenario presented in Lesson 2-? from a abstract foreland of view. To facilitate this process, a n drinking chocolate of conceptual manikining techniques have been developed by computer scientists, psychologists, and consultants. For our purposes, we can think of a conceptual model as a picture of the Information system we atomic number 18 passing game to build. To use an analogy, conceptual models atomic number 18 to Information systems what blueprints are to constructions.There are m whatsoever another(prenominal) contrastive conceptual mould techniques utilize in practice. Each technique uses a incompatible set of symbols and may focus on a different part of the problem (e. G. , information, processes, knowledge flows, objects, and so on). Despite d ifferences in notation and focus, however, the rudimentary rationale for conceptual modeling techniques is always the Michael Bryon (emailprotected Ca) determineationinal update 02-May-01 1 of 23 An admission to data modeling knowledgeableness The impressiveness of conceptual 3. 1. 1. 1 Entities and attributes What is data modeling?A data model is a simply a diagram that guides the most thorough things in your business surround from a data-centric point of view. To illustrate, con billetr the unsophisticated chromatic shown in run across 3. 1 . The purpose of the diagram is to describe the birth mingled with the data stored intimately reapings and the data stored about the organizations that supply the harvests. FIGURE 3. 1 An RED showing a blood between products and providers. The rectangles in icon 3. 1 are called entity types (typically shortened to entities) and the ovals are called attributes.The entities are the things in the business environment about whi ch we destiny to store data. The attributes provide us with a federal agency of organizing and structuring the data. For example, we need to store certain information about the products that we sell, such as the typical selling damage of the product (whole price) and the quantity of the product currently in stock-taking (Sty on hand). These pieces of data are attributes of the carrefour entity. It is essential to note that the precise manner in which data are used and processed within a finical business application is a separate issue from data modeling.For example, the data model says nothing about how the value of Sty on hand is alterd over time. The focus in data modeling is on capturing data about the environment. You will gain how to change this data (e. G. Process orders so that the inventory values are updated) once you have mastered the art of database design. Product Unit price Sty on hand Product Entity supplied by Cardinality Attributes provider kinship Name Add ress A data modeled gestates that if the right data is available, the other elements of the application will fall into place effortlessly and wonderfully. For now, this is a good working assumption.Introduction The richness of conceptual environment in which your sweeping company operates. However, it is easy to imagine a different environment in which apiece product is supplied by multiple suppliers. For example, many suppliers may conceive a particular brand of wire whisk. When you run out of whisks, it is up to you to decide where to place your order. In other words, it is possible that a many-to-many kind exists between suppliers and products. If multiple supplier exist, attributes of the product, such as its price and product number may vary from supplier to supplier.In this situation, the data requirements of a many-tomato environment are slightly more complex than those of the unmatched(a)-to-many environment. If you design and implement your database virtuallywhat the star-to-many assumption but hen discover that certain goods are supplied by multiple suppliers, much effort is going to be required to rejuvenate the problem. In plus to entities and attributes, Figure 3. 1 shows a race between the two entities using a line and a ball field. The blood begin out is used-?not surprisingly-?to indicate the existence or absence of a relationship between entities.A crows foot at either halt of a relationship line is used to denote the cardinality of the relationship. For example, the crows foot on the product side of the relationship in Figure 3. 1 indicates that a particular supplier may provide your company with overall different products, such as bowls, spatulas, wire whisks and so on. The absence of a crows foot on the supplier side indicates that individually product in your inventory is provided by a single supplier. Thus, the relationship in Figure 3. 1 indicates that you always grease ones palms all your wire whisks from the same co mpany. . 1. 1. 3 Modeling assumptions The relationship shown in Figure 3. 1 is called one-to-many each supplier supplies many products (where many means any number including zero) but each product is supplied by one supplier (where one means at most one). The termination to use a nee-to-many relationship reflects an assumption about the business herein lies the point of design an RED The diagram makes your assumptions about the relationships within a particular business environment explicit before you start building things. The role of the modeled 3. 1. 1. In the environment used in these tutorials, you are the user, the designer, and the implementer An introduction to data modeling of the system. In a more true to life(predicate) environment, however, these roles are played by different individuals (or groups) with different (programmers, database specialists, and so on) is that they seldom leave their busbies to communicate with end-users of the software they are writing. Simil arly, it is generally safe to assume that users have no interest in, or understanding of, low- level practiced details (such as the cardinality of relationships on Reds, mechanisms to enforce referential integrity, and so on).Thus, it is up to the business analyst to b liberatege the communication gap between the different groups involved in the construction, use, and administration of an information system. As a business analyst (or more generally, a designer), it is critical that you walk through your conceptual oodles with users and make sure that your modeling assumptions are appropriate. In some cases, you may have to examine sample data from the existing computer- base or manual system to determine whether (for voice) there are any products that are supplied by multiple suppliers.At the modeling put, making changes such as converting a one-to-many relationship to a many-to-many relationship is trivial-? all that is required is the addition of a crows foot to one Introduct ion The importance of conceptual end of the relationship, as shown in Figure 3. 2. In contrast, making the same change once you have implemented tables, lilt a user interface, and create verbally code is a time-consuming and frustrating chore. FIGURE 3. 2 An RED for an environment in which there is a many-to-many relationship between products and suppliers.Product Unit price Sty on hand The addition of a present moment crows foot transforms the one-to-many relationship into a many-to-many relationship. Supplier Generally, you can count on the lox rule of thumb when building software the cost of making a change increases by an order of magnitude for each stage of the systems development lifestyle that you complete. An introduction to data modeling Introduction The importance of conceptual 3. 1. 2. 1 Entities 3. 1 . 2 Data meddlers typically put one across a set of notational conventions so that their diagrams are consistent.For example, large IT organizations and consultancies typ ically relieve a methodology-?a set of tools and procedures for applying the tools that specifies the notation used within the organization. Enforcing standardisation in this way facilitates teamwork on large projects. Similarly, if a computerized software design (CASE) tool is used for conceptual modeling and design, notational conventions are often enforce by the software. What follows is a brief summary of the notational conventions that I use when drawing Reds.Keep in mind, however, that Reds are commencement ceremony and foremost a tool for communication between humans. As such, the precise notation you use is not specially important as long as people can subscribe to and understand the diagrams. With experience, you will come to realize that differences in the shapes of the boxes and lines have pocket-sized effect on the core concepts of data modeling. Entities are drawn as rectangular boxes drive outing a noun in singular form, as shown in Figure 3. 3. FIGURE 3. 3 An entity described node. CustomerYou will see later that each entity you draw ultimately becomes a table in your database. You might want to keep this transformation from entity to table in mind when selecting the label of your entities. For example, your entity names should be short but descriptive. 3. 1. 2. 2 Relationships A relationship between entities is drawn as a line bisected by a diamond. The diamond contains a verb (or short verb phrase) that describes the nature of the relationship between the entities, as shown in Figure 3. 4. Named relationships are used to make the Reds more readable.However, unlike entity names, relationship Ames never show up in the final database. Consequently, it does not rightfully matter how you label your relationships, as long It can be argued that the term method is grammatically preferable. In Europe, for example, the term method tends to be favored. Introduction The importance of conceptual Generally, Reds make certain assumptions about t he readers knowledge of the underlying business domain. FIGURE 3. 4 A relationship named buys. As the labels make the diagram easier to interpret.To illustrate, consider the relationship between products and suppliers shown in Figure 3. 1 . The relationship is scribed by the verb phrase supplied by. Although one could have opted for the shorter relationship name has instead, the resulting diagram (e. G. , Supplier has product) would be more difficult for readers of the diagram to interpret. 3. 1. 2. 3 Relationship centering A notational convention supported by some CASE tools is to require two names for each relationship one that makes sentience in one direction (e. G. is supplied by), and another that makes sense in the opposite direction (e. G. , supplies). Although double-naming may make the diagram easier to read, it likewise adds clutter (twice as any labels) and imposes an additional burden on the modeled. Cardinality 3. 1 . 2. 4 One issue that sometimes troubles neophyte d ata meddlers is that the direction of the relationship is not made explicit on the diagram. Returning to Figure 3. 1, it is obvious to me (since I drew the diagram) that the relationship should be read Product is supplied by supplier. Reading the relationship in the other direction (Supplier is supplied by product) makes very little sense to anyone who is familiar with the particular problem domain. As discussed in Section 3. 1. 1. 2, the cardinality of a relationship constrains the umber of instances of one entity type that can be associated with a single instance of the other entity type. The cardinality of relationships has an important impact on number and structure of the tables in the database. Consequently, it is important to get the cardinality right on paper before showtime the implementation.An introduction to data modeling There are three fundamental types of cardinality in Reds One-to-many -? You have already seen an example of a one-to-many relationship in Figure 3. 1 . You will soon discover that onto-many relationships are the prick and butter of relational databases. One-to-one -? At this point in your data modeling career, you should avoid one-tone relationships. To illustrate the basic issue, consider the RED shown in Figure 3. 5. Based on an existing paper-based system, the modeled has assumed that each customer is associated with one customer record (I. . , a paper form containing information about the customer, such as address, fax number, and so on). Clearly, each customer has only one we automate the system and get rid of the paper form, then there is no reason not to compound the Customer and Customer Record entities into a single entity called Customer. Introduction The importance of conceptual FIGURE 3. 5 An incorrect one-to-one relationship associated with Customer Record In many cases, one-to-one relationships indicate a modeling error. When you have a one-to-one relationship such as the one shown in Figure 3. , you should combi ne the two entities into a single entity. Many-to-many -? The institution is full of monotony-many relationships. A well-used example is Student takes course. Many-to-many relationships also arise when you consider the history of an entity. To illustrate, consider the RED shown in Figure 3. 6. At first glance, the relationship between Family and Single-Family Dwelling (SF) might seem to be one-to-one since a particular family can only live in one SF at a time and each SF can (by definition) only contain a single family. However, it is possible for a family to live in different houses over time.