MYSQL Databases

Produce an entity- relationship diagram showing the tables, keys, constraints and
relationships for the database.
2. Produce DDL (Data Definition Language) SQL to create the database objects.
3. Produce Sample data Insert Scripts to populate the database.
4. Produce SQL Statements that will produce the following output:
a. A customer and address History Record showing all record amendments.
b. A Customer summary. Produce SQL to output the customer current details and all
outstanding credit commitments.
c. A Customer Credit History. Create SQL statement(s) to output the customer and
address current details and a set of outputs showing the 3 year credit profile of
the customer, including any legal judgements.
d. Create a function that will calculate the aggregated ‘Credit Score’ for a customer
based on the percentage of salary owed and repayment history to financial
providers.
The tasks and scripts should be incorporated into a short business report and should include the
rationale behind the choice of database and the structures used