Entity, Table, Record, Field

on

  1. Entity:

    • Definition: An entity represents a distinct object, concept, or thing about which data is stored. It can be a person, place, event, concept, or any other tangible or intangible item that can be uniquely identified.
    • Example: In a university database, entities could include students, courses, professors, departments, and classrooms.

  2. Table:

    • Definition: A table is a collection of data organized into rows and columns, where each row represents a single record or instance of an entity, and each column represents a specific attribute or property of that entity.
    • Example: In a student database, the "Student" table might include rows representing individual students and columns representing attributes such as student ID, name, date of birth, and major.

  3. Record:

    • Definition: A record, also known as a row or tuple, is a single instance of data stored within a table. It represents a complete set of information about a specific entity.
    • Example: In the "Student" table, each record corresponds to a single student and contains the values for attributes such as student ID, name, date of birth, and major.

  4. Field:

    • Definition: A field, also known as a column or attribute, is a single piece of data within a record or row of a table. It represents a specific characteristic or property of the entity being stored.
    • Example: In the "Student" table, fields would include attributes such as student ID, name, date of birth, and major. Each field contains the value associated with that attribute for a particular student.

Comments

Post a Comment