Preview

IST223 Crib sheet

Powerful Essays
Open Document
Open Document
3425 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
IST223 Crib sheet
rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist

You May Also Find These Documents Helpful

  • Good Essays

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Unit 3 research

    • 383 Words
    • 2 Pages

    An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes…

    • 383 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Entity-relationship Model

    • 411 Words
    • 2 Pages

    12. Linking Entities- Linking entities are used to resolve many-to-many relationships into two one-to-many relationships.…

    • 411 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Cronon Worksheet

    • 1217 Words
    • 5 Pages

    Native Americans used the land that they had to survive. They moved around seasons to season in order to get the resources that they needed. They would fish if there was a water source around or if there were a lot of land or a forest they would hunt. They considered food and home a good use for land; anywhere they…

    • 1217 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    The hierarchy flow of information can be presented by creating Entity relationship diagram that will allow any end users to see the process of data flow and to understand the importance of a structured database. There are four widely used symbols that enable ERD to…

    • 762 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    cheat sheet

    • 1430 Words
    • 6 Pages

     The actual specification of attributes for a given relation is driven by an analysis of “Functional Dependencies” amongst attributes of the proposed relation…

    • 1430 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Database concepts

    • 586 Words
    • 3 Pages

    In Database Management System, a transitive dependency is a functional dependency which holds by virtue of transitivity. A transitive dependency can occur only in a relation that has three or more attributes. Let A, B, and C designate three distinct attributes (or distinct collections of attributes) in the relation. Suppose all three of the following conditions hold:…

    • 586 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Week 4 MGMT340 Assignment

    • 538 Words
    • 3 Pages

    f. TOOL could be modeled as an associative entity along with EMPLOYEES and PROJECTS. An associative entity type is one that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. For example, EMPLOYEES can use TOOL and PROJECT will also need TOOL. TOOL can used by EMPLOYEES for PROJECTS.…

    • 538 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Anime LIst

    • 11441 Words
    • 52 Pages

    Which of the following defines a relationship in which each occurrence of data in one entity…

    • 11441 Words
    • 52 Pages
    Good Essays
  • Satisfactory Essays

      Unary or recursive relationships Entity integrity: Keys Interesting design cases Converting logical model to a physical model 3 Last Class Review  JOINS   ANSI and traditional join syntax…

    • 600 Words
    • 9 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Relational Database Paper

    • 547 Words
    • 3 Pages

    A relationship is an important component of a relational database. A relationship exists between two tables when one or more key fields from one table are matched to one or more key fields in another table. The fields in both tables usually have the same name, data type, and size. It also helps to further refine table structures and minimize redundant data.…

    • 547 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    My Team Portion

    • 436 Words
    • 2 Pages

    The most important step when creating a database are detecting the table elements. While analyzing the form entitled “Entities and Attributes for Fleet Truck Maintenance,” the database table elements can be clearly determined. The structure of a database can be defined based on the Entities and Attributes within a table or a relation. Entities may be used to allow the same rule to be applied multiple times to make a determination ("Define an Entity", n.d.). An attribute basically describes what the entity is. The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database. The ER model was first proposed by Peter Pin-Shan Chen of Massachusetts Institute of Technology (MIT) in the 1970s (TechTarget, 2005-2015).…

    • 436 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    A relation is a two-dimensional table in which (1) the entries in the table are single-valued; (2) each column has a distinct name; (3) all of the values in a column are values of the same attribute; (4) the order of the columns is immaterial; (5) each row is distinct; and (6) the order of the rows is immaterial.…

    • 2147 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Module: Database Systems Chapter 1 The Entity Relationship Modelling The Concepts of Entity Relationship Model 1.1 Entity Types…

    • 465 Words
    • 2 Pages
    Good Essays