online exam database in ms sql server

[workerbee]

I have to create a database in which user first enter the semester number then number and name of subjects. Then he will create questions, their answers and multiple options for that question. How should i proceed?

Thanks

[Rawhide]

Create the database and then the front end user interface.

[workerbee]

no i want to know how to design such a database..offcourse first i will make databse and then user interface...but HOW??

[Rawhide]

Are you asking what the design should look like? Or do you actually need to know how to design a database (i.e., create tables, etc.)?

[workerbee]

Precisely, how to design a databse...though i have designed one..but u know "first time jitters"..:|..

[rmiao]

You have to go through business process then setup logical and physical model. My suggestion is get a good db design book and follow steps in the book.