Grand Travel Airlines. You have just been named Director of Data Administration
ID: 3857707 • Letter: G
Question
Grand Travel Airlines.
You have just been named Director of Data Administration of Grand Travel Airlines. Grand Travel Airlines has a centralized, mainframe-based information systems environment at its headquarters with telecommunications links to a server at each airport that it services. Each server, in turn, controls a LAN that includes a microcomputer at each check-in counter and gate. Check-in and other data taken in at the counters and gates is immediately transmitted to the mainframe at headquarters. You have been given the responsibility of creating data administration and database administration departments for Grand Travel Airlines. Design these data administration and database administration departments describing their responsibilities.
Explanation / Answer
Roles and Responsibilities for Data Administration of Grand Travel Airlines
-------------------------------------------------------------------------------
- we must know the Data Administration of Grand Travel Airlines we must understand how to review, write, assess, and support security policy and procedures.
- we must know the understand about the Data Administration of Grand Travel Airlines
- we must know the how to Establishing acceptable bounds for behavior in the company.
- we must know the Leading the employees to do the right thing.
- we must know How policy protects people, organizations, and information.
- we must know the Relationship of mission statement to policy in Grand Travel Airlines
- we must know the Policy versus procedure in Grand Travel Airlines
- we must know the Policy needs assessment in Grand Travel Airlines
- we must know the Governing policy
- we must know the Issue-specific policy
- we must know the Positive and negative tone
- Policy review and assessment process
- we must know the Role of psychology in implementing policy
- we must know the Organizational culture
Identify the scope for each test and identify any special considerations that need to be addressed who are working in the in Grand Travel Airlines
-------------------------------------------------------------------------------------------------------------------------
- We all must know about the Leadership of developing the organisation.
- we should Creating and Developing the entire working team.
- we should give them better Coaching and Mentoring the team
- we always maintain the Customer Service Focus
- we should rectify the Conflict Resolution
- We should maintain the Effective Communication
- Leading through Change
- There must be a Relationship Building within the team.
- Motivation and Self-direction
- There must be a effective Teamwork
- There must be Leadership Development
Design these data administration and database administration departments describing their responsibilities.
-------------------------------------------------------------------------------------------------------------------------------
The database administrator must know the recommendations of all Databases like ORACLE,MySQL and SQL server databases.
* The recommendations for securing the database that are unique to Oracle are:
- Oracle Database leads the industry in security.
- In any business environment or a company or a big organisation, it is very informative and secure that the database itself be well protected.
- Oracle Database Minimizing the costs of equipment, personnel, and training
- Oracle Database Minimizing delays and errors
- Oracle Database Maximizing rapid and thorough accountability.
* The recommendations for securing the database that are unique to MySQL are:
- MySQL is very secure database and it is used for Securing the servers in an company or organisation.
- MySQL can Disable or restrict remote access of end users.
- MySQL can prevent unauthorized reading from local files.
- MySQL can Lower database privileges
- The default administrator username on the MySQL server is “root”. So it can Change root username and password
- MySQL comes with a test database intended as a test space. It can be accessed by the anonymous user, and is therefore used by numerous attacks.
- MySQL can Remove Anonymous and obsolete accounts
- MySQL can Lower system privileges and it can increase database security with Role Based Access Control.
* The recommendations for securing the database that are unique to SQL Server.
- With help of SQL server we can encrypte the database backups.
- Using the SQL Server we can Secure the database backup folder by removing unwanted users.
- Using the SQL Server security best practice everyone should use Windows Authentication to connect to SQL Server for better security.
- Make the system administrator account's password complicated.
- By Using the SQL Server we can audit failed logins to SQL Server.
- By Using the SQL Server we can Turn off the SQL Server browser service
- By Using the SQL Server we can Disable features such as XP_CMDSHELL, OLE AUTOMATION, OPENROWSET and OPENDATASET
- By Using the SQL Server we can Decrease privileges for the SQL Server service account.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.