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.