What are Entities and Relationships?
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)
0 Answers
0Be the first to answer this interview question.
Your Answer
Sign in to post your answer and help the community.