DB Setup help urgently please

MIT App Inventor Help
1

Can someone please help me to setup the Database for my Attendance application

It'll help me a lot please :((

admin

12344

2

More information required.
Google drive file requires access permission.

3

Public already

Having conflict between the database values

4

Nope, requires a google account sign in to access.

Why not upload project here, or is it too big?

5

Smart_Attendance_copy.aia (2.8 MB)

6
  1. Resize your background image (reduce by 90%)
    This will speed up loading times
  2. You should work with lists together with Tinydb
    Working with Lists and TinyDB
    This will allow for default values for classes and assist with tag separation for your listviews
  3. You need to switch screen correctly to prevent app crash
    Switch screens correctly - 2 methods
  4. You could do all this on Screen1 using virtual screens
7

Your Screen1 image and background were causing AI2 errors. Delete them and their image files to avoid thise.

Here is a sample app for you to study, showing how to store data in TinyDB using compound tags.

For your app, think of each match as a day's attendance log for a single class.

You will need the Clock component from the Sensors drawer to handle dates.

8

On further thought, here is a sample abstract data model you can use to design your physical implementation in whatever database you like.

This is for a multi-teacher multi-course system covering multiple school terms.

The data model consists of tables, with keys for uniqueness, and dependent values.
If a table has multiple keys, JOIN them with '|' for a tag/value key.
If a table has multiple dependent values, assign different Namespaces or dictionary attributes to them.

The first few tables can be used to feed List Pickers for filling the subsequent tables at enrollment time and class attendance time.

  • School Schedule

    • Term Name (Spring 2026) (key)
    • Start Date (yyyyMMdd)
    • End Date (yyyyMMdd)

  • Courses

    • Term Name (Spring 2026) (key)
    • Subject (Advanced AI2) (key)
    • Teacher (ABG)
    • Meetings (list of dates)

  • Student Enrollment

    • Term (key)
    • Student Name (key)
    • true/false

  • Course Enrollment

    • Subject (key)
    • Term (key)
    • Student Name (key)
    • Grade (empty if not enrolled, 0 at start of term, 100 on success)

  • Attendance

    • Course (key)
    • Date (key)
    • Student Name (key)
    • Attended (true/false)

If using TinyDB, the NameSpace can be used to keep tables separate from each other.