From: Martijn Tonies
Date: May 24 2005 6:32pm
Subject: Re: DB design question
List-Archive: http://lists.mysql.com/mysql/184511
Message-Id: <008301c5608e$e2ce2370$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> 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