Results 1 to 4 of 4
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Odd Requests (Any version)

    I am sure everyone who build databases for others gets asked to do things that seem odd.

    Here is one that has come my way. I am just starting a new project in the area of university teaching. There is a units table which specifies among other things, the amount of staff time the uni should devote to the unit. So there is a number of hours of lecturing, tutoring etc. There is also a quota of marking time as hours per student - but I am told to store this "in words in the table " and use a calculation to convert to hours later.

    I don't know the thinking behind this yet, but I suspect it is the usual mixing up of means and ends, and that a combo box that displays words but stores numbers will do what is required.
    Regards
    John



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Odd Requests (Any version)

    > I suspect it is the usual mixing up of means and ends

    I agree. It makes no sense to store the text representation of numbers in a table. It is inefficient, takes up more space than necessary andmakes calculations difficult. Converting numbers to words for display/printing purposes makes much more sense and is a lot easier.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Odd Requests (Any version)

    How wrong you can be.

    I turns out that this means the number of words the students are required to write for assessment purposes.

    Staff are expected to be able to mark at a fixed rate of words per hour, so from the number of words, you can calculate how many hours of marking are needed.
    Regards
    John



  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Odd Requests (Any version)

    A ha! <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

Posting Permissions

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