I know it is possible to convert the entity relationship to a relational model but is it possible to convert the relational model to entity relationship using the same rules? I have looked for it in the internet but people always convert from ER to Relational.
Relational model to entity relationship - Database
200 views Asked by Juan Manuel Amoros At
1
There are 1 answers
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 RELATIONAL-DATABASE
- Creating Relationship Creates Additional Columns in MySQL Workbench
- normalize table up to BCNF?
- Handling relationships with React Query
- Entity Core Framework - what is the difference between HasColumnType and HasPrecision?
- Calculating the sum of differences between two columns in Laravel
- Django - Create a model that holds aggregated Foreign Key values
- Database design for social media app: Handling multiple post types and timeline creation performance
- SQL Database Table relation based on multiple conditions
- NextJS Prisma and MongoDB relation
- Repeat the foreign keys or use two tables related as a one-to-one
- Finding items that match multiple LIKE keywords
- How should I structure my entities and not get the circular reference problem/error?
- How does MySQL compute keys for underlying tree structure
- How to write query for a condition on join table
- `"Key "0" in object with ArrayAccess of class does not exist` error after change of computer
Related Questions in DATA-MODELING
- Does Power BI provide an OOTB Geographical Dimension Table
- Table Restructuring Options in PowerBI
- How to model such that a drill through for Order suppliers having M:1 relation with Order fact table can be configured?
- Excel formula to change sum field depending on date
- How to properly define data models in TypeScript?
- Power Bi - Modelling
- How to create a MySQL table or store the values in the MySQL table if values is of type python list
- Dynamo DB M:N relationship issue
- What data type is appropriate for star schema keys (integer or text)?
- How to fetch data from this Nested JSON using GET method in flutter using Data Model?
- How to model composite primary keys in the ER model?
- LSTM layer in Sequential model requires 3d input but only receives d2
- How can I generate many random community matrices and then apply a function to all of them?
- Model the number of available spots in dimension or fact table?
- How to get data collection from a nested list of a data collection from postman api to list<dynamic> in dart Flutter
Related Questions in ENTITY-DATA-MODEL
- How do I map M:N relationship whose otherside is a weak entity?
- Entity Framework database-first workflow designer failed
- Update model from Firebird database
- Data Model - Regions and Countries
- Getting Error While Setting The data to Sql Db, Saying Cannot set the Value of Created at with Null
- While trying to create entity data model, I get authorization exception
- Entity Data Model Wizard Gets Exception When Trying to Add a New Oracle Connection
- Could not update model from database?
- Visual Studio 2015 and Entity Data Model. Errors when rebuilding after uptating .edmx file
- Relational model to entity relationship - Database
- API to query your Entity Framework context's model?
- Visual Studio 2015 Add new data source wizard missing entity data model
- ADO.NET Entity Data Model vs DataSet vs Entity Framework?
- ADO.NET Entity Framework and ADO.NET Entity Data Model?
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)
The entity-relationship model is a thin interpretation over the relational model. Entity sets are the domains of attributes, value sets are the codomains of attributes, relationship sets are relations over multiple entity sets, and attributes are 1-to-1 binary relations from entities or relationships to values. Any entity-relationship model (and I would venture to say, any data model) can be understood in terms of its domains and relations.
Starting from a relational model, not every relation necessarily conforms to the characteristics of an entity relation or a relationship relation. The relational model doesn't distinguish entities from values, hence is a simpler and more general model of data. However, it's not difficult to normalize, then combine attributes on common determinants to create entity relations and create relationship relations from relations over multiple entities.