Re: database design question

The student table besides having a foreign key to the contact would have also the following:

medical comments
current grade
foreign key to account which is just another foreign key to contact table for the parent/billing record.
...

for the faculty table, additional fields would include:

hire info
login/password for electronic timesheet login ...

"Impulsive" <sigenest_at_gmail.com> wrote in message news:1105042366.622564.240920_at_c13g2000cwb.googlegroups.com...
> My question is - why do you need to denormalize this?
> Are there heavy reports being run on this data that don't execute fast
> enough?
> What kind of reports?
> What other info is in faculty and student tables besides foreign keys?
>
>
> gkelly wrote:
>> I have a database for a school that has been in use now for a couple
> of
>> years and it is working well.
>>
>> There are numerous tables obviously but consider these:
>> Contact - holds all contacts - students, faculty, or any other
> type of
>> contact - (probably should have called it Entity)
>> Faculty - holds info about specific faculty member - foreign key
> to
>> contact
>> Student - holds info about specific student - foreign key to
> contact
>> -----------
>>
>> Considering that the contact table has fields such as: last, first,
> mi,
>> addr, city, state, zip, email ...
>>
>> Do you think it is a good idea to have a single table hold such info.
> Or,
>> would you have had the tables Faculty and Student store
>> the last, first, addr and other fields?
>>
>> At what point do you de-normalize for the sake of being more
> practical?
>>
>> gkelly
>
Received on Thu Jan 06 2005 - 21:44:56 CET