creating multiple tables rather than a huge database

[Newgoblin49]

Hi, I was wondering how would I go about creating a school database in caspio that has an individual table for every class with the marks of the students. 
rather than having a single table with all 1000 sudents of the school . 
I need to work just so the students can see their results online. the results we stored in the table

[Vitalikssssss]

3 hours ago, Newgoblin49 said:

Hi, I was wondering how would I go about creating a school database in caspio that has an individual table for every class with the marks of the students. 
rather than having a single table with all 1000 sudents of the school . 
I need to work just so the students can see their results online. the results we stored in the table

Hi Newgoblin49,

You can create a relational database in Caspio.

You may find more details here:

http://howto.caspio.com/tables-and-views/relationships/

Hope this helps.

[AnchovyXL]

Hi,

Your database table will serve as the foundation of your application.

Therefore it is an absolute must to establish a well designed  database.

A single table for all those data is not really advisable and performance wise.

You have to group your data together and create a table for them. Say the list of students to the Students_Table, all subjects in Subjects_Table, all quizzes, exams etc on their own tables as well.

After segregating and grouping your related data, you now have to establish the relationships of each of the tables.

Relationships are quite handy when you want to connect related tables.

After that you may want to create a view. Views are like tables but not. They are just data from related table put together in one place.

You can have your data from say Student, Subjects and Results Table be in one place so that when you create a report you just have to reference it to that grouped data(View).

You may want to visit the following links for reference:

Online Help Center: https://howto.caspio.com/tables-and-views/relationships/

Database Relationships : https://www.youtube.com/watch?v=oexOYUUyQik

Advanced Training with Caspio - Database Relationships and Passing Parameters :https://www.youtube.com/watch?v=CYcBQSb7dWs

Create a One-to-Many Relationship — Child Forms and Child Reports in Caspio-https://www.youtube.com/watch?v=sgIaAeZxmy8

Hope this helps.

[Perzival]

Hi @Newgoblin49,

Just to add to the answers above, if you're looking for a Table design you may create a table for each section and another table for student.

Example:

A_Class                  B_Class                   Student_tbl

Class_ID                 Class_ID                 First_name
Class_Name         Class_Name         Last_name
                                                                          Age

                                                                          Marks
                                                                          Class_ID
                                                                          Student_ID

 

Primary Key | Foreign Key

This is a theoretical representation only and may varies base on your requirements. 

You may refer to the answers above to established your table relationships and manipulate your data.

I hope this helps.

 

Cheers,

Z

[Corpcat]

Considering each year you will want to change the classes of every student, I recommend you set up a Class Table and a student table and relate them - 

If you have fixed class names /ids each year then you could add the student id's to the class table or if you need to create new classes each year then add the class is or name to the student table .

I have set up an app for our school Snow sports team,  that tracks all their results by Age Group (division) and by Discipline.

 

 

 

 

[ianGPT]

Hello,

I just wanted to inform you that Caspio has released a new feature called AI Assistant. You can now utilize this feature to create a table with just a few prompts and set of instructions!

For reference you may check: https://howto.caspio.com/ai-assistant/ai-assistant-overview/

[Flowers4Algernon]

Hello! Just wanted to share this video for people who has the same inquiry: