Hi Nicholas, > I have this data >http://files.nicholasorr.com/data.html
I don't mean to be rude, but looking at this data, this looks *exactly* like a homework assignment. I mean, the contrived data combined with the answers it's expected to satisfy, there's just no question in my mind. If this is homework, you're probably better off admitting that up-front. Also you're unlikely to find help in an online forum for such tasks unless you provide all the code examples you've done, including the exact code that didn't work. You should also try to explain why you thought each code example should have worked, and ask for specific help to explain where you went wrong. If you post your code on gist.github.com or pastie.org and provide the link in future emails you'll have better results. > 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. As I mentioned to you in IRC, you're best approach to data modeling is to sit down with a pencil and paper and draw out the diagrams of how things relate. Writing the model code before figuring out the proper relations between the entities is likely the backwards approach when you're just learning. In fact I almost never write code without first sketching a rough outline of my entities, how they relate and the key data each entity contains. If you're looking for help with learning database modeling and design I'd like to recommend two of my favorite books on the subject: Database Design for Mere Mortals http://www.amazon.com/dp/0201752840 Data Modeling Essentials http://www.amazon.com/dp/0126445516 The first book "Database Design for Mere Mortals" was especially helpful when I first really got into database design, and it comes highly recommended. Dan (dkubb) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
