During a summer internship you are assisting with the setting up of a database. As you analyze the needs of your company you realize that different parts of the company require different data. For instance Human Resources needs access to employee data but doesn't need access to sales data. The Sales department on the other hand needs access to customer data and very little access to employee data. How should you set up the data base to allow the various departments of your company access to the right data. Which of the following is the best solution.

Group of answer choices

Put the database on one server and create one database with one schema.

You really don't need to do anything. Placing your database on one server, one database and the default dbo schema is good enough.

Put the database on one server and create multiple databases, each segmented with the proper data for the various departments. Individual schemas can be created based on more specific needs.

Put the database on one server, create one database with multiple schemas.