[Database Management] Describe referential integrity and cascade options. How ca

Question

[Database Management]

Describe referential integrity and cascade options. How can they be helpful and when can they be a downright pain in the neck?

Describe the security model used by MySQL. Be specific as to the different aspects of authentication and where permissions come from (i.e. what tables are they stored in?). Describe how permissions are determined.

Describe the role of the database administrator from the point of developing a new database system through administering such a system. Make sure to include points of development that make the administration easier/harder and the database well accepted by all.

Discuss two ways in which database processing can lead to increased productivity for an organization. Be specific as to the causes and effects of the implemented database system.

Explanation / Answer

Answer)

Referential integrity cascade options:

When the data is being modified it would certainly result in referential integrity violation so as to prevent the data from this violation disallowing the modification to the data is a preferred option.

This process is called as cascade as the deletion in the primary key table is being cascaded to the referenced foreign key based table.

This is how they would prevent the data from deletion or modification and are helpful.

Securoty model used by MySQL are as follows:

1) The passowrd should be strong

2) Limiting the priviledges to non-administrative users.

3) Don't use the symlinks to the table

4) Restrict the number of connections being used.

This is how the permissions are bieng determined.

The role of a database administrator is to check the performance, integrity, and security of the database. Planning and development of the database being the highest priority.

The development plans to be provided by the administrator are as follows:

1) Conceptual design is to be created

2) Backend organization of data and the front end availability to be considered

3) Create a logical design

4) install new version of DBMS

5) Manage and develop backup and recovery tools

6) Control access priviledges and permissions

7) Maintain the database standards, procedures and documentations.

The ways in which database processing can lead to enhanced productivity are :

1) Reduce the data redundancy.

2) Carry out the data profling and analysis like the error cluster analysis, data event anaysis.

Enabling automation, and preventing the data defects are other factors which can help improve the productivity.

Hope this answer helps. Happy to help. :)

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.