can i relate an entity with three other entities(weak) over an identifying relationship. For example, an entity item is related to three other entities book_item,cd_item and magazine_item over a "is a" relationship.(book_item,cd_item and magazine_item are weak entities)is this possible ?
relating entities in an ER diagram
124 Views Asked by Hope to learn something here At
1
There are 1 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in RELATIONSHIP
- Erwin API question adding relationships to model
- Laravel Relationship Using An OR Condition on the joining field
- Displaying country and capital names instead of IDs on Laravel order page
- Several relationships in one model in Laravel
- How to map many-to-one relationship?
- Laravel 11 Staudenmeir BelongsToThrough Undefined Relationship
- Directus Relationship problems on update or create entities
- Displaying and hiding links based on access permissions
- uml class diagram for boxing match
- How to eager load both forward and backward relationships in SQLAchemy one-to-many relation
- I have a basic ms access question about a relationship between 3 tables
- drizzle: db.query throwing undefined is not an object (evaluating 'relation.referencedTable')
- How to avoid cyclic relationships in EF Core 8
- EF Core 8 : getting grand children from grandparent
- Power BI - how to deal with a limited relationship when creating a measure?
Related Questions in ENTITY-RELATIONSHIP
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- How do i normalize the given entities in the database ER diagram. And also shouldn't normalization be done before making the ER diagram?
- I need help in creating a ER model for my database
- NER grouping into objects
- Issue with Setting Relationships in Business Entity when Creating New Business with Associated Services and Workers
- How to model composite primary keys in the ER model?
- An associative Entity with optional participation on one side and mandatory participation on the other
- ER diagram: total participation and identifying relationship
- Were the entity sets and their associated relationships accurately and properly constructed?
- ER diagroms Composite Key representation in m;n relationship
- Kotlin [Hilt] java.lang.reflect.InvocationTargetException (no error message) Error
- Adding relationship to an Entity couses weird ORM mapping error
- Is this a correct foreign key relationship standard?
- Is combining a Junk Dimension with a Conformed Dimension in a single table advisable for efficient data management?
- Why is my slicer not filtering values correctly for me for 2 different matrix?
Related Questions in ER-DIAGRAM
- Normalisation for database ER diagram
- Creating ER diagram for SQL Server database
- ER Model clarification of my diagram
- Transfer mysql to access including relationships and foreign keys?
- relating entities in an ER diagram
- Relational Schema to ER Diagram
- How to create relational mapping when an entity has more than one multivalued attribute in ER Diagram
- Database design: multiple unary relationships on same entity
- Relationship with same entity - ER Diagrams
- Using ONLY Entity Relationship Diagram to Query MYSQL Format [BRAIN CHALLENGE]
- ER Diagram Entity without attribute
- Relations in ER diagram
- Looking for an ERD for this three-way relationship
- ER diagram relationship and Bridge Tables
- Representing multiple candidate keys in RM
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
While subtyping can be represented as an identifying relationship without a weak key in classic ER diagrams, it's best to distinguish the concepts. A subtype is a subset, meaning identity isn't changed in the process. A subtype of a regular entity set is still regular, a subtype of a weak entity set is weak.
This is different from parent/child entity sets wherein children are identified via the parent identifier and a weak key. Weak children are a different entity set from their parents, whereas subtypes are a subset of the same entity set.
I suggest you use one of the subtyping notations of EER diagrams, and don't mix identifying/weak terminology with subtyping/supertyping, unless for an academic exercise in classic ER.