Nicholas Orr wrote: > I'm not looking for complete models here, just the relationships. > I've done the models all ready > I also did the relationships that I thought would work. > They don't work. What have you tried already? How do you know it didn't work?
It sounds a bit like a homework problem at the moment... Xavier > > The bit I'm missing is how to have multiple costs that belong to the > product via a lender. Then groups those costs and assign them to a > person. > > On Dec 12, 4:34 pm, Nicholas Orr <[email protected]> wrote: >> I should mention that when someone is creating a rate plan they'd do >> the following. >> >> 1. Create rate plan (they don't give it a name or anything) >> 2. Select a product from the products list >> 3. Select a supplier from the supplier list >> 4. Type in a cost for that product > lender combo >> 5. Go to step 2 until done >> 6. Save >> >> :) >> >> On Dec 12, 4:26 pm, "Nicholas Orr" <[email protected]> wrote: >> >>> Hi, >>> I have this data >http://files.nicholasorr.com/data.html >>> I need to model it. >>> I've come up with these models >>> Person >>> Product >>> Supplier >>> RatePlan >>> Cost >>> These are the questions & expected answers >>> Q: How much does john get beans for? >>> A: acme => $2, nestle => $2.50, pinehurst => $2.25 >>> Q: What products does john have access to? >>> A: beans, apples >>> Q: Who is on Rate 1? >>> A: john, david >>> Q: What products does rate 3 have? >>> A: beans, apples, oranges >>> Q: What suppliers are available? >>> A: acme, nestle, pinehurst, smiths >>> Q: What products are available? >>> A: beans, apples, oranges >>> This is the relationship I see >>> Person > RatePlan > Product > Lender > Cost >>> But I don't know how to setup the models so all the questions above >>> are answered :/ >>> Looking forward to your suggestions :) >>> Thanks, >>> Nick > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
