Question

Wk 3 - Apply: Database Management Plan: Part 3 - Database Administration and Data Governance 700 words, single spacing As part of your culminating project, create a 700-word entry in your

Database Management Plan. You will use information from this entry in your presentation due in Week 6. 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 (DMLS)./nDescribe how SQL constructs could be used to create data definition language (DDL) and data manipulation languages (DMLs). 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 normalisation. The application team needs access to all data to manage the interface.

Fig: 1

Fig: 2