Preview

Entity-Relationship model vs. Semantic Object model

Satisfactory Essays
Open Document
Open Document
224 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Entity-Relationship model vs. Semantic Object model
An Entity Relationship Model, also known as an Entity Relationship Diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data; an object or concept about which data is stored. A relationship is how the data is shared between entities. The three types of relationships between entities are one-to-one, one-to-many, and many-to-many.

One-to-one is when one instance of an entity A is associated with one other instance of another entity B. One-to-many is when one instance of an entity A is associated with zero, one or many instances of another entity B, but for one instance of entity B there is only one instance of entity A. Many-to-many is when one instance of an entity A is associated with one, zero or many instances of another entity B, and one instance of entity B is associated with one, zero or many instances of entity A.

A Semantic Object Model is developed from objects that are already known. This model is normally used to document a system, program, or object that is already in use and working properly. Another term for Semantic Model from the field of knowledge representation is "ontology": the set of classes, relationships, and functions in a universe of

You May Also Find These Documents Helpful

  • Satisfactory Essays

    PT2520 Unit7Labs Tramil

    • 330 Words
    • 1 Page

    3. What is a foreign key? This primary key becomes a foreign key when it is repeated in another table to create a link between the tables.…

    • 330 Words
    • 1 Page
    Satisfactory Essays
  • 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
  • Good Essays

    7) In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table.…

    • 613 Words
    • 3 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

    The following diagram (1-1) is entity relationship (E-R) diagram and it illustrates the existing data tables.…

    • 851 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Pt2520 Final Answers 1/3

    • 329 Words
    • 2 Pages

    when u get a many to many: make a linking table that resolves the many to many into 2 1-1 relationships.…

    • 329 Words
    • 2 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
  • Powerful Essays

    IST223 Crib sheet

    • 3425 Words
    • 7 Pages

    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…

    • 3425 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    Entity-relationship Model

    • 411 Words
    • 2 Pages

    6. One-to-One Relationship - . A one-to-one relationship specifies that for each row in the primary entity, there can be one and no more than one related record in the secondary entity. In a one-to-one relationship, the primary key of the first entity is often the primary key of the second entity.…

    • 411 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    poop

    • 796 Words
    • 4 Pages

    1. An entity is a noun describing a person, place or thing and is used for deciding what tables are created based on the entities present.…

    • 796 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor…

    • 906 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The other ways of diagramming entities and relations is electronic facsimile collections, parametric schema implementation, and FDA. There were many different illustrations that individuals had made using entities and relations yet I felt it was best to keep it to a basic. During my search, I learned that you could use the entities and relations design for numerous things.…

    • 334 Words
    • 2 Pages
    Satisfactory 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
  • Good Essays

    A database is a structure that contains information about many different categories of information and about the relationships between those categories (Pratt & Adamsk 2010). Database objects are entities that exist within a database to support operations such as storing, retrieving and manipulating data. Organizations use large amounts of data and database management system to store and transform data into information to support making decisions.…

    • 688 Words
    • 3 Pages
    Good 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