List:General Discussion« Previous MessageNext Message »
From:Day Irmiter Date:June 11 2002 3:07am
Subject:Re: Here's something
View as plain text  
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



Thread
Here's somethingCésar L .  Aracena11 Jun
  • Re: Here's somethingcal11 Jun
    • RE: Here's somethingCésar L .  Aracena11 Jun
  • Re: Here's somethingDay Irmiter11 Jun