I am trying to create attendance entry system, where the system will perform the following tasks:
1. Individual or whole class %age attendance for all subjects of a particular semesters, particular departments some specified class section or individual subjects of a particular semesters, particular departments some specified class section.
2. %age analysis of whole class or particular student for all subjects of a particular semesters, particular departments some specified class section or individual subjects of a particular semesters, particular departments some specified class section for a supplied range of attendance %age. For Example: I want to know a what is %age of class attended by a student A of Computer Science department, 3rd Semester, Sections A who are falling in the range of 70-80%
3. I also want to perform the above two analysis against a particular faculty or all the faculties who are taking class to which student A belong to.
4. Number of classes taken by individual faculty of each departments particular semesters some section.
Now I am listing all tables with attribute names.
a. Departments(Department_ID, Department_Name) sample values are 1, 'CSE'; 2, 'ECE' etc...
b. Subjects(Subject_ID, Subject_Title, Subject_Code, Subject_Credit) sample values are 1, 'Java Programming', 'CS 506', 4; 2,'Database Management System', 'CS 503', 4
c. Periods(Period_ID, Period_Name), sample values are 1, 'First Period'; 2, 'Second Period'..... till 'Tenth Period'
d. Sections(Section_ID, Section_Name), sample values are 1, 'Section A'; 2. 'Section B'; 3. 'Section C'
e. Semesters(Semester_ID, Semester_Name, Semester_Type), sample values are 1, 8, 'even'; 2,7,'odd', 3, 6, 'even'.....so on till 8,1,'odd'
f. Students(Student_ID, Student_Name, Semester_ID, Department_ID, Class_Roll, Section_ID, Group_ID)
g. Lab_Group(Group_ID, Group_Name), sample values are 1,'Group A'; 2, 'Group B'
h. Attendance(Attendance_ID, Attendance_Status), sample values are 1, 'Present'; 2,'Absent'; 3,'Leave'
Now the problem I am facing is what will be table structure and how to store the attendance of several students in a separate table to perform the above mentioned tasks.
Please Advice this as soon as possible.
Sounds like an interesting homework question, but not really applicable to this forum.
When you have your data model sorted out, if you need assistance implementing it with SQL Developer, please let us know.
Have you tried any of the Data Modeler resources? What are your specific SQL Developer questions?
A list of said resources can be found here
If I buy a hammer at Home Depot, I can't ask them to build a house for me. Well, I can, but I won't get a house from them.
Edited by: Jeff Smith SQLDev PM on Jan 16, 2013 3:39 PM
Since as you state this is part of a major ERP project, if you are not comfortable interpreting and transforming the current tables designs for reporting purposes, you need to ask your management to get a data modeler to help out. Or ask to be sent to the training needed to do the design work yourself.
This is a support forum for an piece of software, not a forum to get assistance in doing project work for your employer. Sorry.
You might try posting the problem on a LInkedIn discussion forum for Data Modeling. Someone there might be willing to help you out.