here's my situation. last time nag post ako about which programming language to use sa school registry system ko. well, finally i started it already. i used php and mysql.
but that's not the case. i need some opinion on how to work things around. sa program ko, i need to make command for students to be able to assess their subjects. parang start ng enrollement. help nyo naman ako mag visualize anong mga kailangan ko sa database ko. naguguluhan kasi ako kung kelangan ba ng isang table per student?(coz i need to record their subject na take na nila).
i little bit of elightenment would do... thanks
To start off, I think you should read about relational database concepts.
You won't need 1 table per student. Just 1 table to hold all student records (discounting DB normalization first at this point coz you really need to read more on db concepts heheh)
one table per concept usually yan. like bawat student nasa isang table (e.g. students table). bawat prof nasa isang table (e.g. profs table). bawat subject nasa isang table (e.g. subjects table). then igu-glue mo sila (relationship) by making use of other tables. for example, pwede kang magkaroon ng isang table na studentsubjects, na nagrerelate sa mga subject na tinake-up ng student.
example nyan eto data mo sa students table:
ID LastName FirstName1 Batungbakal Annie2 Escalera Joey
tapos eto naman sa subjects table mo:
ID SubjectName Description1 MATH101 (may description dito)2 ACCTG101 (may description ulit dito)
maaaring may studentsubjects table ka:
ID StudentID SubjectID1 2 12 2 23 1 1
In this case, makikita sa studentsubjects table na si Joey Escalera (student ID 2) eh nagtake ng MATH101 at ACCTG101 (subject IDs 1 and 2) while si Annie Batungbakal (student ID 1) eh nagtake ng MATH101 (subject ID 1).
Example lang yan...basa-basa ka ng relational database concepts...then syempre dapat interview-hin mo yung registrar nyo at kung sino-sino pang domain experts (yung maalam sa ganyang sistema) para maka-come-up ka ng model given your problem set.
Here are sample schemas that you can study:
http://www.microsoft.com/sqlserver/2005/en/us/express-starter-schemas.aspx
Gaya nga ng sinabi nina BoyBawang at Cruizer, spend some time studying database relational concepts. Ok, inulit ko lang pala sinabi nila. Pero yung link 'tol ayos yan para magkaroon ka ng bird's eye view ng sinasabi ni Cruizer.
thanks guys... this one really helps.
dude, would you mind if i show you my finished product so all of you can comment on it?
Hi, Relational Database lng ung gagawin mo dito.
3 Tables ung gawin mo.
1. Student table - All the records of the students
2. Subject Table - All the Subjects in the school
3. Transaction Table - This table will save all the Students who have enrolled. Ung Primary key ng Students and Subjects table ayun ung magiging Foreign Key dito sa transaction Table.
hope it helps po..