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.