Morphace is a startup selling consumer electronics for skincare. Aside from our hardware, we would like to explore designing an iOS App prototype to engage with, generate interest, and identify the problems of our potential customers.

We have another software engineer leading the project and implementing the App features, such as wrinkle detection and skin hydration tracking. We need input from the UI / UX perspective to make the App easy to navigate, for capturing user activity.

Tasks may include:

• Database Design and Schema Creation
• Implementing APIs for Data Storage and Retrieval
• Managing Relationships Between Tables
• Testing and Debugging Database Interactions
• Query Optimization and Indexing

By the end of the project, students should complete the following list of activities:

1. Database Design: Create normalized database schemas for Users, Habits, Products, SensorData, and related tables. Establish relationships using primary and foreign keys.
2. API Development: Build APIs for storing and retrieving user metadata, logging and retrieving sensor data, logging and retrieving habits and associated skincare products.
3. Data Handling and Storage: Implement logic to validate incoming data (e.g., correct data types, optional fields). Store timestamps in UTC and ensure compatibility with time zones.
4. Query Implementation: Write efficient SQL queries for retrieving data across related tables (e.g., fetching a user’s skincare habits along with products).
5. Testing and Debugging

Bonus steps would include:

1. iOS Frontend Integration: Build a simple interface in Xcode using Swift that interacts with the backend APIs by network requests, then parses and displays the retrieved data. (User login or profile setup screen, forms to log habits or skincare product usage, display sensor data and calculated metrics fetched from the backend)
2. Basic Arithmetic Operations: Develop functions to calculate metrics (e.g., averages, trends) on sensor data.

Final deliverables should include

1. Database Schema: A documented schema with details about each table, fields, relationships, and data types.
2. API Endpoints: Fully functional APIs with detailed documentation (e.g., input parameters, expected responses).
3. Test Cases: Unit test results showing coverage for all major functionalities.
4. Deployed Backend: A deployed backend instance (e.g., on Heroku or AWS) for testing.
5. iOS Frontend (Optional): A basic iOS app prototype demonstrating interaction with the backend.