Duplication 4: Professional Related Tables Application
Using Demo 4 as your guide, create a professional, polished Flask application with a unique two-table relationship, custom database schema, cascade operations, and clean codebase with no leftover example files.
Assignment Objectives
- Follow Demo 4 workflow to create a completely unique professional application with related tables
- Design and implement custom two-table relationship with realistic data and proper constraints
- Remove ALL example files and create clean, production-ready codebase with custom branding
- Implement full cascade operations and dropdown functionality for data integrity
- Deploy successfully to production with comprehensive testing of related table features
Assignment Instructions
Your Task: Recreate the Demo
Your goal is to duplicate the demonstration project you just watched. This is a hands-on assignment where you'll build the same project independently.
Requirements:
- Follow the same steps shown in the demonstration
- Implement all the features demonstrated
- Use similar code structure and naming conventions
- Test your implementation thoroughly
- Submit your completed project
Important: This is independent work. Try to complete it without looking back at the demo unless absolutely necessary.
Assignment Details
Objective
Following the workflow from Demo 4, create a professional Flask application with your own unique two-table relationship and custom database schema. Your final application should be well-polished, contain related tables with cascade operations, dropdown functionality, and have all example files removed for a clean, production-ready codebase.
Step 1: Follow Demo 4 Workflow
- Use Demo 4 as your complete guide for the development process
- Create new repository from CRUD F25 template
- Set up Heroku app with auto-deployment and JawsDB MySQL
- Configure local development environment with virtual environment
- Use Claude AI assistance throughout the development process
Step 2: Custom Related Schema and Blueprint Creation
- Design a custom two-table relationship for your unique theme (e.g., Customers/Orders, Teams/Players, Categories/Products)
- Use Claude AI to create and deploy your custom schema with foreign key constraints
- Configure CASCADE DELETE and UPDATE operations for data integrity
- Have Claude generate blueprints for both tables with proper relationship handling
- Implement dropdown functionality for the child table (foreign key table)
Step 3: Professional Polish and Clean-Up
- Remove ALL example files: Ensure no leftover example templates, blueprints, or references remain
- Customize the application title, branding, and theme to match your project
- Add professional styling and colors that align with your chosen theme
- Update navigation to reflect both related tables (e.g., Customers and Orders)
- Ensure the application looks professional and production-ready
Step 4: Thorough Testing and Quality Assurance
- Test primary table CRUD operations: add, edit, delete with modals
- Test secondary table CRUD operations with dropdown selection for relationships
- Verify cascade delete: deleting parent record removes all related child records
- Verify cascade update: updating parent record reflects in all related child records
- Debug any errors using Claude AI assistance
Step 5: Production Deployment
- Use Claude AI to commit and push all changes to GitHub
- Monitor Heroku auto-deployment and build process
- Test the production application thoroughly with all related table functionality
- Verify all functionality works on the live site
- Ensure no errors or broken features in production
Step 6: Submission
- Add bamarshall06 as collaborator on GitHub repository
- Add bamarshall06 as collaborator on Heroku project
- Submit only the Heroku project name (not URLs) in GeorgiaView
- Example submission: "cbis4210_dup04_lastname"
Professional Application Requirements
Submit only the Heroku project name in GeorgiaView. Your application must demonstrate:
- Professional Quality: Well-polished application that looks production-ready
- Clean Codebase: NO example files, templates, or placeholder content remaining
- Custom Related Schema: Two tables with meaningful relationship (not Authors/Books)
- Foreign Key Constraints: Proper relationship configuration with cascade operations
- Dropdown Functionality: Child table uses dropdowns for parent record selection
- Full CRUD Operations: Create, Read, Update, Delete functionality with working modals
- Cascade Operations: DELETE and UPDATE operations work correctly
- Custom Branding: Application title, styling, and theme reflect your unique project
- Production Deployment: Successfully deployed and tested on Heroku
- Collaboration Access: bamarshall06 added to both GitHub and Heroku
Final Quality Check Before Submission
- ✨ NO Example Files: All example templates, blueprints, and references completely removed
- 🎨 Professional Appearance: Custom branding, styling, and theme throughout
- 🔗 Related Tables: Two meaningful tables with foreign key relationship (NOT Authors/Books)
- 📝 Dropdown Interface: Child table includes dropdown selection for parent records
- ⚙️ Full CRUD Functionality: All operations work perfectly with proper modals
- 🔄 Cascade Operations: DELETE removes related records, UPDATE maintains consistency
- 📱 User Experience: Navigation, titles, and content all match your theme
- 🗄️ Data Integrity: Referential integrity maintained through proper constraints
- 🚀 Production Ready: Application runs flawlessly on Heroku with all features
- 🤝 Access Granted: bamarshall06 has collaborator access on GitHub and Heroku
- 📤 Submission Complete: Only Heroku project name submitted in GeorgiaView
🎯 Key Success Criteria:
This is NOT Demo 4 with minor changes. This should be a completely unique, professional application.
Your relationship should be meaningful and different from Authors/Books.
The instructor should see ZERO trace of example files and full cascade functionality.