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 -~----------~----~----~----~------~----~------~--~---
