Tuesday, May 22, 2012

How to store universities and departments in database in an efficient way?

Basically I would like to create a web site about universities. My problem is trying to find an efficient way to store departments and universities in tables. For example Koc University has departments Computer Engineering, Business Administration, Economics. But Sabanci University has also Computer Engineering and Economics in its departments. I was thinking that having a table which has university ID's and department ID's but I'm not sure that it is the best idea. Do you have any ideas ?



Thanks





No comments:

Post a Comment