If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > E-R diagram for a database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2008
Posts: 4
E-R diagram for a database

Hello
i have a database where i have some types of pizza, and their composition(stored in Reteta, in numeComponenta). e.g.: sauce,mayonnaise,mushrooms, etc, for each pizza.
And i also have an Incompatibilities table, where i have id1 and id2, and i wanna, for example if id1=3 and id2=6, the components 3 and 6 to be incompaible. how can i do this?
so, for example i have:

Componente
idComponenta NumeComponenta
1 sauce
2 mayonnaise

if in Incompatibilitati id1=1 and id2=2, sauce and mayonnaise are incompatible, and i cannot insert them into a pizza, as composition
i have this problem just at the relationship between Incompatibilitati and Componente, other relations are ok.
Thanks!
Attached Files
File Type: zip pizzerie_ex.zip (15.6 KB, 117 views)
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: May 2008
Posts: 4
noone can help me with this relationship?
Reply With Quote
  #3 (permalink)  
Old
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 20,000
you posted in the middle of the night (north american time) and then waited only 4 hours

heck, everybody is still asleep, man!

please wait at least 24 hours before posting a "bump" message, preferably 48 hours on the weekend

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: May 2008
Posts: 4
well.. sorry
so, if someone wakes up and can help me, i'll be thankful
Thanks
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Sep 2007
Location: Global Village
Posts: 185
as far as this incompatibility doesn't follow any logic and is depend on cook decision, if it was up to me I would leave the component selection to chef or try to give a logic to it to be able to help you.
good luck
Reply With Quote
  #6 (permalink)  
Old
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 20,000
another thing you should consider is that some people, who might know access and ER diagrams quite well, may yet not have the necessary software to look at your posted file

it is always best to try to describe your problem in plain text
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: May 2008
Posts: 4
ok, i'll describe my problem in plain text:
so i have to manage the activity into a pizzery.
i have made the tables, and i also added an Incompatibility table(with 2 columns, id1 and id2). i have also the table Componente (Components), with idComponent and componentName (e.g. mayonnaise, sauce, etc)
if id1=4 and id2=3 for example, i wanna that the name of the components with id 4 and 3 to be incompatible(i cannot operate with them, i cannot attribute to a pizza 2 incompatible components)
i have attached the diagram, so what i need more in this diagram, to make it functional?

p.s. Reteta is the intermediary table between pizza and Components, relation between pizza and Componente being n:m
Attached Thumbnails
E-R diagram for a database-pizza.jpg  
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On