[Solved] Entity Relationship Model 36

Week 2 Discussion – The Entity Relationship Model

36 Unread replies36 Replies

Defining relationships within a database can improve search capabilities and optimal performance of the database in the long run.

Identify at least two relationship strength types that can be used within the entity relationship model.
Provide a real-world scenario that demonstrates each relationship strength classification, using the classifications.
Be sure to respond to at least one of your classmates’ posts.

reply to student below

Afolabi Ajagbe

1:44pm Apr 15 at 1:44pm

Hello,

An entity in DBMS (Database Management System) is something genuine and this is a real-world object with attributes, which describe the entity’s characteristics. A person, for instance, is an entity with characteristics like name, age, gender, and so on.

In the schema, a strong entity is independent of any other entity. A strong element will constantly have an essential key. A strong entity set is a set that is comprised of serious areas of strength for numerous and is addressed by a single rectangle shape. The connection that exists between two powerful entities is symbolized by a single diamond. Notwithstanding, in the event that the relationship is between a strong entity and a weak entity, the relationship is addressed by a double diamond shape.

A weak entity in DBMS is an entity whose presence relies upon a stronger entity for strength and it doesn’t have its very own essential key. A weak entity is addressed by a twofold rectangle shape.

I recollect half a month prior, I was arranging an excursion to another state and called Lodgings Focal booking registry to assist me with finding a close-by inn to the city downtown. The booking agent was able to find a good hotel, check if they had rooms available on the days I needed to stay there, and then finalize and book the room for me.

This is a modeling of actual entity-to-entity relationships.