List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:May 24 2005 6:32pm
Subject:Re: DB design question
View as plain text  


> Something like this would make more sense to me and provide greater
flexibility;

It doesn't to me...

> student
> ----------------
> student_id
> name
> age
>
> address
> ---------------
> address_id
> street_name
> city
> state
> zip

What addresses are these? Random addresses where a student _might_ live?

> phone_num
> ------------------
> phone_num_id
> num
> extension
> type (cell, home, etc)
> primaryNumber (yes/no)

Again, random phone numbers possibily owned by a student?

>
> student_info
> -------------------
> student_id_FK
> phone_num_id_FK
> address_id_FK
>


If an "address" isn't any address, why doesn't it relate to a student?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

Thread
DB design questionKoon Yue Lam24 May
  • RE: DB design questionGordon24 May
RE: DB design questionBob)24 May
  • Re: DB design questionMartijn Tonies24 May
    • Re: DB design questionSGreen24 May
      • Re: DB design questionMartijn Tonies24 May
RE: DB design questionMikhail Berman24 May
RE: DB design questionMike Johnson24 May
RE: DB design questionMike Johnson24 May