[RESOLVED] Database Design

I'm currently planning to develop multiple applications like Quotation System, Inventory System, Helpdesk System, etc. using only one authentication.

Should I merge the database of these applications into one or create different database files for each applications?

That depends your programs, If all are inter-related you can use a single database and have all the tables in it...if it doesnt then split the db...If you want to merge it just because of the authentication then use a separate module for the authentication purpose and call it from your programs...

Not all tables are related.
If I'm going to merge them it will become hard to manage the databases, if I will separate them it may be hard to connect them.

Each application may have more than 20 tables and as of now I'm planning to create 8 applications.
What is the best thing to do?

Quote:

---

Originally Posted by eSPiYa

I'm currently planning to develop multiple applications like Quotation System, Inventory System, Helpdesk System, etc. using only one authentication.

Should I merge the database of these applications into one or create different database files for each applications?

---

No.

Build yourself a User Authentication System.

:thumb:

Sounds good.

I'll try to do it.

If you are using a 'proper' database system (such as SQL Server or Oracle), you can easily work with tables that are in different databases on the same server.

Thanks for all of your advice.

Now, just what tommygrayson adviced, I'm developing the Authentication system.
I found myself lost in the middle of "database development" jungle and that makes me excited.
After more than a year of being a lazy programmer, this another world of coding waken the coder-inside-of-me.
I'm pretty excited about this.

I'm having some problem w/ debugging in MSVS2005 and MSSQL Server 2005.
An error message shows everytime I tried to debug my project.
It says something about 'master.dbo.sp_enable_sql_debug*', I tried to search for this stored procedure(obviously) but I can't find it.

Do I need to download something and install it on the machine w/ MSSQL?

Quote:

---

Originally Posted by eSPiYa

Thanks for all of your advice.

Now, just what tommygrayson adviced, I'm developing the Authentication system.
I found myself lost in the middle of "database development" jungle and that makes me excited.
After more than a year of being a lazy programmer, this another world of coding waken the coder-inside-of-me.
I'm pretty excited about this.

I'm having some problem w/ debugging in MSVS2005 and MSSQL Server 2005.
An error message shows everytime I tried to debug my project.
It says something about 'master.dbo.sp_enable_sql_debug*', I tried to search for this stored procedure(obviously) but I can't find it.

Do I need to download something and install it on the machine w/ MSSQL?

---

Because the query is run in the master database not yours I guess.

I already figure out what is the problem.

The user must have an administratorial rights to debug.

Thanks everyone. ;)