Database Schema for School

Question

Database Schema for School

Kmcnet 1,066

I am tasked with helping to develop a system for managing students and parents in a school. One of the key components to this is being able to define and track relationships. The obvious examples are tracking active students. But I need to account for parents who may be previous students. Grandparents. What about divorced or separated parents who may have children with different persons? My initial instinct was to construct a table of persons with an ID, LastName, FirstName, Date of Birth. Then a second table of relationships with a one-to-many structure where there would be the person ID linking to another person ID with the relationship type. I'm hoping someone with more experience in this type of application would be able to provide guidance. Any help would be appreciated.

Sam of Simple Samples 5,546 Reputation points

2022-11-02T19:52:54.077+00:00

The best way to get help is to do the best you can to do it yourself then ask a specific question about something you need help with.
Kmcnet 1,066 Reputation points

2022-11-02T19:56:26.54+00:00

Duh!! Not sure why you took the time to post this.
Sam of Simple Samples 5,546 Reputation points

2022-11-02T20:24:38.407+00:00

It is the type of guidance that nearly all forums such as this provide and that people that voluntarily try to help others want.
Kmcnet 1,066 Reputation points

2022-11-02T20:45:38.353+00:00

Then please voluntarily help and stop the harassment. Or simply remain silent. You obviously have nothing to add to this post.

For others actually interested other than SimpleSimpleton, I implemented a design using a table of persons only, with a family id number and a field noting if they are an active student or not, working on the assumption anyone. However, I need to try to extend this to handle blended families and am stuck on the direction. I have even looked at some genealogy databases such as https://www.familysearch.org/developers/docs/guides/FamilyTree-data-objects thinking I might be able to repurpose this. The post was hoping someone has already done this that can layout benefits and pitfalls.

1 answer

Your answer

Sam of Simple Samples 5,546 Reputation points

2022-11-02T19:52:54.077+00:00

The best way to get help is to do the best you can to do it yourself then ask a specific question about something you need help with.
Kmcnet 1,066 Reputation points

2022-11-02T19:56:26.54+00:00

Duh!! Not sure why you took the time to post this.
Sam of Simple Samples 5,546 Reputation points

2022-11-02T20:24:38.407+00:00

It is the type of guidance that nearly all forums such as this provide and that people that voluntarily try to help others want.
Kmcnet 1,066 Reputation points

2022-11-02T20:45:38.353+00:00

Then please voluntarily help and stop the harassment. Or simply remain silent. You obviously have nothing to add to this post.

For others actually interested other than SimpleSimpleton, I implemented a design using a table of persons only, with a family id number and a field noting if they are an active student or not, working on the assumption anyone. However, I need to try to extend this to handle blended families and am stuck on the direction. I have even looked at some genealogy databases such as https://www.familysearch.org/developers/docs/guides/FamilyTree-data-objects thinking I might be able to repurpose this. The post was hoping someone has already done this that can layout benefits and pitfalls.

Answer 1

NikoXu-msft 1,916

Hi @Kmcnet ,

You can create a student table with fields including ID, name, gender, address, phone, email.
And then create a parent table with student ID, parent name, and phone.

Best regards
Niko

Share via

Database Schema for School

1 answer

Your answer