Entities-
A person, place, or things in real world about which data can be stored in a database. Tables store data that represents one type of entity.
Example - A Bank database has a customer table to store customer information. Customer table stores this information as a set of attributes (columns within the table) for each customers.
Relationships-
Relation or links between entities that have somethings to do with each other.
Example - The customer name is related to the customer account number and contact information, which might be in the same table, There can also be relationships between separate tables (for example, customer to accounts)
Answers (0)