= Phase P7: Advanced Database Development (SQL DDL) ¶

Discuss all needed data constraints requirements regarding more complex data constraints and consistency, business scenarios useful to your application that require special data checks and relevant reports.

Implement the data requirements with triggers, stored procedures and functions, views, background jobs.

Only non-trivial and complex data requirements realized with background database programming will be considered for this project phase. Basic column level constraints and basic referential integrity should be reported and evaluated in Phase 2.

Document your implementation.

Create a wiki page called **AdvancedDatabaseDevelopmen** and use the structure from this template:

{{{#!box information

= Advanced Database Development 

** Data constraints requirements idea/concept title **

Data requirements description.

Implementation:

 * Triggers
 * Stored procedures/functions
 * Views
 * Custom domains

** Another idea/concept title **

...

}}}


**AI Use**

You are free to use an AI to improve your work, provided that you adhere to the following rules:

 * you use AI in this phase of the project only to improve your own initial work
 * you use AI to create alternative ideas, that you can learn from and borrow and use in your own work
 * you document the changes you have made to your own work based on the ideas from the AI tool in the history above
 * you document the entire usage of the AI tool in a new wiki page named **AdvancedDatabaseDevelopmentAIUsage** linked here, that you structure according to the following template

{{{#!box information

= Advanced Database Development AI Usage

**Name of AI service/solution that was used**

URL:

Type of service/subscription: 

**Final result**

Diagram:

Results in details / description:

**Entire AI usage log**

 1. Line-by-line Log of all interactions with the AI (prompt and response) 
 2. ...

}}}