Question : I’m creating a simple dabase design with three entities and have a question about the relationships between my […]
Tag: erd
Designing a database with a single valued attribute related to multiple entities
Question : Here a customer can submit an order for one or many products . so, there is a one […]
ER-Model to relational mapping
Question : “Fundamentals of Database Systems” by Ramez Elmasri covers this topic extensively, I’ve gone through it and seemingly the […]
In a one-to-one relationship, where should the foreign key be placed?
Question : I am currently designing an ERD for a project management system. I am unable to choose between two […]
How to design a complex multi approval expense db schema in MySQL
Question : I’m very beginner in database design and had the following problem to solve. DB schema design for an […]
How to handle versions of an Entity in Database Design
Question : I am working on a new project. The domain logic of the project is as follows: A user […]
How to represent the relationship between artists and albums in an entity-relationship diagram
Question : I’m learning and practicing with the E-R model trying to design a music industry database. With this section […]
How do we express a weak entity to be dependent on another weak entity?
Question : Perhaps I am looking at my entities as a hierarchy rather than a set of relationships; for sake […]
Help me to create correct ER Diagram [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
ER diagram to Relational Schema (Many to Many relationship)
Question : In this ER diagram, can anyone explain how we should convert the many to many relationships (‘view’, ‘update’ […]