> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
