+ Post New Thread
Results 1 to 7 of 7
General Chat Thread, Database Design in General; So, I've finally finished my database design - now I have to justify the design of it. Anyone got any ...
  1. #1

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242

    Database Design

    So, I've finally finished my database design - now I have to justify the design of it. Anyone got any ideas how this would be best done?

    i.e. I have followed the steps from the design stage which came from the analysis stage etc.

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,772
    Thank Post
    1,308
    Thanked 804 Times in 698 Posts
    Rep Power
    246
    Quote Originally Posted by Hightower View Post
    So, I've finally finished my database design - now I have to justify the design of it. Anyone got any ideas how this would be best done?
    Sorry, what context is this in? Is this a database you're designing as an exercise (i.e. to hand in as some school work), or something you're doing as a job? If the latter, surely the only "justification" you need is that you're the database designer? What sort of database is it you are designing?

    --
    David Hicks

  3. #3

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,336
    Thank Post
    227
    Thanked 433 Times in 315 Posts
    Rep Power
    172
    If it is for coursework/project then the justification is your database design/normalisation along with database dictionary. This would have been your research before actually setting up the database. Which you did first of course....

  4. #4
    Friez's Avatar
    Join Date
    Dec 2006
    Posts
    839
    Thank Post
    22
    Thanked 22 Times in 21 Posts
    Rep Power
    24
    This is a wishy washy question to be sure. I am going to make an assumption that you've been asked to justify the design of the database as part of an evaluation of the work you've just done, if so here's some questions you should ask yourself.

    If it's unnormalised, why is it unnormalised (i.e. flat) will there be a definite advantage over other methods in doing so? If you've normalised it, why have you normalised it in the way that you have? How much data is written to the database, is there any redundancy or replication of data elsewhere in the database?

    Could it be optimised any more? What about if you were storing several billion entries, is your database fast enough to account for it? Does it need to? What if you needed to upgrade it in the future? Can it roll into a distributed system relatively easy? What are the needs of your client/system and does the database meet these needs? This is the kicker question when it comes to justifying your design.

  5. #5

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    242
    It's for college - the database is a Video Store kind of one allowing enrolling of members and loaning of DVD's etc.

    I've done ALL the design work, normalisation and things like that. I just don't know what to put. Do I actually write "This database is fine because I followed the design which came from the analysis which came from the customer"???

  6. #6

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    thats the exact database design i did at college

    we then had to take it a step furthur and write an ASP interface for the frontend

  7. #7

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,772
    Thank Post
    1,308
    Thanked 804 Times in 698 Posts
    Rep Power
    246
    Quote Originally Posted by Hightower View Post
    It's for college - the database is a Video Store kind of one allowing enrolling of members and loaning of DVD's etc.
    Oh, ah... Your best bet could well be to look at the mark scheme - if you don't have one already, nip over to the relevant exam board's website and download one from there.

    --
    David Hicks



SHARE:
+ Post New Thread

Similar Threads

  1. Techsoft 2D Design
    By tosca925 in forum Educational Software
    Replies: 14
    Last Post: 10th September 2008, 12:47 PM
  2. Web design software for KS3?
    By scgf in forum Educational Software
    Replies: 8
    Last Post: 22nd May 2008, 02:12 PM
  3. New 2D Design talking to the Old Mill Design
    By Sean in forum Educational Software
    Replies: 5
    Last Post: 15th January 2008, 10:26 AM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. Website Design
    By Simcfc73 in forum How do you do....it?
    Replies: 40
    Last Post: 25th September 2006, 03:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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