New topic: Optimal database-design? help please
<http://forums.realsoftware.com/viewtopic.php?t=32415> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Goofie Post subject: Optimal database-design? help pleasePosted: Tue Feb 09, 2010 7:59 am Joined: Tue Nov 13, 2007 11:48 am Posts: 128 Location: Belgium I want to convert a one-dimensional excell "on call" list to a database. I can think of ways that could help, but i'm hoping for a 'perfect 'fit, with all logic in the database and not in RB-code. Let me try to explain what i want to accomplish: Every day of the year, there is a first responder, second responder and third responder (obligatory), fourth and fifth responder can be on holiday. The team consists of five responders. First has the "highest" workload, then second, etc. I was thinking of a table design with columns: TABLE WORKLOAD: pk, date, first, second, third, fourth, fifth, holiday (I worked out holiday to be of type set, since more than one person can be on holiday) Can i use "set" to distribute the other values between first, second and third, you can only be one at a time Do you have to use an elaborate sql-query on each insert, or let REAL do al the math to see if an entry in a record is valid, or can i leave the logic to the database? 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]
