Results 1 to 2 of 2
Thread: Database Organization
Jun 17, 2008, 22:16 #1
- Join Date
- May 2008
- Missouri, USA
- 0 Post(s)
- 0 Thread(s)
I am working on a new project. I am trying something new and so wanted some input so that i dont make it tough on myself in the future. I am creating a statistic web application.
The users will be able to create an account and keep there own separate statistics. There are 6 tables which will be interconnected for each stat account.
Right now I have two different approaches in mind.
1.) Use one database and ensure that each entry in each table properly points to one specific user account.
2.)Create a new database and tables for each user account.
Is it good practice to layer on multiple users data into a single database? Will that cause any problems in the long run? Or am i just fretting over nothing?.
I appreciate your help. I am just a hobbyist so my knowledge on web application development is a little flawed.
Jun 17, 2008, 22:50 #2
- Join Date
- Aug 2005
- City of Angels
- 73 Post(s)
- 6 Thread(s)
Try a couple of tutorials on database normalization .
I believe a single database is adequate and preferable to duplicating data in your second approach.Learn how to be ready for The New Move to Discourse
Use Facebook to Make Money
Be sure to congratulate Patche on earning Member of the Month for July 2014