If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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.

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.

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.