Hi all, I am new here and I hope this will be my start with you all.
I have a question I hope you can answer,
I am working on a website witch has many sub-websites the problem happened when I was building a database for the mailing list.
Let me describe the mailing list to show you where the problem is.
The website has many sub-sites and every visitor can register and choose the sub-site he/she want to receive its messages. The user has an option to receive all sites message in one message I mean all sits he is registered in.
The problem is how to test witch site the user is registered in, in other words how to build this database.
I'm curious, what is the challenging part of your question?
If we understood what part you are having trouble with, it would be a lot easier to focus on that without bothering you with the parts that you already understand.
I would expect that your instructor has covered all of the parts of this process in class... Were some of the discussions unclear? Did you miss any of the sessions? That kind of information would help me help you with a problem like this.
You may also wish to Google about the database product you are using.
But that aside:
In certus' design: Simply create one entry in Website for each website you have. Create one entry in Message for each message you have. Create one entry in Customer for each customer you have. In Customer_has_Website, enter the IDs of the records from the other tables, and you will have a list of which customers want which messages from which websites. Personally, I would leave the text of the message back in the Message table, but that's just me.
Last edited by chris_n_osborne; 01-30-05 at 16:37.