I will do database design and optimization
Acerca de este Servicio
I'll design, build, and optimize your SQL database from scratch.
WHAT YOU GET:
Database schema design (normalized 3NF)
Table creation with constraints & indexes
Stored procedures for common operations
Triggers for audit logging
SQL queries for reporting
Performance optimization advice
Full documentation & ER diagram
Test data insertion
INCLUDES:
- Entity Relationship (ER) Diagram
- DDL scripts (CREATE TABLE, CONSTRAINTS)
- DML scripts (INSERT sample data)
- Sample queries & reports
- Normalization explanation
PERFECT FOR:
- Web applications (backend DB setup)
- Business systems
- Data warehousing
- Reporting systems
- Academic coursework
Tech: SQL
Example: Designed hospital management DB with 12 tables, stored procedures, triggers, and 12 analytical reports.
Tipo de base de datos:
Base de datos relacional
Plataforma:
MS SQL
•
mySQL
•
Postgresql
•
SQL Server
Experiencia:
Diseño
•
erd
•
Normalización
•
SQL
