Looks okay to me except table teach_classes should have a
unique id for each record.
teach_clases (taught_id, class_id, teach_id)
Over the long term, the same class probably will be taught more than
once and the same teacher probably will teach more than one class
so neither class_id nor teach_id would remain unique in the table
for classes taught.
----- Original Message -----
From: César L. Aracena <caracena@stripped>
To: MySQL General <mysql@stripped>
Sent: Monday, June 10, 2002 8:23 PM
Subject: Here's something
Hi all. This is my first post here, so please be patient with me.
I don't know if there's a program already made that does what I need, so
I don't have to "reinvent the wheel". I'm using PHP & MySQL to make most
of the web sites and web-based Corporate Intranet's programs. What I
need now, is to make a program that can keep track of a social club
affiliates and their monthly payments. Also keep track of the teachers
and classes hours. Because I'm taking my first steps into RDBM's, I
would appreciate very much all the help I can get in order to create the
perfect DB structure.
What I have in mind, is something like this:
Table users (user_id, affil_number, last_name, first_name, etc.)
Table teachers (teach_id, last_name, first_name, etc.)
Table classes (class_id, name, hours)
Table teach_clases (class_id, teach_id)
Table payments (payment_id, user_id, month, year, main_fee, class1_fee,
class2_fee, etc.)
What I need to do is show, as an example, the total payments made by
affiliate # 0345 in the last 12 months. Other example would be to show
all the persons who hasn't paid last month fee.
Is what I'm thinking correct or should I consider doing some other table
or perhaps changing one that's already made?
Thanks in advance,
Cesar Aracena
info@stripped
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread111540@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-dayi=peoplepc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
