Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: erd
Is it possible for total participation constraints to be enforced by an attribute?
Question : For a school Food Delivery application I am developing, I’ve been told to use the most accurate ER […]
Designing a database which can track stock movements
Question : I work for a manufacturing company which sells machines to customers which have a control unit installed in […]
Creating and querying a database to set hierarchical associations between Groups, Users, Items and Points
Question : I am working with three entity types, Group, User and Item. A Group consists of Users, and a […]
Financial database model
Question : I am completely new to database modelling (except for some academic knowledge from a long time ago) but […]
Can someone give me feedback on my ER diagram?
Question : I am new to creating ER diagrams and was wondering if anyone could review one that I constructed […]
MySQL – Many to Many relationship, or one to many with additional columns
Question : Our product contains some constraints that made us contemplate which table design will yield the best performance. Our […]
Extended Entity-Relationship Diagram: Do the sub classes have foreign keys or primary keys?
Question : Consider this example (they are disjoint, by the way): There are two scenarios which I am guessing: While […]
How can I better model the relationships in this project?
Question : I’m developing an internal tool (as an intern). We deal with a lot of hardware, which is all […]
Does adding a surrogate key get rid of an identifying relationship between two entities?
Question : In the following example, we have a Comments table with a composite primary key (PK) CREATE TABLE Comments […]