I'm new to SQL and am attempting to create database DB schema usable with Hibernate but am worried about scaling issues, data access and best way to query data. I should be able to display all assignments per quarter and current grade. I should also be able to get these for any year Trading attended school 1Q at a time. Teachers and admin should be able to retrieve from all stored history again 1Q at a time. Q1 Scalability Will there be a performance issue? Is there trading issue with a table growing to M entries? Is there a better way to split up the data? Thinking of retrieving schema data per student on id between dates thus quarters which is in system. Should I add another column for quarterID and make a table to store them? I am aware that these two can be joined in another class GradedAssignment using a SQL join statment:. Does this schema seem right? Added updates from below NOTE: I omitted for brevity many table system. TeacherClass Ref table - teacherid PK - classid. Assignment - assignmentid PK - teacherid FK - pointsPossible - assignDate - dueDate - name - description. Considering the dynamics of a school I think there have to be a few additions to your schema. Those conditions must also be considered to build a sustainable application. You are right about the compound primary schema on assignmentid, studentid which are also foreign keys. By posting your answer, you agree to the privacy policy and terms of service. Stack Overflow Questions Developer Jobs Documentation beta Tags Users. Sign up or log in to customize your list. Tour Start here for a quick overview of database site Help Center Detailed answers to any questions you might have Trading Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us. Log In Sign Up. Join the Stack Overflow Community. Stack Overflow is a community of 7. Join them; it trading takes a minute: Need schema for school grading system Ask Question. School grading system Background: What is the best way to query for a students quarter grades? Grade[] getStudentGrades studentid, startdate, enddate Naturally it would go along with Assignment[] getAssignmentDetails Grade[] grades I am aware that these two can be joined in another class GradedAssignment using a SQL join statment: GradedAssignment[] getStudentGradedAssignement studentid, startdate, enddate Does this schema seem right? Is this supposed to be a schema of database tables? Very loosely speaking yes. Just enough to get the idea of whats going on across. Grade assignmentid fk classid fk studentid fk grade Rachcha 4, 7 29 I did leave a LOT out to simplify potential schema. I tried to leave just a few fields of interest for inter-table relationships. Other tables were ommitted for brevity. I notced that relationship links such as StudentClass and TeachClass were included. Since grades table would be HUGE. How would you handle it? Perhaps by tuning your queries and your database sever too. Make sure there are relationship system between tables that you are going to join. These will not just schema you enforce integrity constraints but also can give you better performances with indexes on all FKs. So the schema seems like its o the right track. What about the scalability and best way to access. I'm sorry I cannot help you system scalability and ways to acces. I'm not deep into hibernate. Well I thank you for basic schema validation of it being on the right track. Sign up or log in StackExchange. Database up using Facebook. Sign up using Email and Password. Post as a guest Schema. Developers Who Use Spaces Make More Money Than Those Who Use Tabs. Stack Overflow works best with JavaScript enabled. MathOverflow Mathematics Cross Validated stats Theoretical Computer Science Physics Chemistry Biology Computer Science Philosophy more 3. Meta Stack Exchange Stack Apps Area 51 Stack Overflow Talent.
The sudo packages provide the superuser do (sudo) utility, which allows system administrators to give certain users the ability to run commands as root.
I have both lived through domestic violence and I am in school for Psychology, so I do know a little about research.
The sudo packages provide the superuser do (sudo) utility, which allows system administrators to give certain users the ability to run commands as root.
It should be clear that your assignment will not get any credit if.
MONTFORD, JOHN T. (Lubbock, TX, DA, TTU chancellor) (See also.
Having concrete goals empowers your employees and keeps them focused on work.