Please explain and approve the answer you will choose because I need to understa

Question

Please explain and approve the answer you will choose because I need to understand this very well

You are a DBA for your company and need to set up a brand new database. The database is not that large nor are there plans for it to grow exponentially. Your company is is small so there is no need to mirror or replicate the 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 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 and create one database with one schema. ut the database on one server, create one database with multiple schemas

Explanation / Answer

The answer for first question i.e.,

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

We can use roles to restrict access to the specific schemas.

The answer for second one is i.e.,

<xsl:for-each    select= "list/custorder">
       <xsl:value-of select = "name"/>
<xsl:for-each>

This option will loop through each custorder and outputs the name for each custorder.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---