Entities: An entity can be a person, place, thing, or any identifiable object for which data can be stored in a database.
For example, in a company’s database, employees, projects, salaries, etc., can be referred to as entities.
Relationships: A relationship between entities can be referred to as a connection between two tables or entities.
For example, in a college database, the student entity and the department entity are associated with each other.
That ends the section of basic interview questions. Let us now move on to the next section of intermediate interview questions.
Intermediate SQL Interview Questions and Answers