Page 1 of 4 123 ... LastLast
Results 1 to 15 of 52
  1. #1
    Join Date
    May 2008
    Posts
    25

    Red face Unanswered: Database Design Help!

    I need help to design a database.
    The Scenario is:

    There are 5 Departments

    Dept1
    Dept2
    Dept3
    Dept4
    Dept5

    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?




    thanks in advance

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    How long do you have to complete this assignment?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by tomh53
    How long do you have to complete this assignment?
    I was waiting for this response !

  4. #4
    Join Date
    Sep 2005
    Posts
    161

    Wink

    Quote Originally Posted by PMASchmed
    I was waiting for this response !
    What do you mean? I see this scenario in the real world every day

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You should design answer-wise. Once you determine the answers, you'll be able to finish the assignment a lot faster and with greater confidence.

    Yes, the design will be different for Windows versus web. Windows designers tend to put more time and effort in "up front" to ensure that Steve Ballmer gets the appropriate royalties. Web designers tend to code first, design later because royalties aren't an issue for them.

    No, XML would be better suited for this kind of problem than SQL. XML allows you to put whatever you want, wherever you want it. This leads to quick production of write-only code.

    -PatP

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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?
    1) Correctly - identify each of your entities and how they relate to eachother, considering each entity' attributes along the way.
    2) The database is a different tier of application architecture completely; the front end should not drive the back end.
    3) It is one of many possible solutions; but let me point out that 5,000 simultaneous users does not mean the ame as 5,000 concurrent users. Design BE and FE cleverly and you'd be suprised what smaller rdbms work!
    George
    Home | Blog

  7. #7
    Join Date
    May 2008
    Posts
    25
    Thanks for ur responses.
    I have managed attributes like this. Can anyone help me to complete it?

    Attributes:

    DeptartmentName,batchName,Question,Option1,Option2 ,Option3,Option4,Option5,Option6,Option7,Answer1,A nswer2,Pic1,Pic2


    1NF:

    1) QTable
    Qid,Question,Options,Answers,Pics,BatchID
    2) BTable
    BatchID,batchName,DepartmentName

    2NFSame) ?

    3NF: ?

  8. #8
    Join Date
    May 2008
    Posts
    25
    in above

    1) QTable
    Qid(PK)

    2) BTable
    BatchID(PK)

    are Primary keys

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by georgev
    the front end should not drive the back end.
    WTF???

    nah... making fun of this absurdity would be way too easy

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    May 2008
    Posts
    25
    Quote Originally Posted by r937
    WTF???

    nah... making fun of this absurdity would be way too easy

    Can u correct it?

    Plz tell me how it would be ?

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it would be: the front end should always drive the back end

    i mean, imagine typing something into the google search box (the front end) and having google return something totally unrelated from its database (the back end)

    it doesn't make any sense
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Galaxy. Where are the students in your 1NF design?

  13. #13
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You are deliberately misunderstanding\ misrepresenting George's (admittedly ambiguous) statement though right?

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, george is
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by r937
    no, george is
    Zzzzzzzzzing!

    should have read
    the front end design should not drive the back end design.
    But that's not exactly clear either...


    ...well I know what I'm trying to say anyway

    P.S. Rudy, you have to make it over to one of the many I's "conferences" in the UK
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •