Please enable JavaScript.

Coggle requires JavaScript to display documents.

FIA3 Data-Driven Project, One to Many Relationships, If any form…

- - - - view sightings (Home)
      - report sighting
        
        if user not logged in - will be sent back to homepage
      - login
      - register
  - - - for general layout
    - - for scripting
    - - for styling
    - - for creating and accessing database
    - - for accessing database and keeping a session active
    - - to access database after page loaded
  - - - species
        
        ID (autoint)
        
        description (varchar)
        
        name (varchar)
        
        image (BLOB)
        
        family (int)
        
        scientific_name (varchar)
      - sightings
        
        ID (autoint)
        
        species (int)
        
        notes (varchar)
        
        lat (varchar)
        
        date_time (DATETIME)
        
        user (int)
        
        lon (varchar)
        
        temp (double)
      - families
        
        ID (autoint)
        
        name (varchar)
        
        common_name (varchar)
        
        description (varchar)
      - users
        
        ID (autoint)
        
        first_name (varchar)
        
        last_name (varchar)
        
        email (varchar)
        
        password (varchar)
- - - - through p\hpMyAdmin
  - - - Need to be able to report sightings of insects of specific species (as set by the admin)
        
        in this case bees were chosen
    - - Need to be able to view data in various ways to make data-driven conclusions
        
        tablular
        
        map