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:

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

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. …