Include the database definition language (DDL) scripts to CREATE to database schema as described in the entityâ€“relationship (Eâ€“R) diagram (Unit 2).
Include the database manipulation scripts (DML) that will be used to INSERT, DELETE, and UPDATE data in the proposed database system.
Include the SELECT, CROSSTAB, and AGGREGATE FUNCTION statements that will be used to read data from the proposed database system.
Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.
Provide the following attachments (in addition to embedding in document):
DDL.sql (including CREATE and INSERT statements so that they execute in the correct order [top-down])
DML.sql (including DELETE and UPDATE statements so that they can be executed in any order as selected)
REPORT.sql (including SELECT, CROSSTAB, AGGREGATE FUNCTION statements so that they can be executed in any order as selected)
Note: You will embed each script in the Word document and also provide it as an attachment.
All sources should be cited both in-text and in References using APA format.