freelanceprogrammers.org Forum Index » ASP
Relational Database Design Group
Joined: 10 Jan 2006
Posts: 33
Relational Database Design Group
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 |
travis.falls@...
*************************************************************************
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.
*************************************************************************
Joined: 10 Jan 2006
Posts: 12
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) <travis.falls@...> 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 |
> travis.falls@...
>
>
>
> *************************************************************************
> 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
>
>
>
>
>
>
>
>
Joined: 10 Jan 2006
Posts: 33
Relational Database Design Group
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 |
travis.falls@...
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com]On Behalf Of mischa kroon
Sent: Thursday, June 23, 2005 2:26 PM
To: AspNetAnyQuestionIsOk@yahoogroups.com
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) <travis.falls@...>
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 |
> travis.falls@...
>
>
>
> *************************************************************************
> 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
Joined: 11 Jan 2005
Posts: 2
Relational Database Design Group
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)"
<travis.falls@...> 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 |
> travis.falls@...
>
>
> -----Original Message-----
> From: AspNetAnyQuestionIsOk@yahoogroups.com
> [mailto:AspNetAnyQuestionIsOk@yahoogroups.com]On
> Behalf Of mischa kroon
> Sent: Thursday, June 23, 2005 2:26 PM
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> 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)
> <travis.falls@...>
> 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 |
> > travis.falls@...
> >
> >
> >
> >
>
*************************************************************************
> > 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/
>
>
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
>
>
>
>
>
Joined: 25 Jun 2005
Posts: 5
Relational Database Design Group
While objDataReader.Read()
I have code that ckecks if the record count is > than 6 and if so I want the
datareader to not read more records and move the pointer to the end so that
when it hits the end while statement it will think it has read all the
possible records and be done. Is there a command to do this?
Joined: 27 Dec 2004
Posts: 3
Relational Database Design Group
you can contact me directly concerning help woth relational database design. I
can help you!
joe.antonaccio@...
Joe
----- Original Message -----
From: Falls, Travis D (HTSC, CASD)
To: `AspNetAnyQuestionIsOk@yahoogroups.com`
Sent: Thursday, June 23, 2005 1:59 PM
Subject: [AspNetAnyQuestionIsOk] Relational Database Design Group
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 |
travis.falls@...
*************************************************************************
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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
b.. To unsubscribe from this group, send an email to:
AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Joined: 24 Jun 2005
Posts: 3
Relational Database Design Group
You could try (in both senses!)
int readRecordsCount = 0;
while(reader.Read())
{
// do some stuff...
if(readRecordsCount++ > 6)
break;
}
reader.Close();
hth,
Ian
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com] On Behalf Of Mike Belcher
Sent: 23 June 2005 22:59
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: RE: [AspNetAnyQuestionIsOk] Relational Database Design Group
While objDataReader.Read()
I have code that ckecks if the record count is > than 6 and if so I want the
datareader to not read more records and move the pointer to the end so that
when it hits the end while statement it will think it has read all the
possible records and be done. Is there a command to do this?
Yahoo! Groups Links
Joined: 25 Jun 2005
Posts: 5
Relational Database Design Group
What I did is make a variable in the while loop and at the I had added a AND
to it....... works great.
While objDataReader.Read() And intTotalMatches < 8
so when it is 8 it breaks out.................. :)
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com] On Behalf Of Ian Payne
Sent: Friday, June 24, 2005 8:56 AM
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: RE: [AspNetAnyQuestionIsOk] Relational Database Design Group
You could try (in both senses!)
int readRecordsCount = 0;
while(reader.Read())
{
// do some stuff...
if(readRecordsCount++ > 6)
break;
}
reader.Close();
hth,
Ian
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com] On Behalf Of Mike Belcher
Sent: 23 June 2005 22:59
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: RE: [AspNetAnyQuestionIsOk] Relational Database Design Group
While objDataReader.Read()
I have code that ckecks if the record count is > than 6 and if so I want the
datareader to not read more records and move the pointer to the end so that
when it hits the end while statement it will think it has read all the
possible records and be done. Is there a command to do this?
Yahoo! Groups Links
Yahoo! Groups Links
Joined: 07 Jan 2006
Posts: 63
Relational Database Design Group
If you really only want n records .net can fill a DataTable with n records.
Probably a better choice than asking .net for all records and then stopping.
There is also a Top command that should be used. Select TOP 8 * from
blah or somesuch.
On 6/24/05, Mike Belcher
<AspNetAnyQuestionIsOk@...> wrote:
> What I did is make a variable in the while loop and at the I had added a
> AND
> to it....... works great.
>
> While objDataReader.Read() And intTotalMatches < 8
>
>
> so when it is 8 it breaks out.................. :)
>
>
> -----Original Message-----
> From: AspNetAnyQuestionIsOk@yahoogroups.com
> [mailto:AspNetAnyQuestionIsOk@yahoogroups.com] On Behalf
> Of Ian Payne
> Sent: Friday, June 24, 2005 8:56 AM
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Subject: RE: [AspNetAnyQuestionIsOk] Relational Database Design Group
>
> You could try (in both senses!)
>
> int readRecordsCount = 0;
> while(reader.Read())
> {
> // do some stuff...
> if(readRecordsCount++ > 6)
> break;
> }
> reader.Close();
>
> hth,
> Ian
>
> -----Original Message-----
> From: AspNetAnyQuestionIsOk@yahoogroups.com
> [mailto:AspNetAnyQuestionIsOk@yahoogroups.com] On Behalf
> Of Mike Belcher
> Sent: 23 June 2005 22:59
> To: AspNetAnyQuestionIsOk@yahoogroups.com
> Subject: RE: [AspNetAnyQuestionIsOk] Relational Database Design Group
>
> While objDataReader.Read()
>
>
> I have code that ckecks if the record count is > than 6 and if so I want
> the
> datareader to not read more records and move the pointer to the end so that
> when it hits the end while statement it will think it has read all the
> possible records and be done. Is there a command to do this?
>
>
>
>
>
> 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:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help