What are the basic functions for master, msdb, model, tempdb databases?

Question

I have scripted a PHP login form to works well. I thought of the sign up part and realised that there may be individual or group/ company registration.I did 2 different forms for each category of registration.My challenge now is how to integrate the two.I want to make the login form be able to serve the two database because it is a single site for both individual and corporate members.
Advice.

Answer 1

Master database is used to store information of all the databases on the SQL server. The server cannot start if the database is not configured properly.

The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.

The tempdb is used to store temporary objects such as global and local temporary tables and stored procedures.

The model is essentially a template database used in the creation of any new user database created in the instance.

The resoure Database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.

Answer 2

• The Master database contains catalog and data for all databases of the SQL Server instance and it holds the engine together. Because SQL Server cannot start if the master database is not working.
• The msdb database contains data of database backups, SQL Agent, DTS packages, SQL Server jobs, and log shipping.
• The tempdb contains temporary objects like global and local temporary tables and stored procedures.
• The model is a template database which is used for creating a new user database.