Hello everybody! I need help to move on on my database. It is a secondary school (as it called in my country) database which include 6 levels. A student join the school, and must to pass the 6 level (one level per year), so the student will stay at least 6 years. Then, at each year there are number of courses (which are not same for each level) that the student to take. For example, level 1 includes : Math, English, Computer, level2: Math, Chemistry, Physics... and so on. The credit of each course vary from level to other, for example Math in level 1 differ from Math in Level2 in terms of the credit. Please help me how to structure my database. I tried many approaches but can't figure it out. Any help would appreciated.
Students Database structure for high school help
- Thread starter AlefAelol
- Start date
- Local time
- Today, 00:36
- Joined
- Jan 23, 2006
- Messages
- 15,527
Work through 1 or 2 of the tutorials from RogersAccessLibrary that are identified in this link on Database Planning and Design info.
If you spend some time to actually work through these tutorial(s) [45-60 minutes], you will learn (by experience) a process that can be used with any database.
It all starts with a clear description of the problem to be solved.
Good luck.
If you spend some time to actually work through these tutorial(s) [45-60 minutes], you will learn (by experience) a process that can be used with any database.
It all starts with a clear description of the problem to be solved.
Good luck.
mike60smart
Registered User.
- Local time
- Today, 05:36
- Joined
- Aug 6, 2017
- Messages
- 2,151
Hi
Can you upload a zipped copy of your Db so we can see what you currently have as your table structures?
Can you upload a zipped copy of your Db so we can see what you currently have as your table structures?
I tried many approaches, but at each one I stuck in middle of the road. I have attached the database which include the tables and their relationships.
Last edited:
- Local time
- Today, 00:36
- Joined
- Jan 23, 2006
- Messages
- 15,527
Do you have a clear, simple description of the "business"? Please post it.
Have you looked at the RogersAcessLibrary tutorials?
No one can review a data model without a description of the business it is intended to support. Tables and relationships are an implementation of business rules/facts.
Note: If English is not your native language, you can write a clear description in your mother tongue, then translate to English with Google translate. Your English seems more than adequate for communications in the forum.
Have you looked at the RogersAcessLibrary tutorials?
No one can review a data model without a description of the business it is intended to support. Tables and relationships are an implementation of business rules/facts.
Note: If English is not your native language, you can write a clear description in your mother tongue, then translate to English with Google translate. Your English seems more than adequate for communications in the forum.
jdraw, OK,
I will clear it up to you. My database is about a student grades system in secondary school. The school include 6 levels (Level 1 to 6), each level has it won courses to register for. So, let say a student has joined the school, he/she has to start from level 1 for the first year, so he/she must register for the courses of the corresponding level. The same student will will move to level 2 if passes from level 1 and so on. Make sense ?
- Local time
- Today, 00:36
- Joined
- Jan 23, 2006
- Messages
- 15,527
Yes it makes sense. But I'm sure there are some facts that must be considered.
Does every student take the same courses?
Or, for each Level are some courses Compulsory and some optional?
I'm sure a student is examined and must pass/succeed some examination(s)/test(s) in order to progress to next level, right?
Does every student take the same courses?
Or, for each Level are some courses Compulsory and some optional?
I'm sure a student is examined and must pass/succeed some examination(s)/test(s) in order to progress to next level, right?
Thank you jdraw for the replay. In fact, my system is not student dependence but level dependence. So all students for level 1 for example will have same courses, and all courses are mandatory for each students of that level. Regarding the exams or test, yes you are right, for each course there would be two sessions, each session has three exams. In summary of the grades, it looks like :
Code:
First Session Second Session
Exam1 exam2 exam3 Total1 exam1 exam2 exam3 Total2A student to pass a level, he /she has to pass all courses of the level that he/she joined.
Last edited:
mike60smart
Registered User.
- Local time
- Today, 05:36
- Joined
- Aug 6, 2017
- Messages
- 2,151
Hi
Do you have a list of all the Mandatory Courses for Session 1 and Session 2 ??
Or
Does Session 1 and Session 2 cover Just the 1 Subject ??
Can you list some examples??
Do you have a list of all the Mandatory Courses for Session 1 and Session 2 ??
Or
Does Session 1 and Session 2 cover Just the 1 Subject ??
Can you list some examples??
This is a part of my problem. I would like to make it a user defined courses, because some courses shared by many levels but with different context. For example, level 1, level2 and level 3 all include English and Math courses, but the topics are no the same for sure. By the way, I need to get the point her, could we consider the Math course in level 1 and level 2 as same ? because they are not same in term of the topics inside them. They share the name only
They cover different subject. Subject of session can be examined at session 1, for session 2 there will be another subject to be examined.
mike60smart
Registered User.
- Local time
- Today, 05:36
- Joined
- Aug 6, 2017
- Messages
- 2,151
Hi
Then you must have a list as follows:-
Level 1 - Maths - Topic1 /Topic 2 / Topic 3 etc
Level 1 - English - Topic 1 / Topic 2 / Topic 3 / Topic 4 etc
Level 2 - Maths - Topic1 /Topic 2 / Topic 3 etc
Level 3 - English - Topic 1 / Topic 2 / Topic 3 / Topic 4 etc
Can you upload a list like this??
Then you must have a list as follows:-
Level 1 - Maths - Topic1 /Topic 2 / Topic 3 etc
Level 1 - English - Topic 1 / Topic 2 / Topic 3 / Topic 4 etc
Level 2 - Maths - Topic1 /Topic 2 / Topic 3 etc
Level 3 - English - Topic 1 / Topic 2 / Topic 3 / Topic 4 etc
Can you upload a list like this??
Before I upload it, could you just answer my question "By the way, I need to get the point her, could we consider the Math course in level 1 and level 2 as same ?"
mike60smart
Registered User.
- Local time
- Today, 05:36
- Joined
- Aug 6, 2017
- Messages
- 2,151
Hi
Not really understanding this statement "By the way, I need to get the point her, could we consider the Math course in level 1 and level 2 as same ?"
If the Content of Level 1 is the same as Level 2 then this could be classed as the same Course
Not really understanding this statement "By the way, I need to get the point her, could we consider the Math course in level 1 and level 2 as same ?"
If the Content of Level 1 is the same as Level 2 then this could be classed as the same Course
mike60smart
Registered User.
- Local time
- Today, 05:36
- Joined
- Aug 6, 2017
- Messages
- 2,151
Hi
Ok then with that table setup you would be able to use Cascading Combobox's which allows you to select a Level using 1 Combobox and a 2nd Combobox would only display the Courses associated with the Level selected.
Ok then with that table setup you would be able to use Cascading Combobox's which allows you to select a Level using 1 Combobox and a 2nd Combobox would only display the Courses associated with the Level selected.
Sorry, mike60smart !
I couldn't got your tips. Please suggest a general structure to me
Many thanks jdraw,Here is a draft model to consider.
Let me ask two questions about your model
1- How the data should entered to the system by the user? I mean how to organize my forms to make the user enter the information ?
2- There is no academic year in the all tables, can ?
- Local time
- Today, 00:36
- Joined
- Jan 23, 2006
- Messages
- 15,527
So add AcademicYear or any other required fields as appropriate. You know the details. Readers only know what you tell us.
I'm providing a draft data model for discussion based on my interpretation of your posts.
Get your model on paper and tested with some sample data; vet and adjust the model until it satisfies your requirements. Then work on the physical database with your tested blueprint.
A Student enrolls in a Level on a certain Date. Isn't AcademicYear equivalent to level in your set up? How many times can a Student repeat a Level?
If a Course is provided for a Level and that Course content changes, then you might consider a courseDate, but a unique CourseID will handle different Courses.
Perhaps there are more facts to be considered before designing your physical database.
You may get some ideas from this link Stump the Model.
Good luck.
I'm providing a draft data model for discussion based on my interpretation of your posts.
Get your model on paper and tested with some sample data; vet and adjust the model until it satisfies your requirements. Then work on the physical database with your tested blueprint.
A Student enrolls in a Level on a certain Date. Isn't AcademicYear equivalent to level in your set up? How many times can a Student repeat a Level?
If a Course is provided for a Level and that Course content changes, then you might consider a courseDate, but a unique CourseID will handle different Courses.
Perhaps there are more facts to be considered before designing your physical database.
You may get some ideas from this link Stump the Model.
Good luck.
Similar threads
