Koon Yue Lam,
If you running your MySQL on Windows, you may try to use one of the
reporting tools, like Crystal Report, to create your reports.
Generally these tools allow to hide repetitive data in its reports
Mikhail Berman
-----Original Message-----
From: Koon Yue Lam [mailto:kisstech@stripped]
Sent: Tuesday, May 24, 2005 1:34 PM
To: mysql@stripped
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have
more than one phone number
so the db would be:
student
----------------
student_id
name
age
address
---------------
address_id
student_id
street_name
phone_num
------------------
student_id
num
extension
the key of 3 tables are student_id
the problems is, when I want to query both student, address and phone
num, the sql will be
select * from student s, address a, phone_num n where s.student_id =
a.sudent_id and s.student_id = n.student_id
it won't provide a nice result as data of student are repeated in every
row, address and phone_num's data are repeated in certain rows The
output is not suitable for reporting and may I ask what is the better
way of design to handle the above case ?
any help would be apreciated
Regards
