my system will be for "CCS" department
under CCS department
-----------------------it has 3 courses --- "BSIT", "BSCS", ACT"
every year level has 2 semesters
as my professor said my thesis is aimed to
1. show the present (year level ex.4thyear, semester ex.1st, and grade) by searching using a student number or name
2. show all previous grades (from 1st year up to 4th year) by searching using a student number or name
i need advice on how to make my system's database.
how many tables should i make for to make it more convenience?
ex. table 1
student name
student number
ex. table2
subject code
subject description
grade
remarks
sorry for the bad english grammar..
under CCS department
-----------------------it has 3 courses --- "BSIT", "BSCS", ACT"
every year level has 2 semesters
as my professor said my thesis is aimed to
1. show the present (year level ex.4thyear, semester ex.1st, and grade) by searching using a student number or name
2. show all previous grades (from 1st year up to 4th year) by searching using a student number or name
i need advice on how to make my system's database.
how many tables should i make for to make it more convenience?
ex. table 1
student name
student number
ex. table2
subject code
subject description
grade
remarks
sorry for the bad english grammar..
