It's UWAweek 42 (2nd semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 612 articles.
Currently 119 other people reading this forum.


 UWA week 35 (2nd semester, week 6) ↓
SVG not supported

Login to reply

👍?
helpful
7:23pm Thu 29th Aug, Adam W.

Hi Harrison,

'Entity: Entity is a concept to abstractly represent all instances of a group of similar “things”.

Entity Type: It is collection of entity having common attribute.

Entity Instance: An entity instance is a single occurrence of an entity.'

from https://stackoverflow.com/questions/54722484/whats-the-difference-between-entity-entity-type-and-entity-instance#:~:text=Entity%3A%20Entity%20is%20a%20concept,single%20occurrence%20of%20an%20entity.

At this stage everything is still conceptual, so you're trying to identify all of the concepts that need to be stored in the database, we also have specialisations and generalisations of entities, and enhanced ER modelling too, so you have to look at it all a little more abstractly.

Thanks, Adam.

"Harrison Lisle" [email protected] wrote:

Hello!

I'm having trouble distinguishing between an entity and an entity type.

The textbook says that an entity is a "distinct object that is to be represented in the database". The examples of entities it gives are:

  • Branch
  • Staff
  • PropertyForRent
  • Client
  • PrivateOwner
  • Lease

The textbook also defines an entity type as "a group of objects in the real world with the same properties", then goes on to say that we can give "only a working definition of an entity type" listing examples as:

  • Staff
  • PropertyForRent

Those both have the same examples! And they both seem to be represented the same way (rectangles) in ER diagrams, so how do they differ? Is an entity a single instance of an entity type, or is that an entity occurrence?

Thank you!

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy