Will Pvc Pipes Freeze

Book 1

ACTIVITIES PERFORMING A DATABASE ADMINISTRATOR (DBA) PROPOSED BY DATE.

-coach is able to implement the decisions of the Data Administrator (AD)

- Create databases and implements technical controls needed to meet the various policy decisions made by the data administrator.

- has a team of system programmers and other technical support. - Defines the conceptual schema, which means this, that the database administrator decides exactly what information the database contains.
- Defines the internal scheme, in brief the database administrator defines how to take the base data, commonly known as physical design. - Link with users, in a nutshell is the one who decides how users will interact with the database, he decides the task that the user can perform, such as case managers, good as we know he has more control in the database, for example, delete an employee, to discharge an employee, etc. and an employee only has privileges to view but not change the information.
-Define the security and integrity constraints-Define policies emptying and refilling
-performance monitors and responds to changing requirements in a few words, seeks to optimize the database, and that seeks to use last and adapt to the daily update. Book 2
activities of a DATABASE ADMINISTRATOR (DBA) PROPOSALS Silberschatz.
ABD functions include: • Definition of the scheme. The DBA creates the original scheme of the database by typing a set of data definition statements in the LDD.
• Defining the structure and method of access. • Changing the layout and physical organization. The ABD make changes in the scheme and physical organization to reflect the changing needs of the organization, or to alter the physical organization to improve performance.
• Grant permission to access the data. The granting of different types of authorization allows the administrator of the database to determine which parts of the database each user can access. The authorization information is kept in a special system structure of the system database query when you try to access the data in the system. • Routine maintenance. Examples of routine maintenance activities managed the database are:
- Periodic backup of the database, either on tape or on remote servers, to prevent data loss in case of disasters such as floods. - Make sure you have enough free disk space for normal operations and increase the disk space as needed. - Supervision of the work running on the database and ensure that performance is not degraded by

expensive tasks started by some users.

LIST OF THINGS TO SAY AND NOT SAY DATE
Silberschatz, specifies in detail the security features at the time of administration of the database
- Refers to
physical design - Create Policies for emptying and refilling

- is located more on the use of the database - refers more to the end users of the database is created, as it emphasizes security schemes use.

LIST OF THINGS TO SAY AND NOT SAY DATE Silberschatz

"My view is that this author makes reference to the design to carry the database.
-emphasizes also backup, free space on hard drives that has the machine.
"First make a kind of graphic design before building the database and make it more similar to the ability of users.

LIST OF THINGS THAT ECHO

EH -Create a design (ER) and then create a database.
-Secure if space is hard for the database. Trying to put
-security to a BD