Phase 1: Project Proposal
Create a comprehensive one-page PDF proposal for your capstone project that outlines your application concept, database design with at least 5 tables, and the technologies you plan to use.
Phase 1 Objectives
- Define your application concept and target users
- Design database schema with at least 5 related tables
- Plan foreign key relationships and constraints
- Identify required technologies (APIs, libraries, frameworks)
- Outline key features including dropdowns, modals, and visualizations
- Create a clear project scope and deliverables list
- Submit a professional one-page PDF proposal
Phase 1 Requirements
Application Concept and Purpose
Clearly articulate what your capstone application will accomplish and who will use it.
- Include the problem your application solves
- Define target users and key value proposition
Database Design Requirements
Design a database schema with at least 5 related tables that demonstrate complex data relationships.
- At least 5 interconnected database tables
- Foreign key constraints between related tables
- One-to-many and many-to-many relationships
- Proper normalization and data integrity
- User authentication table with data ownership
Required User Interface Features
Your application must include sophisticated user interface elements that demonstrate advanced web development skills.
- Dynamic dropdowns populated from database tables
- Bootstrap modals for CRUD operations and confirmations
- Interactive forms with validation and dependent fields
- Responsive design using Bootstrap
- Data visualizations: charts, graphs, or other visual data representations
Technology Stack and Libraries
Specify the technologies and external libraries you plan to integrate into your application.
- APIs: yfinance for financial data, weather APIs, social media APIs
- Visualization: Chart.js, D3.js, or other charting libraries
- Frontend: Bootstrap, JavaScript/jQuery for interactivity
- Backend: Flask with raw SQL queries using mysql.connector
- Additional Libraries: Flask-Login, email integration, file uploads
Key Features and Functionality
Outline the specific features your application will provide to users.
- Data Management: CRUD operations across multiple related tables
- User Authentication: Secure login with data ownership controls
- Reporting: Data analysis and visualization features
- External Integration: API data fetching and real-time updates
- Advanced UI: Interactive dashboards and dynamic content
Submission Format
Create a professional, well-organized proposal document.
- Application name and brief description
- Target users and problem being solved
- Database schema diagram with 5+ tables
- List of planned features and technologies
- UI mockup or wireframe sketches
- Timeline and development milestones
Summary
Phase 1 requires a comprehensive one-page PDF proposal that demonstrates your understanding of complex database design, modern web technologies, and user interface best practices for your capstone project.
Step-by-Step Demonstration
Live Demonstration
This demonstration will walk you through a complete implementation. The demo will include:
- Setup and preparation
- Step-by-step implementation
- Code explanations and best practices
- Testing and troubleshooting
- Final review and next steps