student attendance system

(1)

STUDENT

ATTENDANCE

SYSTEM

- By Anita Sharma

&

Shweta Namjoshi

(2)

NAME : (1) ANITA SHARMA

(ROLL NO.: 451)

(2) SHWETA NAMJOSHI

(ROLL NO.: 456)

CLASS : T.Y. B.C.A

COLLEGE : NATUBHAI V. PATEL

COLLEGE OF PURE

AND APPLIED

SCIENCES

V.V.NAGAR.

UNIVERSITY : SARDAR PATEL

UNIVERSITY.

(3)

STUDENT ATTENDANCE

SYSTEM

IS SUBMITTED BY

ANITA SHARMA

&

SHWETA NAMJOSHI

AS PRACTICAL FULFILLMENT OF

BCA DEGREE

FOR THE YEAR 2002-2003

NATUBHAI V. PATEL COLLEGE

OF

PURE AND APPLIED SCIENCES

SARDAR PATEL UNIVERSITY

(4)

PROJECT

(5)

PROJECT NAME : STUDENT ATTENDANCE

SYSTEM

(SAS)

USER : ADMINISTRATIVE OFFICE,

NATUBHAI V. PATEL COLLEGE

OF PURE AND APPLIED

SCIENCES.

HARDWARE : PENTIUM OR CELLERONE

REQUIREMENT PROCESSOR 64 GB RAM,

10 GB HARD DISK SPACE

(FOR OPTIMAL PERFORMANCE)

SOFTWARE : FRONTED TOOL –

REQUIREMENT

VISUAL BASIC 6.0

BACKEND

(6)

INTRODUCTION TO MICROSOFT ACCESS 2000 (Back-end tool)

Microsoft Access 2000 is s one of the world’s most

popular and powerful relational database systems,

and it is part of the Microsoft Office 2000 Professional

Edition. Using Access, you can create a sophisticated

and powerful database that includes data entry forms,

reports and queries to store and analyze information

on any number of topics.

Using the Access Database Wizard, you can quickly create detailed databases that handle a number of business and personal functions such as order entry, contact management, or event management. If none of the database templates in the database wizard suits your needs or if you just want to create a database from scratch, you can easily do as well.

The Access table wizard offers an easy way to create your own tables. Access includes numerous table templates that you can use to create both business and personal database tables. Access also provides step by step guidance as you create your own database.

(7)

INTRODUCTION TO VISUAL BASIC 6.0

(FRONT-END TOOL)

Visual Basic is a programming language and

development that allows you to create programs that

run under the windows operating system. It enables

you to develop many different type of applications, it

is a programming language used to create

window-based application. It makes it very easy to get the user

interface of the application and running it. It is very

easy and it provides a very user-friendly environment

while programming in Visual Basic. It provides a vital

link to graphical environment and allows you to

develop applications based on standard windows,

features: dialog boxes, command buttons, pull-down

menus, scroll bars and selection lists etc. it also

allows creating robust applications that fully makes

use of the graphical user interface.

APPLICATION HIERARCHY OF VISUAL BASIC 6.0

An application is made up of forms, controls, modules

and classes. Forms are windows on which you build

your user interface. Controls are building blocks of

user interface. Controls are also called ActiveX

Controls and command buttons that are used to

display information to the user, gather information

from the user, and respond to the user action. Classes

are templates from which we can create our own

object of run time. This reusable class module aids us

in organizing our application into small components

that can be building into a complete application.

Procedures are small routines in which you can write

and are callable from any where in your application.

Event is very important in any windows programming

(8)

response to a user interaction with keyboard and

mouse. They are those messages that the operation

system sends to the application.

FORMS

MODULES

- Properties - Procedures

- Property procedures - Functions

- Event handlers - Other procedures

CONTROLS

CLASSES

- Properties - Properties

- Event handlers - Property procedures - Methods - Public methods

- Private methods

_{Page No.}

1. Introduction to system.

2. Introduction to Natubhai V. Patel

College Of Pure And Applied

Sciences.

3. Introduction to existing system

• Features of existing

system.

• Problems of existing

system.

• Description of proposed

system, objectives and its

advantages.

(9)

4. Requirement analysis

• General.

• Used in the proposed

system.

5. System Requirement

Specification

• Introduction



Purpose



Scope



Definition



Acronyms and

Abbreviations



References



Overview

• General Description



User Characteristics



General Constraints

6. Tools information

• Microsoft Access 2000

• Visual Basic 6.0

7. System Design

• Data flow analysis

• Database files

• Data dictionary

• Process hierarchy

• Input and Output design



Input screens



Reports

(10)

STUDENT ATTENDANCE

SYSTEM

Since ages, attendance system has remained one of the most important systems for evaluating the working time of students in any college or school. In short, this is used every where wherever the human labor is of importance in terms of the number of hours labored for, in a wider application example, also to mark the number of days present/absent in any academic year of students in a college, school etc.

The data for each student is fetched by either manual system or by electromechanical devices like punch card, time-notation devices etc.

In attendance system, which is manual in nature, the lecturer takes the attendance of the students of different departments of the college. The information regarding attendance is then given to the counselor. The counselor then checks for the number of presents, absents and whether he/she has taken the leave for the absent. And finally he/she prepares the attendance report.

In attendance system, which is computerized in nature, the lecturer takes the attendance of the students of different departments of the college. The information regarding attendance is then given to the counselor. The counselor then submits the information to the computer programmer and he feeds the data into the computer and gets the final attendance report.

(11)

INTRODUCTION TO NATUBHAI.V.PATEL COLLEGE OF

PURE AND APPLIED SCIENCES

1. Establishment and Management:

The process of establishing the college was catalyzed by the generous donation of Rs.1 crore by Natubhai V. Patel Charity Trust, Bombay to CVM against project outlay of Rs.5 crore. Charutar Vidhya Mandal manages N.V.P.A.S., established in 1996. It is perhaps the only permanently self-financed college in the state.

2. Facilities and Teaching Staff:

College is housed in a three-storied building with specious classrooms in adequate number. Its laboratories are modern and well equipped. Its library is rich and continuous to grow as more and books are added every year. It has a large reading room where in students have access to number of dailies, periodicals and magazines.

Teaching staff consists of duly qualified and competent teachers, supported by highly experienced retired professors.

3. Affiliation:

The college is affiliated to Sardar Patel University, Vallabh Vidya Nagar.

4. Medium of Instruction:

. Medium of instruction is English

5. Special Features:

i. Individual experimental work on 1:1 basis.

ii. Reading material supplied by the college on no profit no loss basis.

iii. Practice test conducted round the year for continuous evaluation.

iv. Individual attention and care.

v. Free remedial classes for all the students of F.Y.BSc. vi. Tutorials of two hours per week per batch for difficult

(12)

vii. Use of audio/visual aids for effective teaching.

6. N.V.P.A.S. has basically two branches:

1) B.Sc. & 2) B.C.A

The courses available in B.Sc

are:-a) Chemistry

• Analytical Chemistry

• Applied Chemistry

• Industrial Polymer Chemistry

• Chemistry • Industrial Chemistry

b) Biology

• Biotechnology • Microbiology • Environmental Science

c) Physics

• Instrumentation

d) Mathematics

e) Computers

• Information Science • Computer Science

(13)

-F.Y.B.C.A: Course nos. 101 to 110 S.Y.B.C.A: Course nos.201 to 209 T.Y.B.C.A: Course nos.301 to 309

7. Attendance:

i. Theory and Tutorials:

Regular attendance in each term is obligatory. ii. Practical:

Regular is attendance in laboratory is essential. A student should produce his/her journal duly certified by the head of the department that he/she has satisfactorily completed the laboratory assignment. This certificate will not be issued only on the basis of regularity of attendance in the laboratory.

iii. Internal marks:

Candidates should have obtained 15% marks in the individual heads of passing and 25% marks in the aggregate of all heads of passing at internal tests conducted by the college.

iv. Certificate stating absence due to sickness, participation in sports or co-curricular activities should be produced within 10 days of the recovery or completion of the event. The certificate submitted after the prescribed time limit will not be taken into congnisance.

8. Discipline:

The behavior of the student with one and all should be courteous, polite and disciplined. The admission of the students violating this code of conduct will be canceled.

(14)

9. Co-curricular activities:

College conducts group discussions, debates, science association, and cultural activities etc. as a part of co-curricular activities to develop the personality of the students.

10. Student’s counseling service:

The college has set up a counseling cell, which provides counseling to all its students. Every class is assign to a counseling teacher who acts as a local guardian to students and keeps the personal record of each student of the batch. A meeting is called periodically to monitor student’s academic progress and counsel them regarding their curricular, co-curricular and personal problems.

(15)

SYSTEM STUDY



Existing system:

In the attendance system of our college, the lecturer who is teaching takes the attendance of the students of different classes in that particular period in the attendance slip mentioned below:

Natubhai V. Patel College Of Pure and Applied Sciences

Attendance Slip

FY/SY/TY B.Sc./BCA Class

Subject: Course no: Period: Date: Teacher’s name:

Following roll nos. were present (Absent roll nos. are deleted)

Div. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50.. Teacher’s Signature

The attendance slips are collected and they are submitted to the office clerk through peons. The office clerk maintains the attendance of all the students of all the classes. He also has to keep the information about the leave of the students. After making the attendance report manually, the office clerk has to send the attendance information about the students to their respective class counselor, who also maintains the information manually. The attendance report for theory classes that is maintained is shown on the next page:

(16)

ATTENDANCE REPORT FOR THEORY CLASSES

Natubhai V. Patel College of Pure and Applied Sciences

Vallabh Vidya Nagar Class:____ Division:______ ATTENDANCE ROLL

Roll No. Name 1 2 3 4 5 6 7 8 ... 3 1 No of Days Remarks Present Absent

For taking leave, a student has to fill up a leave form, which is shown on the next page. Now after filling the leave form, the student has to get it signed from the principal and if the principal approves it, then only in the place of absent in the attendance report the counselor marks L (Leave). In the attendance report,

A tends to absent P tends to Present L tends to leave.

(17)

In practical the programmer takes the attendance and the programmer himself maintains the attendance report, which is shown below:

N.V.PATEL COLLEGE OF PURE AND APPLIED SCIENCES Attendance Sheet

Year:

Class: Month:

Roll

(18)

The list of public holidays of 2002 as declared by SARDAR PATEL UNIVERSITY is shown below:

Sr no.

Name of holiday Date Month Day 01 Makarsankranti 14 January Monday 02 Republic Day 26 January Saturday 03 Bakri-Id 23 February Saturday 04 Mahashivratri 12 March Tuesday 05 Moharram 25 March Monday 06 _• Good Friday

• Dhuleti

29 March Friday 07 Mahavir Jayanti 25 April Thursday 08 Bhagvan Shri

Parshuram Jayanti 14 May Tuesday 09 Ide Milad 25 May Saturday 10 Independence Day 15 August Thursday 11 Parsi New Year 21 August Wednesday 12 Raksha Bandhan 22 August Thursday 13 Janmashtami 31 August Saturday 14 Samvantsari 10 September Tuesday 15 Gandhi Jayanti 02 October Wednesday 16 Dusshera 15 October Tuesday 17 Sardar Patel’s Birthday 31 October Thursday 18 Diwali 04 November Monday 19 New Year 05 November Tuesday 20 Bhai Bij 06 November Wednesday 21 Gurunanak Jayanti 19 November Tuesday 22 Ramjan Id 06 December Friday 23 Christmas 25 December Wednesday

(19)

LEAVE FORM

Inward No. Name:

To Class: FY/SY/TY B.Sc./BCA The Principal, Prin.Sub. : _____ Roll no: ___ N.V.P.A.S College, Date: - - 200

Vallabh Vidyanagar.

Sub: Application for leave of absence Respected Sir,

I request you to grant me leave of absence from the college from ____ to ____ on account of:

a) Personal work/a ceremony

b) My illness (medical certificate is produced/will be produced) c) ___________________________________________________

I have until now availed of __ days of leave of absence.

If the requested leave is granted I would miss following assignments: Subject

Theory Practicals

Tick marks the appropriate boxes after writing the relevant subjects. I know that such leave of absence does not absolve me from completing required number of practical necessary for journal certification or attending 80% of theory. Thanking you,

Yours obediently

Leave of absence granted (Student’s signature) Principal

(20)



Problems of existing system

:

• As the information regarding attendance is not stored on computers, when any information is required, manual labor is needed to search for it and find out the required information. Not computerizing increases the work of keeping all the records safely in a manner in which they can be obtained when needed.

• Since all the processes in maintaining the attendance are performed manually by the office clerk and the counselor, it increases the workload on them and makes work error-prone and tedious.

• Data security is another major problem. In the current system, access and alteration of data by unauthorized people is always possible. This is of great threat because anyone and everyone can access personal information of students.

• The present system does not provide a good interface with the user. Also here with the increase in the number of records stored, the storage and retrieval rate increases. Thus performance of system goes down with increase in number of student’s record.

• In the current system the amount of paper work to be stored safely and systematically is large and so it results in go-downs of paper work.

• Also it takes lot of time and is also costly as compare to computerized system.

(21)



Description of the proposed system

:

In the computerized system of maintaining the attendance report of the students, first the attendance is taken by the concerned lecturer in the attendance slip. The lecturer then submits their attendance slips to the counselor of that particular class. The counselor then submits all the attendance slips of all the lectures of a particular class to the computer programmer. The computer programmer then feed the data in the computer. In case if a student is not able to attend the college, then he has to fill a leave form. His leave is granted only if it is approved by the principal. In that case the computer programmer has to update report.



Objectives and advantages

:

The purpose of the project is to develop a student attendance system, which has better data security, performance and user interface than the current system. In the current system, the attendance is maintained manually, due to which the people concerned with maintaining the attendance report have to face lot of problems like: problem of data security, not properly storage of data, increases the work load, takes a lots of time etc. It is also a very tedious job and as manipulation of data is very easy it is error prone. So, to solve these problems we computerized the student attendance system.

(22)



Scope

In the computerized system of maintaining the attendance report of the students, first the concerned lecturer in the attendance slip takes the attendance. The lecturer then submits their attendance slips to the counselor of that particular class. The counselor then submits all the attendance slips of all the lectures of a particular class to the computer programmer. The computer programmer then feed the data in the computer. In case if a student is not able to attend the college, then he has to fill a leave form. His leave is granted only if it is approve by the principal. In that case the computer programmer has to update report.

The scope of this system is very large:

• We can generate the lecture-wise attendance report.

• Attendance report on daily basis, weekly basis.

• We can also graphically represent a student’s attendance to see whether he/she is regular in the college.

• We can also send the attendance of a particular student to his parents through

e-mail.

• We can also implement the program in such a way that it facilitates the communication between the programmer and the principal of the college regarding the student’s attendance.

• Since in our system there is no restriction of taking the leave. Means a student can also take the leave within five days or within ten days. So, we can also put the restriction that the leave of the student is granted only if he/she takes the leave within five days.

(23)



Requirement analysis:

FACT GATHERING TECHNIQUES USED:

For the development of the student attendance system for N.V.P.A.S., we have used three fact-gathering techniques.

1) OBSERVATION:

Our use and observation of the current system helped us to find out the Operational inefficiencies in the existing system. These Operational inefficiencies are:

-Poor interface with user for input taking and output giving, no data security, delay in producing the report, lack of programming, inefficient storage and retrieval rates with increase in number of student records etc.

Having identified these Operational inefficiencies in existing system, we have tried to overcome them in the new system.

2) RECORD REVIEW:

The current system users suggested that the new system should have computerized attendance. Review of the past records of the current system clearly showed that it would be definitely more advisable to develop a new system with the user demands incorporated, rather than improvising the existing system.

3) INTERVIEW:

By interviewing people concerned with maintaining the attendance report, we concluded that people had to face many problems regarding - increase in the work load, making the work error-prone and tedious, maintaining lot of files each department, problem regarding data security and problem of timeliness.

So, we come to the conclusion that maintaining the attendance report-using computer is far better than maintaining it manually.

(24)

SYSTEM REQUIREMENT SPECIFICATION DOCUMENT

(SRS)

1. INTRODUCTION:

Our project is for the student attendance system for Natubhai V. Patel College Of Pure And Applied Sciences.

• Purpose

• Scope

In the computerized system of maintaining the attendance report of the students, first the concerned lecturer in the attendance slip takes the attendance. The lecturer then submits their attendance slips to the counselor of that particular class. The counselor then submits all the attendance slips of all the lectures of a particular class to the computer programmer. The computer programmer then feed the data in the computer. In case if a student is not able to attend the college, then he has to fill a leave form. His leave is granted only if the principal approves it. In that case the computer programmer has to update the report.

The scope of this system is very large:

• We can generate the lecture-wise attendance report.

• Attendance report on daily basis, weekly basis.

• We can also graphically represent a student’s attendance to see whether he/she is regular in the college.

• We can also send the attendance of a particular student to his parents through e-mail.

• We can also implement the program in such a way that it facilitates the communication between the programmer and the principal of the college regarding the student’s attendance.

• Since in our system there is no restriction of taking the leave. Means a student can also take the leave within five days or within ten days. So, we can also put the restriction that the leave

(25)

of the student is granted only if he/she takes the leave within five days.

• Definition

We are doing the project on student attendance system.

• Acronyms and Abbreviations

In our system of student attendance we have used the following abbreviations:

L for Leave A for Absent P for Present

NOW for Number of Working days H for Holidays

• References

With the help lecturers, counselor, office clerk and the project guide, we were able to complete this project on student attendance.

• Overview

2. GENERAL DESCRIPTION:

• User Characteristics

The user of this system should know how to operate a computer and get the data that he/she wants.

(26)

DATA FLOW ANALYSIS

It is concern with the information regarding: -1. Data used in the system

2. Entry of data in the system 3. Process that take place on data 4. Storage of data

It has four main tools: -a) Data flow diagrams

Used in requirement b) Data dictionary analysis

c) Data structure diagrams

Used in system d) Structure charts design

(27)

CONTEXT DIAGRAMS

A context diagram is a structured graphical tool for identifying the organizations functional areas and the processes that are performed with. In, and between the organization and the outside world. Context diagram supports a data oriented approach system design. Helps you investigate the output and process requirement of the organization. Helps you define the boundaries of the proposed system.

Symbols used in context diagrams are those for external entities, storage, and data flows and process.

Levels of context diagram:

a. User level

b. Combined user level c. Organizational level

(28)

DATA FLOW DIAGRAMS

Data flow diagrams (DFD) are a graphical aid for defining system inputs, process and outputs. It represents flow of data through the system. They are used in system analysis. They can easily explain to the user the understanding of the system by the system analyst. They can be readily converted to structure charts.

Symbols used are:

1.

Process: - Shows transformation of input to output. 2.

External entity: - Source or destination of data external to the system. 3.

Data flow: - A packet of data. 4.

Data store: - Any stored data, without reference to physical methods of storing.

(29)

LEVELS OF DFD

1. Level 0:- System input / output.

2. Level 1:- Subsystem level data flow-functional level. 3. Level 2: - File level detail data flow.

INPUT DESIGN

Nature of output is dependent largely on the input.

Input design involves capturing of data as well as inputting it to the computer.

INPUT DESIGN

________________________________________________________________ DATA CAPTURE DATA VALIDATION

OUTPUT DESIGN

Refers to the information generated by the system.

System cannot be designed properly without knowing the output that is needed.

(30)

FACT GATHERING TECHNIQUES

Information gathering in large and complex organizations is not an easy task. It has to be gathered in an organized way so that

a. No system details are left out. b. Right problems are identified. c. Repetitive work is avoided.

d. Wrong or incomplete details are not collected. Fact gathering techniques used are:

1. Interviewing:

-This technique is used to collect the information from individuals or from groups. It is an invaluable technique used to collect qualitative information, opinions, policies, suggestions, underlying problems etc. It clearly indicates any resistance to the proposed system, and is meant for depth research.

2. Questionnaires:

-Can be used as a supplement to interviews. More people can be reached and answers can be corroborated. They may consist of open or closed ended questions.

3. Record review : -

A good analyst always gets facts from documents because an existing system can be better understood by examining existing documents. It can take place at the beginning of the system study or at any later stage.

4. Observation:

-Observation can bring in missed facts, new ways to improve the existing procedures. It can bring in what other fact-finding methods can’t. It took after operational inefficiencies, alternative routes and procedures, interruptions in normal workflow etc.

(31)

INTRODUCTION TO

HARDWARE

AND

SOFTWARE

HARDWARE REQUIREMENT :

Our system will easily work on the current hardware available. It won’t require much additional hardware. To be specific our system will work with optimum performance on Pentium or Celeron processor, with a hard disk capacity of 10GB and RAM of 32 bits.

SOFTWARE REQUIREMENT :

FRONTEND TOOL: - VISUAL BASIC 6.0 BACKEND TOOL: - MICROSOFT ACCESS

(32)

“Knowing is not enough one must apply,

willing is not enough, one must do”

-Goethe

“We man would do nothing, if he waited until

he could do so well that no one would find

fault with what he has done”

(33)

(34)

We take immense pleasure to record our gratitude for the tremendous help received from dedicated stalwarts, who endured us on initial follies, with infinite patience and good grace, went ahead to direct, guide and correct us to complete our t.y.b.c.a. project. Hence we could cover the significant milestone in our educational career, now stand with vibrating confidence to taste mysteries and marvels of computer science, harnessing the same for the benefit of mankind. Thus we initiate the innings of our life, however with a reminiscence for all those without whom we would have never seen this day. Firstly we would like to express our sincere gratitude for director D.A.Raval

Sir for giving us the permission to go on with our project of STUDENT ATTENDANCE SYSTEM for N.V.P.A.S. Then we would like to thank the

H.O.D. of computer department, our project coordinator and our project supervisor MR. KAMLESH VAISHNAV for guiding us throughout our ordeal. We sincerely thank MR.UTPAL DHOLAKIYA for giving us the much needed moral support.

Last but not the least, we also thank ALPESHBHAI for giving us the required knowledge of the existing attendance system and for guiding me throughout. We are very grateful to GOD, for giving us all that we have and to our

(35)

DOCUMENTATION

TOOL : MICROSOFT WORD

PROJECT

COORDINATOR : MR.KAMLESH VAISHNAV

PROJECT

SUPERVISOR : MR.KAMLESH VAISHNAV

COUNSELOR : MR.UTPAL DHOLAKIYA

DATE OF

COMMENCEMENT :

DATE OF

(36)

PROJECT NAME : STUDENT ATTENDANCE SYSTEM

(SAS)

USER : ADMINISTRATIVE OFFICE,

NATUBHAI V. PATEL COLLEGE OF

PURE AND APPLIED SCIENCES

HARDWARE

REQUIREMENT

:

PENTIUM PROCESSOR

64 MB RAM

10 GB HARD DISK SPACE

• COMPAQ KEYBOARD

• COMPAQ MONITOR

• COMPAQ MOUSE

SOFTWARE REQUIREMENT:

FRONTEND TOOL - VISUAL BASIC

BACKEND TOOL - MICROSOFT ACCESS

(37)

DATABASE FILES



Student_information

Column name Data type Size Constraint

Roll_no Number 3 Not null

Name Number 30 Primary key, not null

Class Text 5 Not null

Dept Text 10 Primary key, not null

Current_address Text 120 Not null

Phone_no1 Text 20 -City1 Number 15 -State1 Text 15 -Permanent_address Text 120 -Phone_no2 Text 20 -City2 Number 15 -State2 Text 15

-

Lecturer_information

Column name Data type Size Constraint Lecturer_name Text 50 Not null

Dept Text 10 -Phone_no Number 20

-Current_address Text 70

-Permanent_address Text 70

-Phone_no1 Number 20

-City1 Text 20

-City2 Text 20

-Counselling_class Text 5

(38)

-

Time_table

Day Text 9 Not null

Dept Text 10 Not null

Subject_code Text 8 Not null

Period_start Number 5 Not null Period_end Number 5 Not null

Course_Title Text 50 -Lecture_per_week Number 3 -Theory_practical Text 15 -Lecturer_name Text 50 -Session Number 25

-

Class_information

Dept Text 10 Not null

Class Text 5 Foreign key

reference to

student_information table

From_rollno Number 3 Not null To_rollno Number 3 Not null Room_no Number 10 Not null Counsellor_name Text 50 Not null

(39)



Attendance_information

Date Date -

-Dept Text 10

-APLStatus Text 1

-

Leave_information

Roll_no Number 3 Foreign key reference to

student_information table

Reason Text 30 Not null

From_date Date -

-To_date Date -

-Name Text 50 Not null

(40)

-DATA DICTONARY

Sr

no. Column name Data type Size Description Database files used 01 Roll_no Number 3 Use to

store information of roll no of students

Student_information

02 Name Text 30 Use to store name of the student

Student_information

03 Class Text 5 Use to store class of the student

Student_information

04 Dept Text 10 Use to store

department of the student

Student_information

05 Current_address Text 125 Use to store the current address of the student

Student_information

06 Phone_no1 Number 20 Use to store phone no of his current address Student_information

07 City1 Text 15 Use to store name of the current city

Student_information

08 State1 Text 15 Use to store name of the current state

Student_information

09 Permanent_address Text 125 Use to store permanent address of the student

(41)

10 Phone_no2 Number 20 Use to store phone no of his permanent address Student_information

11 City2 Text 15 Use to store name of the Permanent city

Student_information

12 State2 Text 15 Use to store name of the Permanent state

Student_information

13 Lecturer_name Text 50 Use to store name of the lecturer

Lecturer_information

14 Dept Text 10 Use to store the department of the lecturer

15 Phone_no Number 20 Use to store phone no of the current address of lecturer Lecturer_information

16 Phone_no1 Number 20 Use to store phone no of the permanent address of the lecturer Lecturer_information

17 Current_address Text 70 Use to store the current address of the lecturer

18 Permanent_address Text 70 Use to store the permanent address of the lecturer

(42)

19 City1 Text 20 Use to store the city name for current address of lecturer Lecturer_information

20 City2 Text 20 Use to store the city name for the permanent address of the lecturer Lecturer_information

21 Class Text 5 Use to store name of class for which time table is given Time_table

22 Dept Text 10 Use to store name of department for which timetable is given Time_table

23 Period_start Text 5 Use to store information about time when the period starts Time_table

24 Period_end Text 5 Use to store information about time when the period ends Time_table

25 Day Text 9 Use to store day for the lecture

(43)

26 Subject_code Text 8 Use to store the code of subject for which the timetable is given Time_table

27 Course_title Text 50 Use to store the name of the course for which timetable is given Time_table

28 Lecture_per_week Number 3 Use to store the no of times the lecture occurs in a week Time_table

29 Theory_practical Text 15 Use to store whether the given period is a theory or a practical Time_table

30 Lecturer_name Text 50 Use to store the name of lecturer who takes the period Time_table

31 Session Text 25 Use to store the session whether it is morning or middle or afternoon Time_table

32 Class Text 5 Use to store class information

(44)

33 Dept Text 10 Use to store the Departmen t information Class_information

34 From_rollno Number 3 Use to store the starting roll no for the class

Class_information

35 To_rollno Number 3 Use to store the ending roll no for a class

Class_information

36 Room_no Number 10 Use to store the information of room no of the class

Class_information

37 Counsellor_name Text 50 Use to store the name of the counselor for the class Class_information

(45)

38 Date Date - Use to store information about the date when the attendance is taken

Attendance_information

39 Class Text 5 Use to store the class name whose attendance is to be taken

40 Dept Text 10 Use to store department name whose attendance is to be taken

41 APLStatus Text 1 Use to store the status of present or absent or leave

42 Reason Text 30 Use to store information about the reason of leave

Leave_information

43 From_date Date - Use to store information about the date from when the leave was taken

Leave_information

44 To_date Date - Use to store information about the date until when the leave was taken

Leave_information

45 Class Text 5 Use to store the class of the student who has taken leave

Leave_information

46 Dept Text 10 Use to store department of the student who has taken leave

(46)

47 Roll_no Number 3 Use to store the roll no of the student who has taken leave

Leave_information

48 Name Text 30 Use to store the name of the student who has taken leave

(47)

Natubhai V. Patel College Of Pure And Applied Sciences

Certificate

This is to certify that Ms. of

T.Y.B.C.A.(Seat No. ) has worked on project entitled

Student Attendance System, from (Date) to

(Date) .This (B.C.A.-309) is in-house

project course of three credits.

She was regular in her work and devoted around 200 hours for the

project including analysis and design. She has completed the

project satisfactorily.

Head/Coordinator Supervisor

(48)