How gomezmatias123/proyecto-bd1-equipo_48 works
Dragabulk.TCG is a SQL Server database project for a buying-and-selling business, developed in stages from relational design through implementation, queries, and database improvements. A user-facing workflow is only documented at a high level: the project creates and manipulates the database, then supports sales-related queries and technical enhancements. The tree identifies the relevant SQL scripts, but no source excerpts were provided, so specific calls, data transfers, and query-to-schema relationships cannot be verified; these are shown only as unverified links where appropriate.
Main entry points: crear_bd.sql Database schema · comprobante_venta.sql Sales receipt query · consulta_avanzada.sql Advanced query · informe_ventas.sql Sales report
Components 12
Database foundation
- Database schema
sql/ddl/crear_bd.sql - Dragabulk database
- Sample data
sql/dml/datos_prueba.sql
Sales queries
- Sales receipt query
sql/consultas/comprobante_venta.sql - Advanced query
sql/consultas/consulta_avanzada.sql - Sales report
sql/consultas/informe_ventas.sql
Database enhancements
- Index optimization
sql/tecnico/Optimizacion_indices/script-indices.sql - Procedures and functions
sql/tecnico/Procedimientos_funciones/script.sql - Function security
sql/tecnico/Seguridad_funciones/script_seguridad.sql - Transaction functions
sql/tecnico/Transacciones_funciones/script-transacciones.sql - Audit triggers
sql/tecnico/triggers_auditoria/script-triggers.sql
Other components
- Database operator
Connections 10
- Database operator → Database schema: creates schema
- Database schema → Dragabulk database: defines
- Database operator → Sales receipt query: runs query
- Database operator → Advanced query: runs query
- Database operator → Sales report: runs query
- Database operator → Index optimization: applies indexes
- Database operator → Procedures and functions: applies routines
- Database operator → Function security: applies security
- Database operator → Transaction functions: applies transactions
- Database operator → Audit triggers: applies auditing