Concepts of Database Management

599 Words3 Pages
In this unit eight assignment for IT354 I will address the following questions: 1. What are the DBA’s responsibilities regarding access privileges? 2. What is a disaster recovery plan? 3. Name five categories that you usually find on a DBMS evaluation and selection checklist. 4. What is a LAN? 5. What is an intranet? 6. What are the DBA’s database design responsibilities? 7. What is denormalization? Unit eight Questions - Concepts of Database Management What are the DBA’s responsibilities regarding access privileges? The DBA is the master controller of access to databases. It is the duty of the DBA to ensure that users that access the databases have only the necessary access to specific data within the database. For example a user in HR will have access to payroll information within the database, whereas a regular IT employee would not. It is important that the DBA has access privileges assigned properly to mitigate any data security issues within their databases. What is a Disaster Recovery Plan? A DR Plan defines the ongoing and emergency actions and procedures essential to guarantee data accessibility if a disaster were to occur, and the system or systems became unavailable. A successful DR Plan will not only include the necessary information for systems and the configurations, but backup information, and primary point of contact information as well. Name five categories that you usually find on a DBMS evaluation and selection checklist: Data Definition, Documentation and Training, Limitations, Security, and Backup / Recovery. What is a LAN? LAN is an acronym that stands for Local Area Network. The LAN is the network that is local to the systems typically within an office. A LAN can include user workstations, application and web servers, SQL or other database servers, mail servers, DNS, DHCP and even Active Directory if a

More about Concepts of Database Management

Open Document