How to normalize a recursive relationship? (Conceptual to logical)
637 views Asked by Crystacune At
1
There are 1 answers
Related Questions in SCHEMA
- Elasticsearch schema for multiple versions of the same text
- SQL Schema recommendations
- How does an LDAP Client eg Apache Directory Studio get schema from an LDAP Server?
- Looping functoid, Mapping
- No Synchronize Model with Database in Mysql Workbench
- XML Namespace URI with HTTPS?
- sqlite schema has quotes around table name after a table rename
- Group many postgresql databases into separate schemas into same database
- MongoDB: updating an array in array
- How to open an android application from browser
Related Questions in RDBMS
- Hierarchical RDBMS Query spanning across multiple tables with in clause
- Why I can't perform this simple insert operation? How can I solve this date format issue?
- How to import only new data by using Sqoop?
- Making relational algebra equations in a sample database
- adding a where condition for one criteria in sql query
- What happens to sql views, if database is moved to another server
- Why I can't perform this insert query if a specific field value is set to null?
- Star schema role in the Pentaho Mondrian OLAP server
- Can Rails deal with DB uniqueness without index?
- Max. number of subqueries with WHERE clause in MySQL
Related Questions in ERD
- Which normal form does the ER Diagram guarantee?
- relationship between database tables not sharing any foreign key(s) in ERD
- What's diference between entity-relationship and domain-model
- How to represent multi valued subtype in the EERD?
- Ms Visio 2016 does not display attributes when using Entity Relation Diagram
- Is this considered loop in my ERD?
- Add data types ERD
- Database table to keep track of objects
- Is having flag in database better than querying a table every time?
- ERD: Mapping 1:N relationship with attributes to relationship schema
Related Questions in CONCEPTUAL-MODEL
- Is there an absolute model answer for Entity-Relationship diagram?
- Tool for EER Modeling
- Double line coming from an Entity
- Conceptual to relational mappings
- Best way to store date in a CDM (Conceptual Data Model)?
- How to normalize a recursive relationship? (Conceptual to logical)
- Entities for conceptual design
- UML class diagram conceptual schema
- Conceptual model with a constraint
- Concept of comparing numbers with tolerance
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?
Popular Tags
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)
This relationship is employee mentor employees and employees mentored by employee. since this is an Optional both side and one to many relationship, you just need to create a foreign key mentor(Fk) inside the employee table and remove the recursive line form the table.