I will do database design and optimization
About this Gig
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.
Database type:
Relational database
Platform:
MS SQL
•
MySQL
•
PostgreSQL
•
SQL Server
Expertise:
Design
•
ERD
•
Normalization
•
SQL
