Include the database definition language (DDL) scripts to CREATE to database schema as described in the entityrelationship (ER) diagram (Retail Store).

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)

CUSTOMERS custID fNAME INAME E MP LOYEE em ployeelD SERVICES servicelD Frequency ITEMS ORDERS producti D orderlD SURVEYS surveylD empS un cust Sur Product# Transaction# Store#