One table: CallPersonID CallPersonName CallPersonInfo IsActive(more or less)
next table: CallPeriodID BeginDayOfWeek EndDayOfWeek BeginTime EndTime (you might want to use bytes 0-6 for DayOfweek so that you can calculate stuff or sort) and assuming it is a many slots to many CallPersonID next table: CallListID CallPersonID CallPeriodID no? --- "Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> wrote: > 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 > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > [EMAIL PROTECTED] > > > > > > 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/
