Tagged Questions
3
votes
1answer
252 views
Curious Database building Problem (ER Diagram)
I am trying to build an EER Model for a Autostore that has 5 locations and offers a range of auto products. They offer car repairs and roadworthy tests as a service also.
I need to be able to make ...
2
votes
1answer
117 views
Schema for 1 <-> 0..1(+), many related but only one primary
Using tools available in SQL Server 2008 and Entity Framework, what is a solid way to represent a one-to-many relationship, where there is an underlying unique relation that I need to enforce? My ...
1
vote
1answer
137 views
Referring to super parent or as a separate entity?
I have this person table as super parent,
id
firstname
lastname
email
telephone
...
...
and user table as a child
id
person_id (FK)
password
username
screenname
...
...
They must be 1:1 ...
0
votes
1answer
1k views
SQL keyword difference between MySQL and Oracle 10g?
Good afternoon,
Are there differences between Oracle 10g and MySQL with the CREATE, ALTER, DROP, REF, PRIMARY KEY, FOREGIN KEY and attribute variable type keywords?
The reason I ask, is I'm planning ...
3
votes
4answers
616 views
How can I generate an Entity-Relationship diagram and SQL DDL from natural language text?
Good morning,
Using LaTeX or another text-macro tool/library, how can I use natural language text to describe relationships, then generate an Entity-Relationship Diagram and generate SQL DDL to ...
