I am working on registration part of my web application.There is two types of category one is employee and other is student.
And Employee further can be(Faculty,Accountant,Librain..) and Student can be from different course like(Technology,Management,Law,Fashion).
And further student inside that will be different category like
And then each course category will contain data of 1st,2nd,3rd,4th year students.
I want to store seprate table for students of different courses and different course category.
And I have make only one simple model class Student in my project.
How could I acheive this.?
If I am not able to describe my problem statement fully please ask
No it won't.
Databases are designed to work with large amounts of indexed data.
Putting them into separate tables will result in you having to manage where to pull data from.
For example a query on "get me all students in BTech" will involve pulling data from 4 tables, instead of a simple "SELECT * FROM Student WHERE CategoryId = <whatever the BTech id happens to be>".
I don't have a handy link, but I would recommend some reading up on how to structure database tables.
One more question I have relational data like a Student has(
His Library Record(Books Issued),
His Finacial Information(Fees,Dues),
His Genral information(dob,email,phone number,father's name)
and many more.
How to store this data.
All these information are not updated or added at the same time.
Like His Genral Information will be add when he is enrolled in university.
His Libraray information is when he started learning
His Finance information what he paid and what is pending and so on.
So How to store this data
Approach I am think is some one to many and many to one and many to many associations in hibernate,But I don't know how to implement this in hibernate.
Library will be a seprate model class(which contain some attribute in it like book date,number,issue date...)
And similarly Finance information is also a Model class.
How to link these two model class with a Student_id?