Database Administration and Data Governance
create a 700-word entry in your Database Management Plan. Ensure you:
Evaluate and assist company decision makers in understanding the importance of database administration and data governance in relation to building scalable and robust applications.
Describe how SQL constructs could be used to create data definition language (DDL) and data manipulation languages (DML).
Explain how the design would be checked from each role’s perspective, according to the information they require.
Use these roles as an example:
The administration team needs access to records and permission to update and enter new data.
The development teams need to write the expected transactions relatively easily, which might depend on the degree of normalization.
The application team needs access to any and all data to manage the interface.