Databases & Data Modeling Code & Apps

Prompts

Entity Relationship Design From a Business Description

Turn a business description into an entity relationship design: entities, attributes, relationships and cardinality to review.

Code & Apps / Databases & Data Modeling
Index Strategy Review for a Busy Table

Choose indexes that help reads without hurting writes.

Code & Apps / Databases & Data Modeling
Backup and Restore Plan for a Small Database

Define backups, retention and a tested restore routine.

Code & Apps / Databases & Data Modeling
Choosing a Database Type for a New Project

Compare relational, document and other options fairly.

Code & Apps / Databases & Data Modeling
Data Quality Rules and Constraints Design

Prevent bad data with constraints and validation checks.

Code & Apps / Databases & Data Modeling
Reporting Views and Summary Tables Design

Make reports fast and consistent without duplicating logic.

Code & Apps / Databases & Data Modeling
Database Security Checklist for Small Teams

Cover accounts, network exposure, encryption and logging.

Code & Apps / Databases & Data Modeling
Spreadsheet to Database Migration Plan

Move a growing spreadsheet into a proper database safely.

Code & Apps / Databases & Data Modeling