Preview

Entity

Satisfactory Essays
Open Document
Open Document
291 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Entity
An entity set that does not possess sufficient attributes to form a primary key is called a weak entity set. One that does have a primary key is called a strong entity set.
For example,

The entity set transaction has attributes transaction-number, date and amount.
Different transactions on different accounts could share the same number.
These are not sufficient to form a primary key (uniquely identify a transaction).
Thus transaction is a weak entity set.
For a weak entity set to be meaningful, it must be part of a one-to-many relationship set. This relationship set should have no descriptive attributes.

The idea of strong and weak entity sets is related to the existence dependencies seen earlier.

Member of a strong entity set is a dominant entity.
Member of a weak entity set is a subordinate entity.
A weak entity set does not have a primary key, but we need a means of distinguishing among the entities.

The discriminator of a weak entity set is a set of attributes that allows this distinction to be made.

The primary key of a weak entity set is formed by taking the primary key of the strong entity set on which its existence depends (see Mapping Constraints) plus its discriminator.

To illustrate:

transaction is a weak entity. It is existence-dependent on account.
The primary key of account is account-number. transaction-number distinguishes transaction entities within the same account (and is thus the discriminator).
So the primary key for transaction would be (account-number, transaction-number).
Just Remember: The primary key of a weak entity is found by taking the primary key of the strong entity on which it is existence-dependent, plus the discriminator of the weak entity

You May Also Find These Documents Helpful

  • Satisfactory Essays

    PT2520 Unit7Labs Tramil

    • 330 Words
    • 1 Page

    5. What are entities? An entity is something that the database is concerned with, about which data can be stored, and which can have relationships with other entities.…

    • 330 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    10 T | Functional dependencies consist of groups of related attributes that form subsets within an entity.…

    • 313 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    It203 Homework 5

    • 319 Words
    • 2 Pages

    A primary key is specified by the selecting the column, right-clicking, then selecting Set Primary Key.…

    • 319 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    11) A linking entity is an entity that is used to resolve a many to many relationship into two one too many relationships.…

    • 613 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    2) Once the users have validated and approved the data model, it is transformed into a ________.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Unit 1 Assignment

    • 80 Words
    • 1 Page

    In the unit 1 assignment, we defined the relations and keys for a library system. In unit 2 we learned about constraints. For your unit 2 assignment, identify and describe the constraints that would be appropriate for the relations that we have within our library system. Constraints that you should consider may include:…

    • 80 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Database Concepts Pt2520

    • 326 Words
    • 2 Pages

    18. TRUE A candidate key is any attribute or combination of attributes that might make a primary key.…

    • 326 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Pt2520 Final Answers 1/3

    • 329 Words
    • 2 Pages

    a database entity can be best described as: something that the something the database is concerned for, and can be added into the database…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. Consider a table of data about employees. Which of the following fields are keys? Which one would you choose as the primary key? Employee ID Why? Because it is a unique number assigned to each employee.…

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

    Defining a(n) primary key in a second table creates a relationship between that table and the table where the primary key was first defined. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
  • Good Essays

    07

    • 4772 Words
    • 25 Pages

    3) The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.…

    • 4772 Words
    • 25 Pages
    Good 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
  • Powerful Essays

    Music

    • 1176 Words
    • 5 Pages

    | Primary Key – may contain alpha and numeric. You create this, do not use autonumber.…

    • 1176 Words
    • 5 Pages
    Powerful Essays