You are here:

Data Management & Storage/database design and coding for Front-End Web Developer

Advertisement


Question
Hello, ScottGem

I am a Front-End Web Developer (so I do the HTML, CSS and Javascript of a website). I consider my knowledge of database to be basic, since I took only 1 database subject in college and know how to fetch data through PHP.

I built a website for a client that was fairly simple (it contained information only). Now he wants to add a database to store user information in it. The website was built using HTML, CSS, PHP and Javascript and no Content Management System was used.

How can I get started with designing and building a database for my website?

Thank you

Regards

JK.

PS: you can redirect me to a good website or book that discusses the same issue. I know programming so don't mind technical language.

Answer
The key to designing a good database is understanding the concept of normalization. So you start off with determining what data you need to capture. You then organize that data into normalized tables. There are many good sites that can explain normalization.

What you use as the back end for the data is up to you. You can use SQL Server, Oracle, MY SQL or even flat files if the data structures can handle that. The next piece is programming the interface between the data and the user. I've been told DreamWeaver is a great tool for that.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Data Management & Storage

All Answers


Answers by Expert:


Ask Experts

Volunteer


ScottGem

Expertise

I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.

Experience

I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.

©2016 About.com. All rights reserved.