Solved

Database utilisation on websites.

Posted on 2007-03-23
5
207 Views
Last Modified: 2013-11-19
I am looking to create some 'easy to edit' databases that can be kept on a server in our office. We want to be able to use this to display information on a website, we need 2 different databases. One that if changed would just change information displayed on the website, like recent news etc so that other employees in the company can change the information very easily.

The other database would have to be a secured database that would store peoples personal details, including a username and password, i need to make this database as secured as possible but still be quick to work with. We need this database so people can log onto a site, and perhaps make secure payments online (does any one have a guide on this also).

Would be very grateful if some one could help me with these problems or give me alternative ways to accomplish the same task.
0
Comment
Question by:CaptainGiblets
  • 2
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
ethoths earned 250 total points
ID: 18778506
Wow. That's a BIG topic. You should start to design the system and then identify specific areas where you need help. Then post questions on those specific areas.

As a guide though. I'd uase ASP.Net 2.0 with SQL Server. Put all your db logic into stored procedures and use datasource controls to connect your UI to the Biz tier.

You need to think very carefully about what people will be allowed to change and how you will audit this. You can use the ASP.Net 2.0 Membership provider to authenticate and authorise your users. If you do this then you don't need 2 databases as the security can be controlled using roles.

Hope that gets you started.
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 18779092
I may have misread, but from what i got your saying you can set it up so when some one makes changes to the database, it has to be accepted by say an admin before it becomes live?
0
 
LVL 11

Expert Comment

by:ethoths
ID: 18779565
If you write the code yourself, then you can apply any business logic that you want. What you are describing is a common business requirement and can be acheived in many ways depending on your situation. The simplist would be to store the new data with a version number and status against it. If a new version is added (version number incremented) it status is set to pending. The Administrator simply searchs for all status pending documents and sets their status to released if they aprove. Your live system then only shows documents where the status is set to released. Of course you will need to set up the Administrator as the only person with the ability to change a status to released.

0
 
LVL 2

Assisted Solution

by:forrest321
forrest321 earned 250 total points
ID: 18812837
You might be better off using a third party solution, considering the requirements.  There are tons of content management systems freely available, and several of them have secure payment plugins pre-written.  

I have a few questions:  Is it a requirement for this to run on your local servers, or is remote hosting feasible?  If it is to run locally, what type of server and internet connection do you have?  Who would be running the site?  How soon do you need the system operational?
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 18834966
it would be preferable for the databases to be ran on our local system, however remote hosting could be considered.

we have a cable connection in the head office with a decent dl/ul speed, i would be building and maintaining the site, and it would be hosted through iomart, and there is no exact date of when it needs to be up as it is just ideas we are throwing around at the moment.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about why website design really matters in today's demanding market.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now