Results 1 to 8 of 8

Thread: Help

  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Unanswered: Help

    I am currently working on an Assignment and I am struggling to design an entity relationship diagram normalized to third normal form.

    I just need a basic idea of what tables i need and such, I am completely clueless right now.

    It is based on this scenerio:

    -----------------------------------------

    eRadio MXFM is a web-based music radio station. It wants to set up its own discussion forum on the web. Listeners will be encouraged to register for the forum by filling in an on-line form. The details of people who register will be stored in a database. If their registration is accepted, they will be contacted by e-mail and provided with a username and password to log onto the forum.

    The Marketing Department at eRadio MXFM is keen to use this registration as a means of gathering useful information from its listeners. One of the aims is to provide third-party companies with the email addresses of those listeners who want to be contacted about products and services that meet their musical interests. In particular, the department wants to put some specialist music magazines in touch with potential listeners. The music magazines have agreed to pay eRadio for the purchase of listener mailing lists.

    In addition, the department wants to use the information to build up a profile of its listener base. The aim is to use this analysis to gain more advertising revenue and increase listening figures by focusing on the right kind of music.

    eRadio MXFM has outsourced the hosting of its website to an external Internet Service Provider (ISP). The ISP will forward data captured from the on-line registration on a regular basis in the form of a comma separated variable (csv) file.

    You have been asked by eRadio MXFM to produce a suitable database solution.

    Additional Information


    • The database is to be stored on eRadio’s main server and will not be linked to the internet in any way. Only specified employees of eRadio will have access to the database.
    • The text file containing all the details of listeners, who want to register, will be imported into the database. If an application is valid, an email will be generated to the listener confirming acceptance.
    • Registration is only accepted if an email address is provided and is valid. A valid email address is one that contains an @ symbol and does not have any invalid symbols for an email address.
    • The imported text file will contain a number of fields.


    ----------------------------------------

    All help is much appreciated.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Well, it's rather frowned upon to ask people here to do your homework for you, but I can at least point you in the direction of a couple of good articles regarding database normalization:
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why not actually do your own homework or at least give it a go before asking others to help you? You might actually learn something then.... instead of continuing to be totally clueless.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Apr 2009
    Posts
    3

    Help

    It's not homework, it's Assignment work.

    I've attempted the work, researched and I still don't get it. I'm not asking anybody to do this for me, would just like a rough idea on what the hell I need to do i.e tables and what sort of stuff I need to put in there.

    We don't get feedback for this assignment, it just gets sent off to the Examiners to be marked. So I can't afford to screw this up, no point in me putting stuff that's wrong. If we received feedback, then got to change it then yeah, but we don't.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    homework, assignment who cares its essentially the same thing.. its homework, we dont do homework for others. we may assist or ask questions or nudge but people have to make an effort before they get that assistance.

    if tou are stuck on first base then you need to talk to your lecturer/teacher and/or your colleagues. if niothign else you rteacher need to know trhat he/she has taught somehting so badly that you don't understand it.
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2009
    Posts
    3

    Help

    This isn't 'fist base' of the assignment, more like seventh base.

    Like I said, I'm NOT ASKING YOU TO DO MY WORK FOR ME.
    All I am asking for is for a basic 'summary' on what I need to do. I'm not asking you to do it. :/

    I haven't been able to contact tutors as it is easter break.

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so what have you done to date?
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    In your shoes, I would first make an inventory of the data the system will have to process, then see how those data are related to each other. From there I would try to design the tables and see how they are related. I'll then come up with a draft of the database.

    Then, i'll imagine how the import files (the one coming from the ISP) should be organized and which data they will contain.

    The third step would be to design a mechanism to import those data into the database and figure out which mechanisms of control would be necessary for data validation.

    From there I'll begin to refine the shema of the database and try to have it conform to the normalization rules.

    All these steps can be done with a pencil and some sheets of paper (and a lot of thinking).

    Then it would be a good time to come back here with what you get and ask for help, explanations, advices and clarification : you would be more than welcome.

    Have a nice day!

Posting Permissions

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