1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Attendance Entry

Discussion in 'SQL PL/SQL' started by rarhi.krish, Jan 16, 2013.

  1. rarhi.krish

    rarhi.krish Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    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.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Have you given this issue any thought? What table structures have you created? This is obviously a class assignment and, as such, this is your work to do. We will assist you with questions to refine your design but we won't design the table for you.

    Please look at the requirements again; there should be plenty of information in them to provide for a usable table design.
     
  3. rarhi.krish

    rarhi.krish Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    I am doing this particular project using SQL Developer. And this isn't any home work. Its one of the module of CampusERP Project.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    If this is to be a module of an existing project...are there any table structures that already exist that you can use? It's not helpful to create extra tables/columns if you don't really need them.

    CJ
     
  5. rarhi.krish

    rarhi.krish Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    I have provided the complete DDL with the name of the tables which I have created, along with their attribute names and sample data. I just want a help in creating the table Attendance_Entry, where end user's will mark attendance from a web interface. Those entries will get stored in Attendance_Entry, from where we can perform analysis of tasks that I have mentioned in my Topic.
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Think about what information you need to collect for these reports -- that should give you a very good clue where to begin designing this new table.

    Please also post some details about this 'CampusERP' project as I can find nothing about it on the internet.
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Not really -- what you posted is the table name and column names. No actual DDL was posted.