designing idea please - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

designing idea please

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-03-07 : 23:59:07

Dear Friends,I'm a junior DBA,
I've to prepare an online examination.
for this, I've three categories.
a)beginer level
b)intermediate level
c)expert level

again here subjects are 6. like sqlserver,oracle,c#,vb.net,html,javascript.
in these subjects, i've to select these three types of questions.
now how can i design for this requirement? shall i create three tables for beginer, intermediate,expert or shall i create 6 tables and write according that?

am i given correct inputs?

please give me an idea to design

thank you verymuch experts.

Vinod

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-08 : 00:51:38

[url]http://www.sqlteam.com/item.asp?ItemID=122[/url]

In addition to this, I would recommend you to purchase some good database design book like [url]http://www.amazon.com/exec/obidos/ASIN/0201694719/ref=ase_islanddatamanage/[/url]

Also have a look at normalization theory here: [url]http://www.island-data.com/downloads/papers/normalization.html[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

vladimir.stokic
Starting Member

25 Posts

Posted - 2007-03-08 : 04:03:34

This is how I would do it. I would create three tables:
1. Table: Level, which should have two columns: Level Id (PK) and level name
2. Table: Subject, which should have two columns: Subject Id (PK) and subject name
3. Table: Question, which should have four columns: Question ID (PK), Level Id (FK to table Level), Subject Id (FK to table Subject) and Question text.
Hope this helps.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources