• Home
  • Entity Types In DBMS

    Entity types, also known as entity classes or entity sets, are categories or classes of entities that share common characteristics, attributes, and behavior within a database. Entity types represent groups of related objects or concepts in the real-world domain being modeled. Here are some examples of entity types:


    1. Student: Represents individuals enrolled in an educational institution. Attributes may include StudentID, Name, Date of Birth, and Major.

    2. Employee: Represents individuals working for an organization. Attributes may include EmployeeID, Name, Position, and Department.

    3. Customer: Represents individuals or organizations that engage in business transactions with a company. Attributes may include CustomerID, Name, Contact Information, and Payment Details.

    4. Product: Represents items or goods offered for sale or use. Attributes may include ProductID, Name, Description, Price, and Quantity.

    5. Order: Represents a request or instruction for purchasing products or services. Attributes may include OrderID, CustomerID, Date, and Total Amount.

    6. Supplier: Represents companies or individuals that provide products or services to a business. Attributes may include SupplierID, Name, Contact Information, and Payment Terms.

    7. Book: Represents written works or publications. Attributes may include ISBN, Title, Author, Publisher, and Publication Year.

    8. Bank Account: Represents individual or business accounts held at a financial institution. Attributes may include Account Number, Account Type, Balance, and Owner.

    9. Car: Represents vehicles owned or used by individuals or companies. Attributes may include License Plate Number, Make, Model, Color, and Year.

    10. Event: Represents occurrences or happenings of interest. Attributes may include EventID, Name, Date, Location, and Description.


    These are just a few examples of entity types that can exist in various domains and applications. Entity types are defined based on the specific requirements of the database system and the nature of the domain being modeled. They serve as a foundation for creating tables, defining attributes, establishing relationships, and managing data within a database.



    About the Author



    Silan Software is one of the India's leading provider of offline & online training for Java, Python, AI (Machine Learning, Deep Learning), Data Science, Software Development & many more emerging Technologies.

    We provide Academic Training || Industrial Training || Corporate Training || Internship || Java || Python || AI using Python || Data Science etc





     PreviousNext