[RESOLVED] Database Design

[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?

[ganeshmoorthy]

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...

[eSPiYa]

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?

[tommygrayson]

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.

[eSPiYa]

Sounds good.

I'll try to do it.

[si_the_geek]

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.

[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?

[tommygrayson]

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.

[eSPiYa]

I already figure out what is the problem.

The user must have an administratorial rights to debug.

Thanks everyone.