|
-
April 26th, 2010, 08:57 PM
#1
Relationship Question
Hey, I'm doing this project for class, and I'm really stuck on how to represent this one relationship in the database. I'm making a party planner application, and there are several types of cakes, so I have a cake table that lists the cakes price, size, etc. Then I have an event table, and each event has a certain number of each type of cake. I don't have a primary/foreign key relationship or anything, but they are related. I simply have the cake table to reference the price and size of each type of cake when needed. Each event includes ALL of the types of cakes, so I dont need to map cakes to events or anything. I want to query the cakes table as being related to the events but i see no such many to many, one to many, or one to one relationship by primary/foreign keys. How am I supposed to represent this as a relationship, since all my tables should be related in the database?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|