Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 63644
11 votes
Accepted

Which one is an ER diagram?

One can say that a proper entity-relationship diagram is that which was created using the constructs introduced by Dr. P. P. Chen (e.g., rectangular and diamond-shaped boxes) in his famous 1976 paper …
MDCCL's user avatar
  • 8,540
13 votes
Accepted

Best data modelling approach to handle redundant foreign keys in a database about Surveys, Q...

As per my understanding of your specifications, your business environment involves a conceptual-level ternary relationship. In this regard, you need to define: the relationship (or association) type …
MDCCL's user avatar
  • 8,540
3 votes

Does adding a surrogate key get rid of an identifying relationship between two entities?

For reasons of accuracy, it is indispensable to know the informational characteristics of the business environment under consideration thoroughly so as to supply a proper database design answer but, i …
MDCCL's user avatar
  • 8,540
7 votes
Accepted

How to model a Letter Transportation business context in a database diagram?

Although you stated that the structure depicted in your diagram is part of a university project, the objective should be to make it as realistic as possible, so I consider that carrying out an intervi …
MDCCL's user avatar
  • 8,540
9 votes
Accepted

Entity-relationship diagrams and application program functionalities

ERDs: graphical representations of conceptual schemas An ERD depicting the associations and the corresponding cardinality ratios of a certain scenario is not supposed to solve “the problem of digitizing … Levels of abstraction: application program components, ERD symbols and relational/SQL instruments Since you mention “tables”, I assume that you have the intention of building a relational database, and …
MDCCL's user avatar
  • 8,540
14 votes
Accepted

Conceptual ERD Multi-table many to many, or possibly recursive?

LocationAddress and ProfileAddress] - for I obviously wanted to rush in and hold them all without the correct relations [funnily, It didn't feel right with my original ERD]. …
MDCCL's user avatar
  • 8,540
21 votes

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

Using entity-relationship constructs to represent a conceptual model with supertype-subtype structures You asked for an entity-relationship diagram (ERD for brevity) but, although being an extraordinary …
MDCCL's user avatar
  • 8,540
4 votes
Accepted

How can I represent the entity types depicted in an ERD as relations with attribute names?

Considering the Course entity type that you describe, I have made the following assumptions: A Course is primarily identified by its CourseNumber A Course is alternately identified by its Name A Cou …
MDCCL's user avatar
  • 8,540