New topic: Some very basic database questions...
<http://forums.realsoftware.com/viewtopic.php?t=45748> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Kabe Post subject: Some very basic database questions...Posted: Sun Oct 28, 2012 12:33 pm Joined: Mon Apr 09, 2007 2:49 pm Posts: 188 I'm thinking of moving a rather simple data model of a Realbasic Web application into a true database. Though I structurally have some understanding of data bases, I'd like to avoid painting myself into a corner here, so any input is appreciated. It's basically 3 entities with a couple of simple attributes. Each oif thos entities is n:m related to the others: When displaying any of those entities in a list, the count of related objects should be listed as well, so i.e. you can see how many persons have been at a place or how many courses have taken place there. I assume that usually each of these relations would need an own table for each of the pair relations: Obviously this is a lot of boilerplate stuff which I'd rather like to avoid. I'd also like to know how to come from that structural view to an implementation. How would such a model be created in RealBasics Database editor? How to add a relation between two entities?How to get the count of those relations for an entity? Would using Valentina make thinks easier by reducing âboilerplate tablesâ?If yes, which of the many Valentina products would I need? Thanks for reading this, and thanks for any helful pointers! Klaus Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ]
-- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
