October 3, 2005 at 11:46 pm
Hi
I dont know whether this is the right place to ask this question but as this forum is marked "GENERAL" i am going forward with my question.
This question resemble's the actual problem i have..
Consider a state X who has 10 districts and each of this district have 100 schools,how should i store information of this schools? my current approach is
for each district i have a database created,becoz i know the no of school is going to grow exponentialy ie tomarow there will be another 1000 schools and they after another 1 lakh and it will go on.
so District1(Database)>School (Table)
District2(Database)>School(Table) or
District(Database) and all school information in one table
Please provide a guidlines ...
October 4, 2005 at 1:43 am
hi,
I would say u rather have the tables in one database itself. Create a District table storing the Districts data. And then a School table having the data of the school for that District.
Use 1 to Many relationship between District and School Table.
Cheers!!
Andy
October 4, 2005 at 3:16 am
Please do not submit the same post in multiple forums - follow this link to see my suggested approach, which expands a little on Andy's.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=225706
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply