This project represents the final deliverable for an advanced database course in Computer Science. It demonstrates the complete database design process for a comic store chain, from initial requirements gathering through implementation.
matrix.png- Initial relationship matrix diagramerd.png- Detailed entity-relationship diagramscript.sql- Database creation and sample data population scripts
David's Comic Clan, a growing comic store in San Juan, Puerto Rico, required a comprehensive database solution to support their expansion plans. The system needed to manage information about comics, clients, subscriptions, orders, pre-orders, stores, employees, and office operations.
The initial design phase utilized a matrix diagram to identify core entities and their relationships:
The matrix represents:
- 1:1 - One-to-one relationships
- 1:M - One-to-many relationships
- Associative entities resolve many-to-many relationships
The detailed design phase expanded upon the matrix to include:
- Entity attributes
- Mutually exclusive relationships
- Supertype/subtype relationships
- Complete relationship cardinality
The database was implemented using Oracle DB Express Edition 11g. The included script.sql contains:
- Table creation statements
- Constraint definitions
- Sample data population scripts