Please enable JavaScript.

Coggle requires JavaScript to display documents.

LaCucina Ordering System - Coggle Diagram

- - - - Laptop
      - Phone
    - - Staff
        
        Register and login for an account
        
        Receive online orders for the day - before school, morning tea, and lunch
        
        Upload menu items for purchase
        
        Send order status by email to students
        
        View financial information (total of orders) for a day
        
        Uses laptop daily
      - Student
        
        Register and login for an account
        
        Browse and purchase food items
        
        view orders
        
        reliant on Parent
        
        uses phone daily
      - Parent of student
        
        Register and login for an account
        
        Browse and purchase food items for child (student)
        
        View orders
        
        Set spening limits
        
        Top up account balance (money)
        
        indicate any dietary requirements for daughter
        
        Uses laptop daily
    - - Personal
      - Social
      - Economic
  - - - Pycharm
    - - HTML
      - CSS
      - Python
    - - Mindmap - Coggle
      - DB browser for SQLite
      - Canva - User interface design
      - Draw.io - Data flow diagrams
- - - - Register
      - Login
      - Menu
      - Top-up
      - Cart
      - Tracking
  - - - Accessibility
      - Effectiveness
      - Safety
      - Learnability
      - Utility
      - CARP - Contrast, Alignment, Repetition, Proximity
    - - Register
      - Login
      - Menu
      - Top-up
      - Tracking
      - Cart
    - - Line
      - Shape
      - Tone
      - Space
      - Form
  - - - database
      - Normalization Tables (1NF-3NF)
        
        User table
        
        Primary Key: User_id
        
        Foreign Keys: None
        
        Parent table
        
        Primary Key: Parent_id
        
        Foreign Keys: Student_id, User_id
        
        Order table
        
        Primary key: Order_id
        
        Foreign Keys: User_id, Menu_id, Parent_id
        
        Menu table
        
        Primary Key: Menu_id
        
        Foreign Keys: None
        
        Student Table
        
        Primary Key: Student_id
        
        Foreign Keys: User_id
        
        Tracking table
        
        Primary Key: Track_id
        
        Foreign Keys: Order_id
- - - - Add, delete and Modify café inventory items
      - Manage student and adult (staff or parent) orders by sending an email to notify status
    - - Register and log in for an account for online La Cucina orders
      - Browse and purchase food items
      - View orders
      - Allow parents/guardians to set limits (funds) for orders.