Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between "Entity" and "Record"?

While studying for my IT exam I came across the following sentence:

"A collection of fields that store information about a certain entity, is a record. A record is a whole row of fields."

..but I have always thought that the correct term for an "object" in a database is an "entity".

So is the correct term an "entity" or a "record"? Or are they the same?

like image 549
charlos Avatar asked Oct 18 '25 04:10

charlos


1 Answers

In that sentence, entity doesn't refer to anything in the database. It's using entity to refer to a conceptual object, whatever thing in the real world the database record represents. For instance, if you have an inventory database, each row stands for a product in the warehouse, and that's the entity.

like image 62
Barmar Avatar answered Oct 21 '25 04:10

Barmar



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!