This is a portion of a Gaming Company Chen diagram that I need to convert to a database. How do I know which entity will get the attributes LastPlayed and CreatedOn? I feel like I could make a case for either entity. It could be the LastPlayed and Created on of the Account or the Character. Is there a rule for this? TIA
Chen ERD Relationship Attributes
266 Views Asked by ITGirl 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 DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
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 ERD
- Moodle Database - Reverse Engineering ERD
- An associative Entity with optional participation on one side and mandatory participation on the other
- ER diagroms Composite Key representation in m;n relationship
- How to specify relation based on a condition in Entity Relationship Diagram (ERD)?
- Is there any identifying or non-Identifying relationship in this ERD?
- Which Lucidchart license is required for import data to directly get metadata from database to create ERD?
- erd diagram Car buying and selling website
- is it allowed to leave an attribute empty in the Entity–relationship model?
- One to many relationship in Product Ordering System with Crow's Foot Notation
- Can an Identifying relationship be one-to-one?
- How to model a complex relationship involving a Weak Entity and entities related to its parents?
- Mermaid Entity-Relationship diagram in top-down layout
- Relations between entities in ER diagram: can they have a key?
- Total Disjoint vs U-type in EERD
- Do Entity-Relationship diagrams need attributes to represent relationships?
Related Questions in CONCEPTUAL
- Multiprocessing/ Threading / asyncio for PyQt6 and python-can
- In a loop what's the best practice to get input (cli) with validation, that also resumes like this?
- Should I have most of my code in the with statement? Python
- What type of datastructure does 'collections.defaultdict(set)' create?
- Finding the right approach for creating an accumulated information table
- Unable to add a generic concrete type to a list of generic interface
- Time complexity of the following two programs?
- Conceptual workflow for python app API store data for reporting usage
- Shopware 6 administration: on create new product, price cannot be null
- Why is the "multiple .c files + linker" workflow is preferred over "multiple .h files included in one .c file"?
- What do files actually contain, and how are they "read"? What is a "format" and why should I worry about them?
- Technical concept for a timeline-scheduler
- How to start a process with multiple threads right from the beginning?
- Best way to store date in a CDM (Conceptual Data Model)?
- Is every variable and register name just a pointer in NASM Assembly?
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?

The attributes you show belong to the relationship, and not either of the entities. In this case, practically speaking implementation would make them part of the (N) side of the relationship, that is, the Character entity.
The distinction between entity-attributes and relation-attributes only really matters for many-to-many relations that have to be implemented by converting the relation into its own table.