Jump to content
  • 0

creating multiple tables rather than a huge database


Newgoblin49
 Share

Question

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

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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.

 

 

 

 

Link to comment
Share on other sites

  • -1
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...