Student Attendance System

STUDENT ATTENDANCE SYSTEM - By Anita Sharma & Shweta Namjoshi

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.

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 (V.V.NAGAR)

PROJECT

PROFILE

PROJECT NAME :

STUDENT ATTENDANCE SYSTEM (SAS)

USER

:

ADMINISTRATIVE OFFICE, NATUBHAI V. PATEL COLLEGE OF PURE AND APPLIED SCIENCES.

HARDWARE REQUIREMENT

:

PENTIUM OR CELLERONE PROCESSOR 64 GB RAM, 10 GB HARD DISK SPACE (FOR OPTIMAL PERFORMANCE)

SOFTWARE

:

FRONTED TOOL –

REQUIREMENT VISUAL BASIC 6.0 BACKEND TOOLMICROSOFT ACCESS 2000

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.

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 windowbased 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 language. An event is something that occurs in

response to a user interaction with keyboard and mouse. They are those messages that the operation system sends to the application. FORMS MODULES - Properties - Property procedures - Event handlers - Other procedures

- Procedures - Functions

CONTROLS CLASSES - Properties - Event handlers - Methods

- Properties - Property procedures - Public methods - Private methods

Contents Topic

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. • Scope of the system.

Page No.

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 8. Bibliography

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.

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. ii. iii. iv. v. vi.

Individual experimental work on 1:1 basis. Reading material supplied by the college on no profit no loss basis. Practice test conducted round the year for continuous evaluation. Individual attention and care. Free remedial classes for all the students of F.Y.BSc. Tutorials of two hours per week per batch for difficult subjects/courses for F.Y.BSc students.

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

The courses available in B.C.A are: -

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.

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.

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: Period: Teacher’s name: Following roll nos. were present (Absent roll nos. are deleted) Div. 1 2 3 4 5

Course no: Date:

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:

ATTENDANCE REPORT FOR THEORY CLASSES Natubhai V. Patel College of Pure and Applied Sciences Vallabh Vidya Nagar Class:____ Division:______ ATTENDANCE ROLL Roll Name 1 2 3 4 5 6 7 8 ... 3 No. 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.

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: Roll Name No.

Month: Date input by the programmer

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

Sr no. 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Name of holiday Makarsankranti Republic Day Bakri-Id Mahashivratri Moharram • Good Friday • Dhuleti Mahavir Jayanti Bhagvan Shri Parshuram Jayanti Ide Milad Independence Day Parsi New Year Raksha Bandhan Janmashtami Samvantsari Gandhi Jayanti Dusshera Sardar Patel’s Birthday Diwali New Year Bhai Bij Gurunanak Jayanti Ramjan Id Christmas

Date

Month

Day

14 26 23 12 25 29

January January February March March March

Monday Saturday Saturday Tuesday Monday Friday

25 14

April May

Thursday Tuesday

25 15 21 22 31 10 02 15 31 04 05 06 19 06 25

May August August August August September October October October November November November November December December

Saturday Thursday Wednesday Thursday Saturday Tuesday Wednesday Tuesday Thursday Monday Tuesday Wednesday Tuesday Friday Wednesday

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 Principal

(Student’s signature)



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.



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.

 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.

 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 reportusing computer is far better than maintaining it manually.

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 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.

•

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

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 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.

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.

•

General constraint - Not applicable

DATA FLOW ANALYSIS It is concern with the information regarding: 1. 2. 3. 4.

Data used in the system Entry of data in the system Process that take place on data Storage of data

It has four main tools: a) Data flow diagrams b) Data dictionary

Used in requirement analysis

c) Data structure diagrams d) Structure charts

Used in system design

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

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. .

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. Output is largely dependent on the input.

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. b. c. d.

No system details are left out. Right problems are identified. Repetitive work is avoided. 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.

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

“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” -Cardinal Newman

ACKNOWLEDGEMENT

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 PARENTS for making capable of achieving what we don’t possess.

DOCUMENTATION TOOL PROJECT COORDINATOR

: MICROSOFT WORD :

MR.KAMLESH VAISHNAV

PROJECT SUPERVISOR

: MR.KAMLESH VAISHNAV

COUNSELOR

:

DATE OF COMMENCEMENT : DATE OF SUBMISSION

:

MR.UTPAL DHOLAKIYA

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

DATABASE FILES  Student_information Column name Roll_no Name

Data type Number Number

Size 3 30

Class Dept

Text Text

5 10

Current_address Phone_no1 City1 State1 Permanent_address Phone_no2 City2 State2

Text Text Number Text Text Text Number Text

120 20 15 15 120 20 15 15

Constraint Not null Primary key, not null Not null Primary key, not null Not null -

 Lecturer_information Column name Lecturer_name Dept Phone_no Current_address Permanent_address Phone_no1 City1 City2 Counselling_class

Data type Text Text Number Text Text Number Text Text Text

Size 50 10 20 70 70 20 20 20 5

Constraint Not null -

-

 Time_table Column name Day Dept Subject_code Class Period_start Period_end Course_Title Lecture_per_week Theory_practical Lecturer_name Session

Data type Text Text Text Text Number Number Text Number Text Text Number

Size 9 10 8 5 5 5 50 3 15 50 25

Constraint Not null Not null Not null Not null Not null Not null -

 Class_information Column name Dept Class

Data type Text Text

From_rollno To_rollno Room_no Counsellor_name

Number Number Number Text

Size 10 5

3 3 10 50

Constraint Not null Foreign key reference to student_information table Not null Not null Not null Not null

 Attendance_information Column name Class Date Dept APLStatus

Data type Text Date Text Text

Size 5 10 1

Constraint Not null -

 Leave_information Column name Class Roll_no

Data type Text Number

Reason From_date To_date Name Dept

Text Date Date Text Text

Size 5 3

30 50 10

Constraint Not null Foreign key reference to student_information table Not null Not null -

DATA DICTONARY Sr Column name no. 01 Roll_no

Student_information

02

Student_information

03

04

05

06

07

08

09

Data Size Description type Number 3 Use to store information of roll no of students Name Text 30 Use to store name of the student Class Text 5 Use to store class of the student Dept Text 10 Use to store department of the student Current_address Text 125 Use to store the current address of the student Phone_no1 Number 20 Use to store phone no of his current address City1 Text 15 Use to store name of the current city State1 Text 15 Use to store name of the current state Permanent_address Text 125 Use to store permanent address of the student

Database files used

Student_information

Student_information

Student_information

Student_information

Student_information

Student_information

Student_information

10

Phone_no2

Number 20

11

City2

Text

15

12

State2

Text

15

13

Lecturer_name

Text

50

14

Dept

Text

10

15

Phone_no

Number 20

16

Phone_no1

Number 20

17

Current_address

Text

70

18

Permanent_address Text

70

Use to store phone no of his permanent address Use to store name of the Permanent city Use to store name of the Permanent state

Student_information

Use to store name of the lecturer Use to store the department of the lecturer Use to store phone no of the current address of lecturer Use to store phone no of the permanent address of the lecturer Use to store the current address of the lecturer Use to store the permanent address of the lecturer

Lecturer_information

Student_information

Student_information

Lecturer_information

Lecturer_information

Lecturer_information

Lecturer_information

Lecturer_information

19

City1

Text

20

20

City2

Text

20

21

Class

Text

5

22

Dept

Text

10

23

Period_start

Text

5

24

Period_end

Text

5

25

Day

Text

9

Use to store the city name for current address of lecturer Use to store the city name for the permanent address of the lecturer Use to store name of class for which time table is given Use to store name of department for which timetable is given Use to store information about time when the period starts

Lecturer_information

Use to store information about time when the period ends Use to store day for the lecture

Time_table

Lecturer_information

Time_table

Time_table

Time_table

Time_table

26

Subject_code

Text

8

27

Course_title

Text

50

28

Lecture_per_week

Number 3

29

Theory_practical

Text

15

30

Lecturer_name

Text

50

31

Session

Text

25

32

Class

Text

5

Use to store the code of subject for which the timetable is given Use to store the name of the course for which timetable is given Use to store the no of times the lecture occurs in a week Use to store whether the given period is a theory or a practical Use to store the name of lecturer who takes the period Use to store the session whether it is morning or middle or afternoon Use to store class information

Time_table

Time_table

Time_table

Time_table

Time_table

Time_table

Class_information

33

Dept

Text

10

34

From_rollno

Number 3

35

To_rollno

Number 3

36

Room_no

Number 10

37

Counsellor_name

Text

50

Use to store the Departmen t information Use to store the starting roll no for the class Use to store the ending roll no for a class Use to store the information of room no of the class Use to store the name of the counselor for the class

Class_information

Class_information

Class_information

Class_information

Class_information

38

Date

Date

-

39

Class

Text

5

40

Dept

Text

10

41

APLStatus

Text

1

42

Reason

Text

30

43

From_date

Date

-

44

To_date

Date

-

45

Class

Text

5

46

Dept

Text

10

Use to store information about the date when the attendance is taken Use to store the class name whose attendance is to be taken Use to store department name whose attendance is to be taken Use to store the status of present or absent or leave Use to store information about the reason of leave Use to store information about the date from when the leave was taken Use to store information about the date until when the leave was taken Use to store the class of the student who has taken leave

Attendance_information

Attendance_information

Attendance_information

Attendance_information

Leave_information

Leave_information

Leave_information

Leave_information

Use to store Leave_information department of the student who has taken leave

47

Roll_no

Number

3

48

Name

Text

30

Use to store Leave_information the roll no of the student who has taken leave Use to store Leave_information the name of the student who has taken leave

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) (Date)

to

.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