Search Results
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 |
Entity Relationship Diagram
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 …
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 …
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 …
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 …
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 …
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]. …
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 …
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 …