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:

Error: Failed to load processor box

No macro or processor named 'box' found

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

Error: Failed to load processor box

No macro or processor named 'box' found