Need help with attendance project in oracle9i

[gold casper]

Hi

I'm working in oracle9i form developer and report developer

I'm doing school attendance system to take the attendance for students but I don't know how many tables I need and how to make all the forms correctly

I've done a form for registering new students, for classes, attendance and reports form

attendance form here we should take the attendance I've used student and class table but it doesn't work with me even the reports I don't know how to make it, there should be a daily, weekly and monthly report for the attendance but I don't know how to do it and how to make connection between form and report

Please help me to do it, I have to submit my project tomorrow and I don't know what to do... I will be thankful for any help

[gold casper]

hello

no body there to help me or what??

[Niheel]

You have to post the code where you seem to be having a problem with. We can't help you debug if you don't show the code and error messages you get.

[gold casper]

I still not having the code, I want to know how many feilds I need for developing an attendance form I tried to develop it and I create tables i can show you an example of that

Drop table Student CASCADE CONSTRAINTS;
Drop table Class CASCADE CONSTRAINTS;
Drop table Teacher CASCADE CONSTRAINTS;
Drop table Teacher_Class CASCADE CONSTRAINTS;
Drop table Main CASCADE CONSTRAINTS;
Drop table Attendance CASCADE CONSTRAINTS;
Drop table Period CASCADE CONSTRAINTS;


Create table Student
(st_cpr_no number(9) primary key,
st_f_name varchar(25), st_s_name varchar2(25),
st_m_name varchar2(25), st_l_name varchar2(25),
st_address varchar2(30),
st_phone_no number(8),
st_nationality varchar2(30),
st_dob date,
st_j_date date);

COMMIT;

Create table Teacher
(t_cpr_no number(9) primary key,
t_name varchar2(25),
t_address varchar2(30),
t_phone_no number(8),
t_nationality varchar2(30));

COMMIT;

Create table Class
(class_id number(1) primary key,
class_name varchar2(25));

COMMIT;
Create table Teacher_Class
(t_cpr_no number(9), class_id number(1),
FOREIGN KEY (t_cpr_no) REFERENCES teacher(t_cpr_n o) on delete cascade,
FOREIGN KEY (class_id) REFERENCES class(class_id) ,
PRIMARY KEY (t_cpr_no, class_id));

COMMIT;

Create table Period
(period_id number(4) primary key,
class_id number(1) constraint fk_classid references class(class_id) ,
t_cpr_no number(9) constraint fk_tcpr references teacher(t_cpr_n o));

COMMIT;

Create table Main
(st_cpr_no number(9) references student(st_cpr_ no),
class_id number(1) references class(class_id) ,
date_d date,
constraint pr2_key primary key(st_cpr_no, class_id));

COMMIT;

Create table Attendance
(st_cpr_no number(9)
CONSTRAINT st_cpr_no_nn not null,
absent_late varchar2(7),
CONSTRAINT absent_late_chk
check ( absent_late in ('Absent','Late ','Present')),
constraint st_cpr_pk primary key (st_cpr_no));

COMMIT;

Insert into student values
(921007314,'Han an','Hussain',' Ahmed','Sarhan' ,
'Hamad Town 1425A', 17443496,'Bahra ini',
'27-Oct-92','16-Sep-98');

COMMIT;

Insert into student values
(930607314, 'Layla','Ahmed' ,'Mansoor','Sal im',
'Isa Town 125', 17689866, 'Bahraini',
'27-Jun-1993','10-Sep-1999');

COMMIT;

Insert into class values(1,'First Primary');

Insert into class values(2,'Secon d Primary');

Insert into class values(3,'Third Primary');

Insert into class values(4,'Forth Primary');

Insert into class values(5,'Fifth Primary');

Insert into class values(6,'Sixth Primary');

Insert into class values(7,'First Intermediate');

Insert into class values(8, 'Second Intermediate');

Insert into class values(9,'Third Intermedaite');

COMMIT;

Insert into teacher values
(752036584, 'Sameeha Ahmed');


Insert into teacher values
(780703050, 'Amal Al Muraisi');

Insert into teacher values
(610045264, 'Juhaina Eid');

COMMIT;


I want to create a form in (oracle9i form developer), my question, is all that tables I need? and which one I can use to make attendance form that includes class id that when I choose it the student number and name should appear to me and from there I can choose from a combo to decide if this student present, absent or lat) can you show me how to do it?

thanks alot