Last post Jun 14, 2008 06:23 AM by dotnetukguru
May 20, 2008 12:19 PM|galaxy_thestars39|LINK
I need help to design a database.
The Scenario is:
There are 5 Departments
Each department has 10 batches of students. The questions are stored in SQL Server 2000 Database. Each batch has 8 subjects.
The question for each batch are 200-400. Some questions has 4 options and some has 7 options to select multiple aswers. Some
questions as more than 1 answers(Ans1, Ans2, Ans3). Some Questions also has 2-3 pictures. During test a student can select
Check option to review its answer again. Database should be capable to hold 5000 users at a time.
My questions are:
How should I design database; should I design Department wise or batch wise or Subject wise?
And does database design will be different for a Web based application and Windows based application?
And Is Sql Server my correct choice?
May 20, 2008 01:10 PM|lberan|LINK
database design is the same for all applications. sql server is a good choice. how you should design depends on the relations between department, batch, and subject . try to design this way so that they all have one-many relations
May 21, 2008 02:40 AM|Mikesdotnetting|LINK
Database design is about identifying the different entities and how they relate to eachother. This kind of article should help:
Also, the design for the database should be based on functionality, not platform. Therefore, it makes no difference what type of app you are putting together.
Jun 14, 2008 06:23 AM|dotnetukguru|LINK
Database design is one of those things that should only take a couple of hours, but if done badly can take ages. Have you tried looking at ObjectMapper.net or NHibernate
Software Development | My Development Blog