Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm developing a website and need to create an ERD for the website. I've never created one before but will be using MySQL to design it once I figure out the tables necessary. All I am asking for is for ideas on what tables might be necessary for this website. here is a link to an image of the website: https://mail-attachment.googleusercontent.com/attachment/?ui=2&ik=836739224c&view=att&th=13cb58a7f44c6aee&attid=0.1&disp=inline&safe=1&zw&saduie=AG9B_P8Vfo0F49Y0RameETk0kYPh&sadet=1360259279997&sads=tM3ILy9BSzpoS6FtbF1FSpIVC3w

Obviously there needs to be a user table. I have that created already with all pertinent info. Do I need to create a login, register, home, elite login, photos, events, newsletter, and contact us tables?? The photo link will bring the user to a page where there are folders for each event, if you click on the folder it then opens up another page with the actual photos, but you need to be a registered user to view these. Is the login hyperlink going to be the user table? Would the register link be to another table or would that add to the user table? The events page is only going to be a list of hyperlinks that take you to a new page with dates and descriptions of the events, does this need it's own table? And lastly does the newsletter and contact us pages need separate tables as well??

Like I stated, I am not looking for anyone to help create the dERD but only to let me know if all these tables would be necessary. From there I can build the ERD and create the appropriate relationships and so forth.

Thanks in advance.

share|improve this question
1  
getting a 404 on that link. why not use wordpress? – Neil McGuigan Feb 7 at 20:27
@NeilMcGuigan: Maybe because they don't use wordpress? – FrustratedWithFormsDesigner Feb 7 at 20:38

closed as not constructive by Mark Storey-Smith, Paul White, Jon Seigel, RolandoMySQLDBA, dezso Feb 11 at 9:42

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

Browse other questions tagged or ask your own question.