I actually have a good amount of experience and have read several books on data modeling. I am having a dumb moment. I am trying to create tables to replace a flat file that is used for a call list. When a person goes on call their call list file is set as active. They define Periods which are associated to day of the week and start/end times. For example my file might depict the following scenario:
Monday-Thursday from 8am to 3:59pm for problems of type 0 use this list of numbers Monday-Thursday from 4pm to 7:59am for problems of type 0 use this list of numbers Monday-Thursday from 8am to 3:59pm for problems of type 1 use this list of numbers Monday-Thursday from 4pm to 7:59am for problems of type 1 use this list of numbers Friday from 8am to 3:59pm for problems of type 0 use this list of numbers Friday from 4pm to 7:59am for problems of type 0 use this list of numbers Friday from 8am to 3:59pm for problems of type 1 use this list of numbers Friday from 4pm to 7:59am for problems of type 1 use this list of numbers Saturday-Sunday from 8am to 3:59pm for problems of type 0 use this list of numbers Saturday-Sunday from 4pm to 7:59am for problems of type 0 use this list of numbers Saturday-Sunday from 8am to 3:59pm for problems of type 1 use this list of numbers Saturday-Sunday from 4pm to 7:59am for problems of type 1 use this list of numbers Another person may define serveral other different time break downs. This is going to be used for a Telphony application I am writing. I hate the current systems's flat file; it is cumbersome to maintain and people make mistakes all the time with it. I want to either do a relational database (SQL Server) or an XML schema. I just can't picture this one... basically the reference tables to accomplish what I want. I want to keep this in 3rd normal form but not Boyce/Codd. I think every determinant is a candidate key is over kill for this. Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of mischa kroon Sent: Thursday, June 23, 2005 2:26 PM To: [email protected] Subject: Re: [AspNetAnyQuestionIsOk] Relational Database Design Group I think the best thing is just getting a good book for this or reading up on some websites about normalisation. If you have any further questions about your database design you can always try here. On 6/23/05, Falls, Travis D (HTSC, CASD) <[EMAIL PROTECTED]> wrote: > I need some help designing a relational database. Do anyone know of a > good/active group for this? > > Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | > [EMAIL PROTECTED] > > > > ************************************************************************* > PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is > for the exclusive use of addressee and may contain proprietary, > confidential and/or privileged information. If you are not the intended > recipient, any use, copying, disclosure, dissemination or distribution is > strictly prohibited. If you are not the intended recipient, please notify > the sender immediately by return e-mail, delete this communication and > destroy all copies. > ************************************************************************* > > > > > Yahoo! Groups Links > > > > > > > > Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
