Database entitiy definition:
An database entitiy is a material or non-material structure which has its own attributes.
Database entitiy example:
A good example of database entity can be a simple table that contains set of some data.
To show it, let’s take an example of shop database which is composed of 2 tables (entities): Sellers and Products.
Sellers table presents data about shop sales staff. This entity (table) has 2 attributes: SELLER_NAME (this column shows data about names of sellers) and ID_SELLER (ID_SELLER column contains unique identyfication number assigend to each seller).
- Sellers (entity)
- SELLER_NAME (attribute of Sellers entity)
- ID_SELLER (attribute of Sellers entity)
Products table shows data about products that our shop are currently offering. Products entity has also 2 attributes: PRODUCT_NAME (this column presents product names) and ID_PRODUCT (ID_PRODUCT column presents unique identyfication number assigend to each product).
- Products (entity)
- PRODUCT_NAME (attribute of Products entity)
- ID_PRODUCT (attribute of Products entity)
Copyright © 2015-2016 • All Rights Reserved • database-definition.com