Thoughts on structure of this database
Posted: Fri Jan 29, 2016 10:14 pm
Hi I am new to web development and is trying to make a website that keep peoples records
I want a user to be able to make his/her own form or forms
I want them to be able to make an unlimited number of forms and each form may have different number of fields
So a user lets say a teacher can have a form for recording the names and other info if his students
Then that same user can also make a form for his/her tests or favorite food of each student
I have the structure I have in mind attached with sample data on it
on the sample data there are 2 users
user jeric11 made 2 forms, one being info and the other favorite food and also filled up the both forms
I can then retrieve Records
I can display jerics info as
First Name : Jeric
Last Name: Tibayan
Address: Philippines
I can also open Jerics Favorite Food record which outputs
Vegetable : Onions
Fruit: Apple
Pizza: Pepperoni
I hope you guys can tell me if I'm on the right track.
Or suggest a better way to do it
Many thanks in advance
I want a user to be able to make his/her own form or forms
I want them to be able to make an unlimited number of forms and each form may have different number of fields
So a user lets say a teacher can have a form for recording the names and other info if his students
Then that same user can also make a form for his/her tests or favorite food of each student
I have the structure I have in mind attached with sample data on it
on the sample data there are 2 users
user jeric11 made 2 forms, one being info and the other favorite food and also filled up the both forms
I can then retrieve Records
I can display jerics info as
First Name : Jeric
Last Name: Tibayan
Address: Philippines
I can also open Jerics Favorite Food record which outputs
Vegetable : Onions
Fruit: Apple
Pizza: Pepperoni
I hope you guys can tell me if I'm on the right track.
Or suggest a better way to do it
Many thanks in advance