|
 |
asp_databases thread: Database table design questions
Message #1 by dont worry <aspmailbox@y...> on Thu, 24 Jan 2002 08:35:06 -0800 (PST)
|
|
I need a outside opinion please.
<A> User table - user info
<B> Class table - class info
<C> Class assignment table - Bridge table for users
taking a class
<D> Class section table - A class can have many
sections
I'm trying to figure out where and what type of table
to use to post user results. The results table
(pass,attend,paid) will be used as a history table to
back track. Should the results table be keyed off the
<D> section table? or <C> class assignment table?
Thanks
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
Message #2 by "Drew, Ron" <RDrew@B...> on Thu, 24 Jan 2002 11:47:14 -0500
|
|
If a student can take only one section <D> of a class <C>...then the
info should go in <D>
If a student has to take all sections of a class <C> ...then the info
should go in <C>
-----Original Message-----
From: dont worry [mailto:aspmailbox@y...]
Sent: Thursday, January 24, 2002 11:35 AM
To: ASP Databases
Subject: [asp_databases] Database table design questions
I need a outside opinion please.
<A> User table - user info
<B> Class table - class info
<C> Class assignment table - Bridge table for users
taking a class
<D> Class section table - A class can have many
sections
I'm trying to figure out where and what type of table
to use to post user results. The results table
(pass,attend,paid) will be used as a history table to
back track. Should the results table be keyed off the
<D> section table? or <C> class assignment table?
Thanks
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
$subst('Email.Unsub').
Message #3 by dont worry <aspmailbox@y...> on Thu, 24 Jan 2002 09:45:10 -0800 (PST)
|
|
Ron,
If a class is more than 1 day it will have multi
sections. A student is signed up for all sections by
default, but they might miss a section. My first
thought was to have a user results table keyed off the
<C> class assignments table.
--- "Drew, Ron" <RDrew@B...> wrote:
> If a student can take only one section <D> of a
> class <C>...then the
> info should go in <D>
> If a student has to take all sections of a class <C>
> ...then the info
> should go in <C>
>
> -----Original Message-----
> From: dont worry [mailto:aspmailbox@y...]
> Sent: Thursday, January 24, 2002 11:35 AM
> To: ASP Databases
> Subject: [asp_databases] Database table design
> questions
>
>
> I need a outside opinion please.
> <A> User table - user info
> <B> Class table - class info
> <C> Class assignment table - Bridge table for users
> taking a class
> <D> Class section table - A class can have many
> sections
>
>
> I'm trying to figure out where and what type of
> table
> to use to post user results. The results table
> (pass,attend,paid) will be used as a history table
> to
> back track. Should the results table be keyed off
> the
> <D> section table? or <C> class assignment table?
>
> Thanks
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> $subst('Email.Unsub').
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
Message #4 by "Drew, Ron" <RDrew@B...> on Thu, 24 Jan 2002 13:32:16 -0500
|
|
I would think student ID should be in <C> for pass,attend,paid because
the pass/paid relates more to the class not section in this case. Since
the attend relates to the section (I think) you may want to add the
student ID for each section then you can total all sections for a
student and determine how many were attended of the total sections for
the class. Just my thoughts...Basically it is your choice on how you
want to design the structure of your system and what your expectations
are for measurements.
Good Luck :)
-----Original Message-----
From: dont worry [mailto:aspmailbox@y...]
Sent: Thursday, January 24, 2002 12:45 PM
To: ASP Databases
Subject: [asp_databases] RE: Database table design questions
Ron,
If a class is more than 1 day it will have multi
sections. A student is signed up for all sections by
default, but they might miss a section. My first
thought was to have a user results table keyed off the
<C> class assignments table.
--- "Drew, Ron" <RDrew@B...> wrote:
> If a student can take only one section <D> of a
> class <C>...then the
> info should go in <D>
> If a student has to take all sections of a class <C>
> ...then the info
> should go in <C>
>
> -----Original Message-----
> From: dont worry [mailto:aspmailbox@y...]
> Sent: Thursday, January 24, 2002 11:35 AM
> To: ASP Databases
> Subject: [asp_databases] Database table design
> questions
>
>
> I need a outside opinion please.
> <A> User table - user info
> <B> Class table - class info
> <C> Class assignment table - Bridge table for users
> taking a class
> <D> Class section table - A class can have many
> sections
>
>
> I'm trying to figure out where and what type of
> table
> to use to post user results. The results table
> (pass,attend,paid) will be used as a history table
> to
> back track. Should the results table be keyed off
> the
> <D> section table? or <C> class assignment table?
>
> Thanks
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> $subst('Email.Unsub').
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
$subst('Email.Unsub').
Message #5 by "Scott Reed" <scottr@m...> on Thu, 24 Jan 2002 12:02:09 -0600
|
|
It sounds like you want to track Pass/Fail, Attend/Absent
and Paid/Unpaid for each User.
If that is the case, I would make 3 Boolean fields in
the User Table for Attend, Pass and Paid.
When you collect this information (and other info about
classes and sections(whatever)), do it with a script. Dumping
this info into it's own table would require a more complicated
relationship with the user and I don't see a benefit.
-----Original Message-----
From: dont worry [mailto:aspmailbox@y...]
Sent: Thursday, January 24, 2002 10:35 AM
To: ASP Databases
Subject: [asp_databases] Database table design questions
I need a outside opinion please.
<A> User table - user info
<B> Class table - class info
<C> Class assignment table - Bridge table for users
taking a class
<D> Class section table - A class can have many
sections
I'm trying to figure out where and what type of table
to use to post user results. The results table
(pass,attend,paid) will be used as a history table to
back track. Should the results table be keyed off the
<D> section table? or <C> class assignment table?
Thanks
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
$subst('Email.Unsub').
Message #6 by dont worry <aspmailbox@y...> on Thu, 24 Jan 2002 13:09:28 -0800 (PST)
|
|
Scott Reed,
Yes I want to track this,
1 A user can pass/fail/attend/absent MANY classes.
Each class can be divided into MANY sections. A user
can (pass/fail/attend/absent) each section of a class.
I'm having a brain stump on how to maintain a history
for each class a user takes and if they
(pass/fail/attend/absent) each section of each class.
Also, should I use nvarchar for simple text like
names, descriptions or varchar and should I use
numeric or int for numbers like user_id and prices of
the classes.
Thank you,
DW
--- Scott Reed <scottr@m...> wrote:
> It sounds like you want to track Pass/Fail,
> Attend/Absent
> and Paid/Unpaid for each User.
>
> If that is the case, I would make 3 Boolean fields
> in
> the User Table for Attend, Pass and Paid.
>
> When you collect this information (and other info
> about
> classes and sections(whatever)), do it with a
> script. Dumping
> this info into it's own table would require a more
> complicated
> relationship with the user and I don't see a
> benefit.
>
>
>
> -----Original Message-----
> From: dont worry [mailto:aspmailbox@y...]
> Sent: Thursday, January 24, 2002 10:35 AM
> To: ASP Databases
> Subject: [asp_databases] Database table design
> questions
>
>
> I need a outside opinion please.
> <A> User table - user info
> <B> Class table - class info
> <C> Class assignment table - Bridge table for users
> taking a class
> <D> Class section table - A class can have many
> sections
>
>
> I'm trying to figure out where and what type of
> table
> to use to post user results. The results table
> (pass,attend,paid) will be used as a history table
> to
> back track. Should the results table be keyed off
> the
> <D> section table? or <C> class assignment table?
>
> Thanks
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> $subst('Email.Unsub').
>
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
Message #7 by "Scott Reed" <scottr@m...> on Thu, 24 Jan 2002 16:10:05 -0600
|
|
I would just like to mention that my replies have about a
3-4 hour delay. =8(
-----Original Message-----
From: Scott Reed [mailto:scottr@m...]
Sent: Thursday, January 24, 2002 12:02 PM
To: ASP Databases
Subject: [asp_databases] RE: Database table design questions
It sounds like you want to track Pass/Fail, Attend/Absent
and Paid/Unpaid for each User.
If that is the case, I would make 3 Boolean fields in
the User Table for Attend, Pass and Paid.
When you collect this information (and other info about
classes and sections(whatever)), do it with a script. Dumping
this info into it's own table would require a more complicated
relationship with the user and I don't see a benefit.
-----Original Message-----
From: dont worry [mailto:aspmailbox@y...]
Sent: Thursday, January 24, 2002 10:35 AM
To: ASP Databases
Subject: [asp_databases] Database table design questions
I need a outside opinion please.
<A> User table - user info
<B> Class table - class info
<C> Class assignment table - Bridge table for users
taking a class
<D> Class section table - A class can have many
sections
I'm trying to figure out where and what type of table
to use to post user results. The results table
(pass,attend,paid) will be used as a history table to
back track. Should the results table be keyed off the
<D> section table? or <C> class assignment table?
Thanks
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
