Preview

7.4. Explain The Difference Between An Attribute And A Value Set

Good Essays
Open Document
Open Document
720 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
7.4. Explain The Difference Between An Attribute And A Value Set
7.4. What is an entity type? What is an entity set? Explain the differences among an entity, an entity type, and an entity set.
Entity:
An entity is a thing or object in the real world. An object may be with a physical existence or with a conceptual existence. A set of these entities having same attributes is entity type and collection of individual entity type is an entity set.
Entity type:
A set of entities that have the same attributes is called an entity type. Each and every entity type in the database is described by a name and a list of attributes. Entity type defines a collection of entities that have the same attributes.
For example an entity employee is an entity type that has Name, Age and Salary as attributes.

Entity set:
It is
…show more content…
It may be tangible or intangible. Examples of an entity are employees or any physical object.
Entity type describes the schema or intension for a set of entities that share the same structure.
Entity set is the extension of the entity type and a collection of related data.

7.5. Explain the difference between an attribute and a value set.
Attribute:
An attribute is a particular property that describes entity. A value set specifies the set of values that may be assigned to that attribute for each individual entry. An example of an attribute is and
An attribute is a property that describes a real entity. Now for all entities there are certain values that each attribute can take. Set of all values that an attribute can take is called value set. Often the value that attribute take are lesser in number than number of element in value set.
Difference between an attribute and value set can simply be taken as that between a variable and group of values that this variable can take. For example for a person an attribute can be name such as Employee Age. For value of this attribute we can set the value set to a range of integer
…show more content…
It has its origins in Object Oriented programming languages (OOPL). In today’s time OO concepts are applied in the areas of databases, software engineering, artificial intelligence, computer systems and have their roots in the SIMULA language, which was proposed in the late 1960s. The Smalltalk programming language developed at Xerox PARC8 in the 1970’s, was one of the first languages to explicitly incorporate additional OO concepts, such as message passing and inheritance. It is known as a pure OO programming language. An object typically has two components: state (value) and behavior (operations). The object can have a complex data structure as well as specific operations defined by the programmer, objects in an OOPL only exist during program execution and they are called transient objects. OO databases store persistent objects permanently in secondary storage, and allow the sharing of these objects among multiple programs and applications. Object-oriented systems allow definition of the operations or functions (behavior) that can be applied to objects of a particular

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

    Attribute-Based Programming: Attributes assist you to add declarative information in your programs. This information can then be queried at runtime using reflection.…

    • 485 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    A set is a collection of objects. The objects in a set are called the elements of the set. A set of numbers is simply a listing, within braces {}. For example, the set of numbers used for counting can be represented as S = {1, 2, 3, 4, 5, . . .}. The braces…

    • 1254 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    5. (TCO 2) A collection of related data items that are specific to an instance of an entity, such as all the data about a specific employee, is (Points : 4)…

    • 368 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
  • Better Essays

    The entity concept is a theory concerning the nature of the group. It interprets the group to be a set…

    • 1775 Words
    • 8 Pages
    Better Essays
  • Better Essays

    Chapter 4 Quiz Week 2

    • 537 Words
    • 2 Pages

    For each entity, create a list of attributes you think would be useful to describe the…

    • 537 Words
    • 2 Pages
    Better Essays
  • Good Essays

    Acme Global Consulting

    • 678 Words
    • 3 Pages

    Another advantage of having an E-R model DBMS is the components of this model. This will allow your different employee groups to distinguish the differences between these different components in the model. Some of the components are entities that represent a person, place event or an object in the real world that is modeled in the DBMS. Another component is attributes; this represents the defining qualities or properties of the entity type. One more entity is called a…

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

    Advertising and Kodak

    • 269 Words
    • 2 Pages

    An entity would be a customers name, and the attributes would be their address, purchase history. An entity could also be an age group. Attributes could include specific age, where they are from, what they purchase, what they would like to purchase.…

    • 269 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    A value is a measure by which we base our integrity. As individuals our values are our judgments on what is important in life. There are different types of values, such as ethical, moral, social, cultural and aesthetic values.…

    • 2225 Words
    • 9 Pages
    Best Essays
  • Powerful Essays

    question answer

    • 1653 Words
    • 7 Pages

    A strong entity type is an entity type that is not existence-dependent on some other entity type…

    • 1653 Words
    • 7 Pages
    Powerful Essays