I am planning to build a database for a school application. I have designed a database to hold time tables for all the classes. It should also relate to the teachers taking the subject for the class. Also should be able to handle a public holidays mentioned. Also the attendance of all the students and teachers. Please guide me with the best possible table structure with the foreign key mapping if any. Thanks in advance.
+6
A:
The best advice I could tell you would be to try to put some basic effort in doing your school assigments. This is the key in becoming an accomplished programmer and professional.
Amadeus45
2009-07-09 05:33:43
+1 I'm not quite sure this is homework, but I do agree with "try to put some basic effort in".
lc
2009-07-09 05:36:06
I can't tell from the question if this is 'school assignment' as in "homework", or 'school assignment' as in "I'm writing an application for managing teachers and students in my school."
lavinio
2009-07-09 05:36:53
I have no problem in answering even basic questions like "how to create a table" or "what is a foreign key", but homework is there to make you learn and use your skills and critical thinking, asking people to do it for you is the absolute worst thing to do for yourself.
Amadeus45
2009-07-09 05:39:28
+1
A:
i hope this link help :
http://www.hsc.csu.edu.au/ipt/info_systems/2-3/database_design.htm
Haim Evgi
2009-07-09 05:34:28
+3
A:
There are numerous examples of database design here : http://www.databaseanswers.org/data_models/index.htm
hadi teo
2009-07-09 05:38:13
+1
A:
An excellent technique you can use is called Entity-Relationship diagrams. They help you model out the aspects of your universe (in this case the school) you care about in order to build a good database.
There are many books that dwell on the question. But for a simple introduction (and links to other very useful articles) wikipedia is the place to start link.
A very useful rule-of-thumb to remember when using Entity-Relationship diagrams is that most of the time (almost always) a box in the ER diagram is a table in the database. A diamond on the other hand sometimes is and sometimes is not.
Read on this kinds of Diagrams, after you've done the first you will see it is an extremely powerful tool for modeling different universes.
Kiranu
2009-07-09 05:39:21
A:
Google for "open source school administration software". Then comparing all the solutions you will find with what you know about your domain will give you a far better idea of your requirements than we can.
le dorfier
2009-07-09 05:40:09